Specialization in DBMS

  • Specialization is the process of defining a set of subclasses of an entity type; this entity type is called the superclass of the specialization.
  • The set of subclasses that forms a specialization is defined on the basis of some distinguishing characteristic of the entities in the superclass.

Specialization Example

the set of subclasses {SECRETARY, ENGINEER, TECHNICIAN} is a specialization of the superclass EMPLOYEE that distinguishes among employee entities based on the job type of each employee entity. We may have several specializations of the same entity type based on different distinguishing characteristics.

     specialization in DBMS