What is database normalization?
In the simplest terms, database normalization, is the process of organizing the columns (attributes) and tables (relations). Database normalization seeks to put the columns and tables of a relational database into order so as to reduce data redundancy and improve data integrity.
Database Normalization is often referred to as simply normalization. Its primary objective is to design the database so that it achieves optimum structure. Database Normalization also reduces and eliminates redundant or repeated data. However, it may also have the effect of duplicating data within the database that may often result in the creation of additional tables.
Database normalization is intrinsic to relational database theory. It was proposed by Dr. Edgar F. Codd in 1970 as "a normal form for database relations."