Assignment 02 (20 points)
Develop an Enhanced Entity Relationship (EER) Diagram for each of the following
For a library, the entity type HOLDING has four subtypes: BOOK, AUDIO BOOK, DVD,
and SOFTWARE. Draw a separate
diagram segment for each of the following situations:
At a given time, a holding must be exactly one of these subtypes.
A holding may or may not be one of these subtypes. However, a holding that is one of
these subtypes cannot at the same time be one of the other subtypes.