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

Discussion

In all cases, normalization into BCNF is desirable.

  • A.True
  • B.False

Answer: B

Correct answer: False

Normalization removes modification anomalies at the cost of more tables, more joins and more complex SQL, and where anomalies cannot arise the cost buys nothing. A read-only database is the standard case, and reporting and warehouse designs are deliberately denormalized. BCNF is the usual target for an updateable database, not a universal rule.

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

Post your comment

Please log in or register to post a comment.