The _________ of weak entity set distinguishes among all those entities in the…

2022

The _________ of weak entity set distinguishes among all those entities in the weak entity set that depends upon one particular strong entity.

  1. A.

    Primary key

  2. B.

    Discriminator

  3. C.

    Identifying Relationship

  4. D.

    Candidate key

Attempted by 994 students.

Show answer & explanation

Correct answer: B

In a weak entity set, the entity cannot be uniquely identified by its own attributes alone because it depends on a strong entity. The discriminator (also known as partial key) is used to distinguish among all entities in the weak entity set that depend on a particular strong entity. It is combined with the primary key of the strong entity to form the composite primary key of the weak entity. Primary key: This is used to uniquely identify entities in a strong entity set. However, in a weak entity set, the primary key alone cannot distinguish entities because it depends on the strong entity. Hence, it is not sufficient. Identifying relationship: This establishes the dependency between the weak and strong entity. It is necessary for the existence of the weak entity but does not help in distinguishing among the weak entities themselves. Candidate key: This is a minimal set of attributes that can uniquely identify an entity. In weak entities, candidate keys are not sufficient because they do not account for the dependency on the strong entity. Hence, they cannot distinguish entities in the weak set.

Explore the full course: Hpsc Pgt Computer Science