Which of the following statements is FALSE about weak entity set?
2015
Which of the following statements is FALSE about weak entity set?
Answer: D. Tuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set. — CONCEPTA weak entity set cannot be uniquely identified by its own attributes alone and is existence-dependent on an owner (strong) entity set. Its partial key…
- A.
Weak entities can be deleted automatically when their strong entity is deleted.
- B.
Weak entity set avoids the data duplication and consequent possible inconsistencies caused by duplicating the key of the strong entity.
- C.
A weak entity set has no primary keys unless attributes of the strong entity set on which it depends are included
- D.
Tuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set.
Attempted by 658 students.
Show answer & explanation
Correct answer: D
CONCEPT
A weak entity set cannot be uniquely identified by its own attributes alone and is existence-dependent on an owner (strong) entity set.
Its partial key distinguishes weak entities belonging to the same owner; the owner key together with the partial key identifies an occurrence.
APPLICATION
Apply these two rules to each statement: check whether it preserves existence dependence and whether it keeps each weak-entity occurrence associated with a particular owner occurrence.
CONTRAST
Deletion may cascade from an owner to its existence-dependent weak entities when that lifecycle rule is enforced.
Modeling the dependent object as weak avoids giving it a redundant independent copy of the owner identifier merely to make it strong.
A partial key becomes identifying only in combination with the key of the strong entity set.
The identifying relationship associates weak-entity occurrences with specific strong-entity occurrences, so the occurrences are grouped by that relationship.
CROSS-CHECK
Imagine Employee as the strong entity and Dependent as the weak entity. A dependent name may repeat for different employees, so EmployeeId plus DependentName identifies the dependent, and each dependent belongs under one employee.
Therefore, the statement that weak-entity tuples are not partitioned according to their relationship with strong-entity tuples is the false statement.
A video solution is available for this question — log in and enroll to watch it.