Prerequisite – Introduction of ER Model
Generalization, Specialization and Aggregation in ER model are used for data abstraction in which abstraction mechanism is used to hide details of a set of objects.
Generalization is the process of extracting common properties from a set of entities and create a generalized entity from it. It is a bottom-up approach in which two or more entities can be generalized to a higher level entity if they have some attributes in common. For Example, STUDENT and FACULTY can be generalized to a higher level entity called PERSON as shown in Figure 1. In this case, common attributes like P_NAME, P_ADD become part of higher entity (PERSON) and specialized attributes like S_FEE become part of specialized entity (STUDENT).
In specialization, an entity is divided into sub-entities based on their characteristics. It is a top-down approach where higher level entity is specialized into two or more lower level entities. For Example, EMPLOYEE entity in an Employee management system can be specialized into DEVELOPER, TESTER etc. as shown in Figure 2. In this case, common attributes like E_NAME, E_SAL etc. become part of higher entity (EMPLOYEE) and specialized attributes like TES_TYPE become part of specialized entity (TESTER).
An ER diagram is not capable of representing relationship between an entity and a relationship which may be required in some scenarios. In those cases, a relationship with its corresponding entities is aggregated into a higher level entity. For Example, Employee working for a project may require some machinery. So, REQUIRE relationship is needed between relationship WORKS_FOR and entity MACHINERY. Using aggregation, WORKS_FOR relationship with its entities EMPLOYEE and PROJECT is aggregated into single entity and relationship REQUIRE is created between aggregated entity and MACHINERY.
This article is contributed by Sonal Tuteja. If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Difference between Generalization and Specialization in DBMS
- Basic approaches for Data generalization (DWDM)
- Constraints on Generalization
- Difference between Relational model and Document Model
- Difference between E-R Model and Relational Model in DBMS
- Difference between Bottom-Up Model and Top-Down Model
- Mapping from ER Model to Relational Model
- Types of Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)
- Introduction of Relational Model and Codd Rules in DBMS
- JDBC Using Model Object and Singleton Class
- Difference between ER Model and RDBMS
- Difference between Hierarchical and Relational data model
- Difference between Hierarchical and Network Data Model
- Difference between Network and Relational data model
- Difference between Hierarchical, Network and Relational Data Model
- Introduction of ER Model
- Relational Model in DBMS
- Anomalies in Relational Model
- Layers of OSI Model
- TCP/IP Model