Normalization (Summary)

Normalization is the process of organizing the columns (attributes) and tables (relations) of a relationaldatabase to minimize data redundancy.Edgar F.Codd,the inventor of the relational model introduced aconceptual model of normalization.There are First normal form (1NF), Second normal form (2NF) and Third normal form (3NF).

First Normal Form (1NF): No repeating elements or groups of elements

Don't repeat your columns.

Second Normal Form (2NF): No partial dependencies on a concatenated key

This is a complex way of saying that if a column isn’t intrinsically related to the entire primary key, then you should break out the primary key into different tables.

Third Normal Form (3NF): No dependencies on non-key attributes

2NF covers the case of multi column primary keys. 3NF is meant to cover single column keys. Simply stated, pull out columns that don’t directly relate to the subject of the row (the primary key), and put them in their own table.

This Is example of normalization