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

The "_____" characteristic of a primary key states that the selected primary key must not be composed of any attribute(s) that might be considered a violation.

A) unique values
B) nonintelligent
C) preferably single-attribute
D) security-compliant

E) None of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

A(n) _____ is a generic entity type that is related to one or more entity subtypes.

A) subtype discriminator
B) inheritance
C) specialization hierarchy
D) entity supertype

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

In specialization hierarchies with multiple levels of supertype and subtypes, a lower-level subtype can inherit only a few of the attributes and relationships from its upper-level supertypes.

A(n) _____ 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 property of a subtype discriminator enables an entity supertype to inherit the attributes and relationships of the subtype.

The relationships depicted within the specialization hierarchy are sometimes described in terms of "is-a" relationships.

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

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

One practical advantage of a(n) _____ key is that because it has no intrinsic meaning, values for it can be generated by the DBMS to ensure that unique values are always provided.

An entity cluster is considered "virtual" or "_____" in the sense that it is not actually an entity in the final ERD.

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

Entity supertypes and subtypes are organized in a specialization hierarchy.

Implementing overlapping subtypes requires the use of one discriminator attribute for each subtype.

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

The "_____" characteristic of a primary key states that the primary key must uniquely identify each entity instance, must be able to guarantee unique values, and must not contain nulls.

Entity subtypes do not inherit the relationships in which the supertype entity participates.

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

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

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

The main concern with redundant relationships is that they remain _____ across the model.