FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Advanced Data Modeling

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

Essay

Review LaterAdd Note

Review Later

What do specialization hierarchies do?

Correct Answer

verified

Entity supertypes and subtypes are organ...

View Answer

Show Answer

Question 43

True/False

Review LaterAdd Note

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

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

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

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

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.

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

Disjoint subtypes are also known as _____ subtypes.

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

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

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

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

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