BCIS 4610 FINAL EXAM, UNT.
Conceptual Data Modeling - Answer- a detailed model that captures the overall structure of data in an organization
Two perspectives on data modeling: - Answer- -Top-down approach for a data model is derived from an intimate understanding of the business.
-Bottom-up...
BCIS 4610 FINAL EXAM, UNT.
Conceptual Data Modeling - Answer- a detailed model that captures the overall
structure of data in an organization
Two perspectives on data modeling: - Answer- -Top-down approach for a data model
is derived from an intimate understanding of the business.
-Bottom-up approach for a data model is derived by reviewing specifications
Entity-Relationship data model - Answer- A detailed, logical representation of the
entities, associations, and data elements for an organization or business area.
Entity - Answer- person, place, object, event or concept in the user environment
about which data is to be maintained
Entity type - Answer- collection of entities that share common properties or
characteristics
Entity instance - Answer- single occurrence of an entity type
Attribute - Answer- named property or characteristic of an entity that is of interest to
the organization
Multivalued attribute - Answer- an attribute that may take on more than one value for
each entity instance
Relationship - Answer- an association between the instances of one or more entity
types that is of interest to the organization
Degree - Answer- the number of entity types that participate in a relationship
Four key steps in logical database modeling and design: - Answer- -Develop
-Combine
-Translate
-Compare
Cloud computing - Answer- applications over the Internet where customers do not
have to invest in the hardware and software resources needed to run and maintain
the applications
Calculated fields - Answer- a field that can be derived from other database fields, a
computed field or derived field.
Data type - Answer- a coding scheme recognized by system software for
representing organizational data.
Default value - Answer- a value a field will assume unless an explicit value is entered
for that field.
, Denormalization - Answer- the process of splitting or combining normalized relations
into physical or combining normalized relations into physical tables based on affinity
of use of rows and fields.
Field - Answer- the smallest unit of named application data recognized by system
software.
File organization - Answer- a technique for physically arranging the records of a file.
Foreign key - Answer- an attribute that appears as a nonprimary key attribute in one
relation and as a primary key attribute in another relation
Functional dependency - Answer- a particular relationship between two attributes
Hashed file organization - Answer- a file organized in which the address of each row
is determined using an algorithm.
Homonym - Answer- a single attribute that is used for two or more different
attributes.
Synonym - Answer- two different names that are used for the same attribute.
Index - Answer- a table used to determine the location of rows in a file that satisfy
some condition.
Indexed file organization - Answer- a file organization in which rows are stored either
sequentially or nonsequentially, and an index is created that allows software to
locate individual rows.
Normalization - Answer- the process of converting complex data structures into
simple, stable data structures.
Null value - Answer- a special field value, distinct from zero, blank, or any value, that
indicates that the value for the field is missing or otherwise unknown.
Physical file - Answer- a named set of table rows stored in a contiguous section of
secondary memory.
Physical table - Answer- a named set of rows and columns that specifies the fields in
each row of the table.
Primary key - Answer- an attribute whose value is unique across all occurrences of a
relation.
Recursive foreign key - Answer- a foreign key in a relation that references the
primary key values of that same relation.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Freshy. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
