In the context of owner and weak entity sets in the ER (Entity-Relationship)…

2024

In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?

  1. A.

    The weak entity set MUST have total participation in the identifying relationship

  2. B.

    The owner entity set MUST have total participation in the identifying relationship

  3. C.

    Both weak and owner entity sets MUST have total participation in the identifying relationship

  4. D.

    Neither weak entity set nor owner entity set MUST have total participation in the identifying relationship

Attempted by 1362 students.

Show answer & explanation

Correct answer: A

Key insight: a weak entity cannot be identified without an owner, so every weak entity must participate in the identifying relationship.

  • What a weak entity is: A weak entity depends on an owner (identifying) entity for its identity and typically has only a partial key.

  • Total participation requirement: Every member of the weak entity set must participate in the identifying relationship so it can be identified (this is total participation).

  • Owner participation: The owner entity set does not have to participate totally — some owner entities may not be related to any weak entity.

  • Short example: If "Dependent" is a weak entity of "Employee", every Dependent must be linked to some Employee, but an Employee may have no Dependents.

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Gate Guidance By Sanchit Sir