1.

What is Normalization and why it is used?

Answer»

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
  • BCNF


Discussion

No Comment Found

Related InterviewSolutions