Exam 8: Data Modeling Advanced Concepts

If you use a surrogate key, you must ensure that the candidate key of the entity in question performs properly through the use of the "____________________" and "not null" constraints.

What is an entity cluster?

What do specialization hierarchies do?

The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).

The preferred placement for a foreign key when working with a 1:1 relationship is to ____.

Generalization is based on grouping unique characteristics and relationships of the subtypes.

Explain the "no change over time" characteristic of a good primary key.

Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the ____ relationship.

An entity cluster is formed by combining multiple interrelated entities into ____.

The primary key's main function is to uniquely identify a(n) ____ within a table.

From a data modeling point of view, ____________________ data refer to data whose values change over time and for which you must keep a history of the data changes.

____________________ completeness means that not every supertype occurrence is a member of a subtype.

The most common design trap is known as a(n) ____________________.

One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.

The extended entity relationship model (EERM) is sometimes referred to as the ____.

Partial completeness is symbolized by ____.

Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity set.

The property of subtype discriminator enables an entity supertype to inherit the attributes and relationships of the subtype.

The most important characteristic of an entity is its ____ key, used to uniquely identify each entity instance.

Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype.