Normalization is the process of efficiently organizing data in a DATABASE. The two goals of the normalization process are eliminate redundant data (storing the same data in more than one table) and ensure data dependencies make SENSE (only storing related data in the table).

FIRST normalization form:

• Eliminate duplicate columns from the same table.
• Create separate tables for each group of related data and identify each row with a unique column or set of columns (primary key).

Second normal form:

• Removes sub set of data that apply to multiple rows of table and place them in separate table.
• Create relationships between these new tables and their predecessors through the use of FOREIGN keys.

THIRD normal form:

• Remove column that are not dependent upon the primary key.

Normalization is the process of efficiently organizing data in a database. The two goals of the normalization process are eliminate redundant data (storing the same data in more than one table) and ensure data dependencies make sense (only storing related data in the table).

First normalization form:

Second normal form:

Third normal form: