Which of the Following Is Not True About Representing Subtypes

question 78

Multiple Choice

Which of the following is not true about representing subtypes in a relational database design?

• A)One table is created for the supertype and one for each subtype.
• B)All of the attributes of the supertype are added to the subtype relations.
• C)The key of the supertype is made the key of the subtypes.
• D)A subtype and its supertype are representations of the same underlying table.
• E)An instance of the supertype may be related to one instance each of several subtypes.

---

Definitions:

Pitch

In music, refers to the perceived frequency of a sound; in sports, it's the playing surface for games like soccer and cricket.

Acute Mastoiditis

A bacterial infection affecting the mastoid bone behind the ear, usually a complication of chronic middle ear infections.

Right Ear

The auditory organ located on the right side of the head, responsible for detecting sound.

Impacted Cerumen

A condition where earwax accumulates to a degree that causes blockage or symptoms, often requiring medical intervention to remove.