In E-R model, Y is the dominant entity and X is subordinate entity

2018

In E-R model, Y is the dominant entity and X is subordinate entity

  1. A.

    None of the above

  2. B.

    If Y is deleted, then X is also deleted

  3. C.

    If Y is deleted, then X is not deleted

  4. D.

    If X is deleted, then Y is also deleted

Attempted by 803 students.

Show answer & explanation

Correct answer: B

In the Entity-Relationship (E-R) model, a subordinate entity depends on a dominant entity for its existence. This implies that the subordinate entity cannot exist independently without the dominant entity being present in the database. Consequently, if the dominant entity is deleted, the subordinate entity must also be removed to maintain referential integrity.

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

Explore the full course: Isro