What is Normalization and why it is used?
Data Redundancy means when the same data is repeated again and again at multiple locations. As a result, deletion, insertion, and updating of the data become a tedious job and also a lot of space is also wasted. Normalization solves this problem by reducing the data redundancy.
There are 3 types of Normalization:-
- 1st Normal Form
- 2nd Normal Form
- 3rd Normal Form