ER-Model

Question 19

Which of the following statements is TRUE?

A	The cardinality ratio for a binary relationship specifies the maximum number of relationship instances that an entity can participate in.
B	The cardinality ratio for a binary relationship specifies the minimum number of relationship instances that an entity can participate in.
C	The partial participation constraint is also called existence dependency.
D	The cardinality ratio for a relationship specifies the average number of relationship instances that an entity can participate in.

Database-Management-SystemER-ModelCIL Part – B

Question 19 Explanation:

Cardinality: cardinality ratio for a binary relationship specifies the maximum number of relationship instances that an entity can participate in.
Participation: Participation for a binary relationship specifies the minimum number of relationship instances that an entity can participate in.

Correct Answer: A

Question 19 Explanation:

Cardinality: cardinality ratio for a binary relationship specifies the maximum number of relationship instances that an entity can participate in.
Participation: Participation for a binary relationship specifies the minimum number of relationship instances that an entity can participate in.