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

...more

Database Source Code

...more

Database Related Tutorials

...more

New Database Resources

...more

Copyright © 2014 VisualBuilder. All rights reserved