Normalization

Database Dictionary -> Normalization

Normalization

Normalization is the process of arranging information in a way, which removes redundancy and ambiguity. Normalization involves arranging the data in related tables. There are three main forms of normalization representing different level of normalization. The 3 normal forms are: First Normal Form (1NF): In the First Normal Form each table column must contain different type of information. Second Normal Form (2NF): In the Second Normal Form any attribute not depending on the primary key in a table must be removed. Third Normal Form (3NF): In the Third Normal Form no duplicated data is allowed.

SQL Tutorial