Machine-translated by Google. Questions are authored in English.
Top

Discussion

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: A

Correct answer: The supertype primary key is assigned to each subtype.

Each subtype becomes a relation whose primary key is the supertype’s primary key, which is also a foreign key referring back to it. This is what makes the subtype row and the supertype row the same entity seen twice, and it is why a subtype instance cannot exist without its supertype instance.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.