Question 1

Describe specialization and generalization.

Accepted Answer

The answer of Describe specialization and generalization....

Question 2

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

Accepted Answer

The answer of The main concern with redundant relationships is...

Question 3

What is an entity cluster?

Accepted Answer

The answer of What is an entity cluster?...

Question 4

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

Accepted Answer

The answer of The most common design trap is known...

Question 5

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

Accepted Answer

The answer of From a data modeling point of view,____________________...

Question 6

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

Accepted Answer

The answer of If you use a surrogate key,you must...

Question 7

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

Accepted Answer

The answer of Explain the "no change over time" characteristic...

Question 8

In what two cases are composite primary keys particularly useful?

Accepted Answer

The answer of In what two cases are composite primary...

Question 9

Composite keys are useful as identifiers of weak entities,where the weak entity has a strong ____________________ relationship with the parent entity.

Accepted Answer

The answer of Composite keys are useful as identifiers of...

Question 10

What do specialization hierarchies do?

Accepted Answer

The answer of What do specialization hierarchies do?...

Quiz 5: Advanced Data Modeling