Concept of Normalization

text zoom
Data normalization is a set of rules and techniques concerned with:

  • Identifying relationships among attributes.

  • Combining attributes to form relations.

  • Combining relations to form a database.

It follows a set of rules worked out by E FCodd in 1970. A normalized relational database provides several benefits:

  • Elimination of redundant data storage.

  • Close modeling of real world entities, processes, and their relationships.

  • Structuring of data so that the model is flexible.

Because the principles of normalization were first written using the same terminology as was used to define the relational data model this led some people to think that normalization is difficult. Nothing could be more untrue. The principles of normalization are simple, common sense ideas that are easy to apply.


Database Discussion


Database Source Code


Database Related Tutorials


New Database Resources


Copyright © 2015 VisualBuilder. All rights reserved