erm types constraints

mcqspedia.com has 5 Question/Answers about Topic erm types constraints

Constraint which specifies minimum number of relationship instances is classified as

Constraint which specifies minimum number of relationship instances is classified as
  • A. participation constraint
  • B. non-participation constraint
  • C. extensive constraint
  • D. intensive constraint
  • Correct Answer: Option A

For a relationship type, participation constraints and cardinality ratio are considered together to make

For a relationship type, participation constraints and cardinality ratio are considered together to make
  • A. intensive constraints
  • B. recursive constraints
  • C. composite constraints
  • D. structural constraints
  • Correct Answer: Option D

Relationship type in which one attribute is migrated to N-side of relationship is classified as

Relationship type in which one attribute is migrated to N-side of relationship is classified as
  • A. 4:N
  • B. 3:N
  • C. 1:N
  • D. 2:N
  • Correct Answer: Option C

Types of partial constraints are

Types of partial constraints are
  • A. total and partial
  • B. intensive and extensive
  • C. minimum and maximum
  • D. floating and string
  • Correct Answer: Option A

Considering binary relationships, possible cardinality ratios are

Considering binary relationships, possible cardinality ratios are
  • A. one : one
  • B. 1 : N
  • C. M : N
  • D. all of above
  • Correct Answer: Option D