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 31

Multiple Choice

Review LaterAdd Note

Review Later

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

A) self-referencing
B) 1:1
C) 1:M
D) M:N

E) None of the above
F) All of the above

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

keys work with primary keys to properly implement relationships in the relational model.

A) Foreign
B) Composite
C) Natural
D) Surrogate

E) A) and D)
F) A) and C)

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

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

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

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

relationships occur when there are multiple relationship paths between related entities.

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

A occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.

The " " characteristic of a primary key states that the primary key should not have embedded semantic meaning.

Specialization is based on grouping characteristics and relationships of the subtypes.

A occurs when there is one entity in two 1:M relationships to other entities, thus producing an association among the other entities that is not expressed in the model.

Explain the two criteria that help a designer in determining when to use subtypes and supertypes.

Which of the following is a specialization hierarchy disjoint constraint scenario in case of partial completeness?

What do specialization hierarchies do?

Usually, a data modeler uses a natural identifier as the of the entity being modeled, assuming that the entity has a natural identifier.

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

Disjoint subtypes are also known as subtypes.

According to the "preferably single-attribute" characteristic of a primary key, the primary key:

A is a primary key created by a database designer to simplify the identification of entity instances.