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

Discussion

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

  • A.A → B.
  • B.A → C.
  • C.A → (B,C).
  • D.(B,C) → A.

Answer: A

Correct answer: A → B.

A functional dependency holds when each value of the determinant is always paired with one and the same value of the dependent attribute. Here A always brings the same B, so A determines B; but A appears with different values of C, so A does not determine C, and it cannot determine the pair (B, C) either. The last option reverses the direction, for which the data give no evidence.

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

Post your comment

Please log in or register to post a comment.