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?

Answer: D. Participation constraintThe Participation Constraint specifies whether the existence of an entity depends on its being related to another entity via a relationship type. Total…

  1. A.

    Entity integrity constraint

  2. B.

    Foreign key constraint

  3. C.

    Cardinality ratio

  4. D.

    Participation constraint

Attempted by 985 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.

Explore the full course: Iocl Engineers Officers Grade A Paper 2

Loading lesson…