Question

For schemas derived from strong entity sets, the _______ of the entity set serves as the primary key of the resulting schema

(a) First attribute

(b) Primary key

(c) Foreign key

(d) None of the mentioned

The question was asked during an interview.

My question is from Reduction to Relational Schema in section Database Design and the ER Model of RDBMS

Answer 1

Correct choice is (b) Primary key

To elaborate: For schemas derived from strong entity sets, the primary key of the entity set serves as the primary key of the resulting schema. This is because the primary keys are to be preserved as they are unique.