A weak entity set Dependent is identified through its owner entity Employee. What is the attribute set that distinguishes dependents of the same employee from each other called?
Correct answer A. Discriminator (partial key)
Explanation
A weak entity set has no primary key of its own. Its discriminator, also called the partial key, separates the weak entities that belong to one owner; dependent_name is a typical example. The full primary key is the owner's primary key plus the discriminator. A foreign key is a relational concept that appears after mapping, and a superkey must identify entities uniquely on its own.
Answer checked How we write and check questions
Discussion