What is difference between generalization and specialization in DBMS?

Answer 1

DBMS: Data Base Management System

generalization and specialization are important relationships that exist betweena higher level entity set and one or more lower level entity sets.

1. generalization is the result of taking the union of two or more lower level entity sets to produce a higher level entity sets.

specialization is the results of taking subsets of a higher level entity set to form a lower level entity sets.

2. In generalization,each higher level entity must also be a lower level entity.

In specialization,some higher level entities may not have lower-level entity sets at all.

3. Specialization is a Top Down process where as Generalization is Bottom Up process.