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. |
Total Members
Delicious
Digg
Technorati
Blink
Furl
Reddit
Newsvine
Google
