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

Discussion

Denormalized tables are in BCNF.

  • A.True
  • B.False

Answer: B

Correct answer: False

Denormalized is precisely the opposite of BCNF: the tables have been recombined, or left combined, so that determinants which are not candidate keys remain. That is done deliberately to avoid joins, and it is a reasonable choice for read-only data, but it means accepting the duplication and the anomalies that BCNF would have removed.

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

Post your comment

Please log in or register to post a comment.