Term
Q01:
What is an entity supertype?
Why is it used?
|
|
Definition
|
|
Term
Q02:
What kinds of data would you store in an entity subtype? |
|
Definition
|
|
Term
Q03:
What is specialization hierarchy? |
|
Definition
|
|
Term
Q04:
What is a subtype discriminator?
Give an example of its use. |
|
Definition
|
|
Term
Q05:
What is an overlapping subtype?
Give example. |
|
Definition
|
|
Term
Q06:
What is the difference between partial completeness and total completeness? |
|
Definition
|
|
Term
Q07:
Refer to fig. Q5.7...
List all of the attributes of a movie.
|
|
Definition
|
|
Term
Q08:
Refer to fig. Q5.7...
According to the data model, is it required that every entity instance in the PRODUCT table be associated with an entity instance in the CD table?
Why or why not? |
|
Definition
|
|
Term
Q09:
Refer to fig. Q5.7...
Is it possible for a book to appear in the BOOK table without appearing in the PRODUCT table?
Why or why not? |
|
Definition
|
|
Term
Q10:
What is an entity cluster?
What advantages are derived from its use? |
|
Definition
|
|
Term
Q11:
What primary key characteristics are considered desirable?
Explain why each characteristic is considered desirable. |
|
Definition
|
|
Term
Q12:
Under what circumstances are composite primary keys appropriate? |
|
Definition
|
|
Term
Q13:
What is a surrogate primary key? |
|
Definition
|
|
Term
|
Definition
|
|
