Generalization, Specialization and Aggregation in DBMS
January 31, 2023
Generalization, Specialization and Aggregation in DBMS
On this page, we will learn about Generalization, Specialization and Aggregation in DBMS.
We will discuss each of them in brief.
What is the need for Generalization, Specialization and Aggregation in DBMS ?
With large databases it was realised that the ER model was become a little more complex and inconvenient to use.
Thus by programmers there were some additions in the ER model were suggested to reduce down on the complexity of the program, some new concepts were added which were –
Generalisation
Specialisation
Aggregation
We will learn more about them below –
What is Generalization
In generalization we combine lower level entities to form a higher level entity. Thus its clear that it follows a bottom up approach.
Example –
In a bank there are two different types of accounts – Current and Savings, combine to form a super entity Account.
It thus follows system like classes, like super-classes and sub-classes right ?
It may also be possible that the higher level entity may also combine with further entity to form a one more higher level entity.
Login/Signup to comment