In converting a generalization hierarchy in an ERD to a relational database design,the parent and the subtypes at every level each become a table.

Question

Quizplus · Accepted Answer

In a relational database design, the generalization hierarchy is represented by a set of tables, where each table represents a subtype and contains the attributes specific to that subtype. The parent table contains the attributes common to all subtypes. Thus, the parent and the subtypes at every level each become a table.

In Converting a Generalization Hierarchy in an ERD to a Relational