Specialization in DBMS

 

What is Specialization in DBMS?

Specialization:

A specialization is the reverse process of Generalization. Means creating new subclass from an existing class. Lets take an example of bank account. A bank account is of two types: Current account and saving account. Current account and saving account inherits the common Generalized property like account number, Account balance, etc. from a bank account, and also have their own specialized properties like interest rate, etc.

In specialization and entities 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. In this case, common attributes like E_NAME,E_SAL etc. Become part of higher entity (EMPLOYEE) and specialized attribute like TES_TYPE, become part of a specialized entity (TESTER).

Conclusion-

These were some of the point discussed in the post- Specialization in DBMS.

There is more coming with the next post keep reading...