Generalization, Specialization and Aggregation in ER Model
Q.1: What are Generalization, Specialization, and Aggregation in ER Model?
Answer:
Generalization is the higher level of understanding of data from lower levels of data whereas Specialization is the process of defining one or more entities from present entities and Aggregation is the process of combining two or more entities.
Q.2: What is the purpose of the Generalization?
Answer:
Generalization is simply gathering the common properties from entities and creating a generalized concept from those extracted data. Generalization helps in improving the flexibility, and reusability of the database.
Q.3: Why is generalization important in the database?
Answer:
Generalization is important in the database because it helps to gather important information so that it becomes easier and faster for the user the analysis of data and it also helps in making decisions faster.
Generalization, Specialization and Aggregation in ER Model
Using the ER model for bigger data creates a lot of complexity while designing a database model, So in order to minimize the complexity Generalization, Specialization, and Aggregation were introduced in the ER model and these were used for data abstraction in which an abstraction mechanism is used to hide details of a set of objects. Some of the terms were added to the Enhanced ER Model, where some new concepts were added. These new concepts are:
- Generalization
- Specialization
- Aggregation
Contact Us