Exam 5: Advanced Data Modeling

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

Disjoint subtypes are also known as _____ subtypes.

A subtype contains attributes that are common to all of its supertypes.

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

_____ completeness means that every supertype occurrence must be a member of at least one subtype.

At the implementation level, the supertype and its subtype(s) depicted in the specialization hierarchy maintain a 1:1 relationship.

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

In the context of total completeness, in a(n) _____, every supertype occurrence is a member of only one subtype.

The _____ specifies whether each entity supertype occurrence must also be a member of at least one subtype.

The _____ is the result of adding more semantic constructs to the original entity relationship (ER) model.

_____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.

An entity cluster is a "virtual" entity type used to represent multiple entities and relationships in the ERD.

A specialization hierarchy can have _____ level(s) of supertype/subtype relationships.

What do specialization hierarchies do?

Subtypes that contain nonunique subsets of the supertype entity set are known as _____ subtypes.