Explore BrainMass

Normalization and Denormalization

Explain why normalization is important. When is it important to denormalize a database? Can you provide an example/examples?

What is denormalization, and why can it be desirable? Provide an example.

Solution Preview

As databases have evolved and more and more critical data is being stored normalization is extremely important, not only for accurate reporting, but for size of the database. However, this can also put a strain on the disk subsystem as multiple joins may have to be utilized to obtain all of the information. For example: A table ...