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

Discussion

Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.

  • A.True
  • B.False

Answer: A

Correct answer: True

Modification anomalies are not a theoretical nicety: they cause facts to be lost on deletion, facts to be unrecordable until unrelated ones are known, and the same value to be updated inconsistently in different rows. Normalizing to BCNF removes all of them, and that is why BCNF rather than 3NF is the working target.

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

Post your comment

Please log in or register to post a comment.