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

Discussion

We can eliminate modification anomalies with proper normalization that results in tables in BCNF.

  • A.True
  • B.False

Answer: A

Correct answer: True

Anomalies arising from functional dependencies come from determinants that are not candidate keys, and BCNF is defined precisely by the absence of those. Removing them removes the anomalies. Multivalued dependencies are a separate source and need fourth normal form, but for the functional case BCNF is sufficient.

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

Post your comment

Please log in or register to post a comment.