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
Answer: B. If Y is deleted, then X is also deleted — 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…
- A.
None of the above
- B.
If Y is deleted, then X is also deleted
- C.
If Y is deleted, then X is not deleted
- D.
If X is deleted, then Y is also deleted
Attempted by 1347 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: Iocl Engineers Officers Grade A Paper 2