πŸ’‘ Jump to Important Questions ↓

Important Questions

Important Questions

Enhanced Entity Relationship Model and Relational Model

Asked in 2081Short Question5 Marks
1.
Explain different constraints of specialization and generalization. [5]
Asked in 2080Short Question5 Marks
2.
Explain aggregation with suitable example. [5]
Asked in 2080Long Question10 Marks
3.
Explain different features of enhanced ER(EER) model. Compare specialization with generalization. [10]
Asked in 2079Short Question5 Marks
4.
What is aggregation? Explain with example. [5]
Asked in 2079Long Question10 Marks
5.
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]