Answer to Question #203213 in Databases | SQL | Oracle | MS Access for Yaw

Question

. Explain using an example how you would covert subtype/supertype relationships to relations in database design. 

Answer 1

• Subtypes relations are created, each having a primary key.
• Supertype relation is also created including a primary key.
• Each of the primary key of subtypes is then added to the supertype as a foreign key.