Database Normalization

Normalization refers to the process of eliminating redundant information and other problems in the database design. The goal of database normalization is to decompose relations with anomalies in order to produce smaller, well-structured relations

Denormalization is the process of attempting to optimize the read performance of a database by adding redundant data or by grouping data.