Searching for "supertype/subtype"

Q:

When mapping a supertype/subtype relationship which of the following is true?

A) The supertype primary key is assigned to each subtype. B) The subtype primary key is assigned to each supertype.
C) There is no link between the supertype/subtype entities. D) There is no primary key/foreign key relationship between a supertype/subtype.
 
Answer & Explanation Answer: A) The supertype primary key is assigned to each subtype.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

 A supertype/subtype hierarchy has which of the following features?

A) Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype. B) Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
C) Attributes are assigned at the highest logical level. D) Attributes are assigned at the lowest logical level.
 
Answer & Explanation Answer: C) Attributes are assigned at the highest logical level.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database