Machine-translated by Google. Questions are authored in English.
Top

Discussion

Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.

  • A.Functional dependency
  • B.Multi-valued dependency
  • C.Transitive dependency
  • D.Partial dependency

Answer: B

Correct answer: Multi-valued dependency

If one key has two independent one-to-many relationships in the same table, every combination of the two sets of values must be stored, and the two sets are unrelated to each other. That is a multi-valued dependency, and removing it is what fourth normal form is for.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.