A supertype/subtype hierarchy is which of the following?
A. Each subtype has only one attribute
B. Each supertype has only one attribute
C. Each subtype has only one supertype
D. Each supertype has only one subtype
Answer:A
A supertype/subtype hierarchy is which of the following?
A. Each subtype has only one attribute B. Each supertype has only one attribute C. Each subtype has only one supertype D. Each supertype has only one subtype
Explanation: Two entities are of distinct types if they have no attributes in common. It is possible for entities to have both common and distinct attributes. If they have a common identifier (that is, a common primary key), they have a special supertype-subtype relationship: they are neither distinct nor the same.