Data Normalization splits up data to avoid redundancy (duplication) by moving commonly repeating groups of data into new tables.
Database Normalization Example
The following graphic gives an example of a typical conversion of an un-normalized table to multiple normalized tables.
Advantages of Database Normalization:
- Data integrity is maintained.
- Results of queries are predictable.
- Changes to data have to be made only once.
Amount of storage required by the database is optimal.
Read more reference: