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…

  1. A.

    Weak entities can be deleted automatically when their strong entity is deleted.

  2. B.

    Weak entity set avoids the data duplication and consequent possible inconsistencies caused by duplicating the key of the strong entity.

  3. C.

    A weak entity set has no primary keys unless attributes of the strong entity set on which it depends are included

  4. 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.

Explore the full course: Tpsc Assistant Technical Officer

Loading lesson…