What is an entity supertype, and why is it used?

What kinds of data would you store in an entity subtype?

What is a specialization hierarchy?

What is a subtype discriminator? Given an example of its use.

What is an overlapping subtype? Give an example.

What is the difference between partial completeness and total completeness?

List all of the attributes of a movie.

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?

Is it possible for a book to appear in the BOOK table without appearing in the PRODUCT table? Why or why not?

What primary key characteristics are considered desirable? Explain why each characteristic is considered desirable.

Under what circumstances are composite primary keys appropriate?

What is a surrogate primary key, and when would you use one?

When implementing a 1:1 relationship, where should you place the foreign key if one side is mandatory and one side is optional? Should the foreign key be mandatory or optional?

What are time-variant data, and how would you deal with such data from a database design point of view?

What is the most common design trap, and how does it occur?