Which of the following is used to specify whether the existence of an entity…
2017
Which of the following is used to specify whether the existence of an entity depends on its being related to another entity via the relationship type?
- A.
Entity integrity constraint
- B.
Foreign key constraint
- C.
Cardinality ratio
- D.
Participation constraint
Attempted by 526 students.
Show answer & explanation
Correct answer: D
The Participation Constraint specifies whether the existence of an entity depends on its being related to another entity via a relationship type. Total participation (existential dependency) means every entity in the set must participate, while partial participation means only some entities participate. Thus, Option D is correct.