Exam 8: Data Modeling and Analysis

During requirements analysis, what order of model development is used to arrive at the logical data model?

A true entity:

A foreign key in the parent entity always matches the primary key in the child entity.

In ________________________ codes , each digit or group of digits describes a measurable or identifiable characteristic of the entity instance.

Which of the following is NOT a source for entity discovery?

The authors of your textbook recommend the use of intelligent keys since they can be quickly processed by humans without the assistance of a computer.

Another name for an alternate key is _____________________________ key.

Nonidentifying relationships are those in which each of the participating entities has its own independent primary key. That is, none of the primary key attributes is shared.

A recursive relationship is a relationship with a degree of infinity, because there is no limit to how many entities participate in the relationship.

All data model relationships are unidirectional.

An entity relationship diagram:

A data-to-location CRUD matrix is a table in which the rows indicate entities (and possible attributes); the columns indicate locations; and the cells (the intersection of the rows and columns) document level of access where C=create; R=read; U=update; and D=delete or deactivate.

Hierarchical codes provide a top-down interpretation for an entity instance by factoring an item into its group, subgroup and so forth.

A key is an attribute or group of attributes that assumes a unique value for each entity instance. It is sometimes called the domain of the attribute.

The data model for a single information system is usually called an application data model.

A compound attribute is one that actually consists of other attributes that are logically grouped together.

A ternary relationship is a relationship among three entities.

________________________________ defines the minimum and maximum number of occurrences of one entity for a single occurrence of the related entity.

Data modeling is a technique for organizing and documenting a system's logical and physical models.

The requirements analysis results in a logical data model that is developed in stages as follows: (1) context data model; (2) key-based data model; (3) fully attributed data model; and (4) the normalized data model.