Saturday, June 12, 2010

Normalisation

Database Normalization :

Within the Relational Database Model, a set of rules has been established


to aid in the design of tables that are meant to be connected through relationships.

This set of rules is known as Normalization.


Avoiding repetitive entries




Reducing required storage space



Preventing the need to restructure existing tables to accommodate new data.



Increased speed and flexibility of queries, sorts, and summaries.