Question

The primary key of the representation of a weak entity set consists of the primary key of the strong entity set and the _______

(a) Discriminator of the weak entity set

(b) Foreign key

(c) Primary key of all the other entity sets

(d) All the attributes of the weak entity set

This question was posed to me in an online interview.

This question is from Reduction to Relational Schema topic in portion Database Design and the ER Model of RDBMS

Answer 1

Right choice is (a) Discriminator of the weak entity set

The best I can explain: The primary key of the representation of a weak entity set consists of the primary key of the strong entity set and the discriminator of the weak entity set.