Normalization in Databases
The process of decomposing relations with anomalies to produce smaller, well structured relations
Types of Anomalies:
Insertion Anomalies:
Modification
Deletion Anomalies
Main goals of Normalization are as:
Minimize data redundancy
Simplify the enforcement of referential integrity constraints
Make it easier to maintain data (insert, update, and delete)
