What is Normalization?
Dr. Codd’s main focal points when designing the relational model were to further reduce data redundancy, reduce data anomalies and to improve data integrity within database systems.
It is a process that helps analysts or database designers to design table structures for an application. The focus of normalization is to attempt to reduce redundant table data to the very minimum. Through the normalization process, the collection of data in a single table is replaced, by the same data being distributed over multiple tables with a specific relationship being setup between the tables. By this process RDBMS schema designers try their best to reduce table data to the very minimum.
There are two reasons why database engineers go for normalization process-
- Eliminating redundant data
- Reducing insert/update/delete anomalies