Advanced Database207910 marksConstraints and characteristics of specialization and Genera
Design an EER model for library management system having generalization and specialization hierarchies. The EER model should have disjoint and overlapping constraints with at least one of the entities having total participation. Use your own assumption for other concepts. Now convert the EER diagram
Design an EER model for library management system having generalization and specialization hierarchies. The EER model should have disjoint and overlapping constraints with at least one of the entities having total participation. Use your own assumption for other concepts. Now convert the EER diagram into its equivalent relational model.[10]
- A Person is the superclass with two subclasses: Member and Staff (Generalization hierarchy, Disjoint -- a person is either a member or staff, not both) - A LibraryItem is the superclass with subclasses: Book, Journal, and DVD (Specialization hierarchy, Overlapping -- an item can be both a Book ...