Eng Book- Normalization- Download Free PDF
o Often performed as a series of tests on a relation to
determine whether it satisfies or violates the
requirements of a given normal form.
o 4 most commonly used normal forms are first (1NF),
second (2NF), third (3NF) and Boyce-Codd (BCNF)
o Based on functional dependencies among the
attributes of a relation.
o A relation can be normalized to a specific form to
prevent the possible occurrence of update anomalies.