Explore BrainMass

Is database normalization enough?

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

The "right" database design can rarely be decided on the basis of normalization principle alone. Do you agree or disagree? Discuss.

© BrainMass Inc. brainmass.com October 25, 2018, 1:25 am ad1c9bdddf

Solution Preview

This is true. Normalization gives you a good foundation but ultimately the database design has to take into account the nature of the data being stored and how that data will be used. The usage pattern of the data must be used to achieve a balance between the benefits and overhead of normalization.

Normalization isn't "free". There is a certain amount of overhead incurred with higher levels of normalization due to the increased number of tables and constraints between the tables. This overhead is felt in several areas including the DBMS, DBA maintenance, and application code complexity.

A fully normalized database (3NF or higher) can require a lot of joining of tables when making a simple query since the constituent parts of the data ...

Solution Summary

This solution discusses whether or not database normalization is sufficient for creating the best database design for an application. Clear examples are provided.

See Also This Related BrainMass Solution

Normalization Techniques a Database

Generally, we use normalization techniques a database. using the Bowen et al. (2004) article, discuss the disadvantages of normalizing the database to a high degree of normalization, discuss whether there should be a hard and fast rule on when to stop normalizing.

View Full Posting Details