Purchase Solution

Is database normalization enough?

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

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.

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 ...

Purchase this Solution


Free BrainMass Quizzes
Javscript Basics

Quiz on basics of javascript programming language.

C# variables and classes

This quiz contains questions about C# classes and variables.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Networking Questions

This quiz consists of some basic networking questions.