DATABASE NORMALIZATION

• the proces of cleansing; optimizing data and tables in a database, including reducing data redundancy, and leveraging data integrity.
• this process is usually done on RDB (Relational Databases)

Anamolies

• Update anomaly
• Insertion anomaly
• Deletion anomaly

1st 2nd and 3rd Normal Forms

• First Normal Form – The information is stored in a relational table with each column containing atomic values. There are no repeating groups of columns.

• Second Normal Form – The table is in first normal form and all the columns depend on the table’s primary key.

• Third Normal Form – the table is in second normal form and all of its columns are not transitively dependent on the primary key