Question #203213
. Explain using an example how you would covert subtype/supertype relationships to relations in database design.
Expert's answer
- 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.
