Answer to Question #219060 in Databases | SQL | Oracle | MS Access for stan

Question

A subtype/supertype relationships are especially important in Enhanced Entity Relationship Modeling. Explain using an example how you would covert subtype/supertype relationships to relations in database design.

Answer 1

When doing a Supertype or subtype relationship in the database, there is a need to form separate tables for the General entity types and some different table tables for the Specialized entities. For example;