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?
- A.
The weak entity set MUST have total participation in the identifying relationship
- B.
The owner entity set MUST have total participation in the identifying relationship
- C.
Both weak and owner entity sets MUST have total participation in the identifying relationship
- 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.