What Are Normalizations In DBMS?

Normalization is a technique of designing databases to reduce the duplication of data. It is achieved by linking table through joins. The linked field(s) are called keys. Normalization can be done to 5 stages, however practically it is only done till the third normal form of 3NF.

1NF : Repeating groups are removed

2NF: Functional dependency is removed

3NF: Transitive dependency is removed

4NF: Multi-value dependency is removed.

First Normal Form - Atomic. That means there is no further divisions.
Example: Name have the divisions first name, last name and initial - so it is not in first normal form.

So we want to divide the fields in db as well as possible to follow normalization