---

NORMALIZATION

---

Breaking a complex table structures into simple table structures by using some specific rules is called normalization.

Why we need the normalization?

1:It reduces the redundancy in a table.
2: Reduce the complex user view to a set of small and stable sub groups by this method we can design a logical data model this is also called conceptual data model.
3: During the modification no need of reorganization of data.

The most important and widely used normalization forms are.

1:First Normal form

2: Second Normal form

3: Third Normal form

4: BCNF (Boyce - Codd Normal form)

Different Levels of normalization

Different Levels of Normalization

---