What is Normalization?

NORMALIZATION

Normalization is a design procedure for representing data in tabular format.

Two goals of Normalization process:

1. Eliminating redundant data -> storing the same data in more than one table.
2. Ensuring data dependencies make sense -> storing only the related data in a table.

For example,

> Let's say we store the subjects Tamil, English, and Computer Science data for the Students in the same table as Other students data.

> For this we keep repeating Tamil, English, and Computer Science for all students in the same area.

> Instead of storing same data again and again, we could normalize the data and create a related table called Subject.

> The "Subject" table could then store Tamil, English, and Computer Science along with Roll numbers that relate back to the Student table, and we can eliminate those three columns from the Student table and add the new Roll No. column.