Explore BrainMass

Explore BrainMass

    Is database normalization enough?

    This content was COPIED 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 9, 2019, 11:38 pm 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.