Advanced Database Systems - Unit 4 - Review Questions

Advanced Database Systems - Unit 4 - Enhanced Entity Relationship Modeling

1. What is a subclass? When is it used in data modeling?
2. Define the following terms:
   1. subclass
   2. superclass of a subclass
   3. superclass/sublcass relationship
   4. is-a relationship
   5. specialization
   6. generalization
   7. category
   8. specif (local) attributes
   9. specific relationships
3. Write a short note on the attribute/relationship inheritance mechanism.
4. Distinguish between user-defined and predicate-defined subclasses.
5. Distinguish between user-defined and attribute-defined specializations.
6. What are the main types of constraints on specializations and generalizations?
7. Distinguish between specialization hierarchy and specialization lattice.
8. Distinguish between specialization and generalization.
9. What is a category? How does it differ from a regular shared subclass?
10. Distinguish between ER and EER modeling.

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 2.5 License.