Questions from Database Systems

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

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

Q: What is a specialization hierarchy?

What is a specialization hierarchy?

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

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

Q: What is an overlapping subtype? Give an example.

What is an overlapping subtype? Give an example.

Q: What is the difference between partial completeness and total completeness?

What is the difference between partial completeness and total completeness?

Q: List all of the attributes of a movie.

List all of the attributes of a movie.

Q: According to the data model, is it required that every entity

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?

Q: Is it possible for a book to appear in the BOOK table

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

Q: What is normalization?

What is normalization?

Q: What three data anomalies are likely to be the result of data

What three data anomalies are likely to be the result of data redundancy? How can such anomalies be eliminated?