Normalization

Eliminate various anomalies
Repetition anomaly, Update anomaly, Insertion anomaly, Deletion anomaly.
The normal forms are based on certain dependency structures. BCNF and lower normal forms are based on functional dependencies (FDs), 4NF is based on multivalued dependencies, and 5NF is based on projection-join dependencies.

Leave a Reply

Your email address will not be published. Required fields are marked *