What is normalization in DBMS?

Normalization is referred to process of organizing the data in the database. It helps in getting rid of redundant data from a relation or a set of relations.

• It is helpful in dividing a larger table into smaller tables and linking them using relationships.
• It avoids problems regarding data integrity and removing anomalies from the database.

Normalization is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies. Normalization rules divides larger tables into smaller tables and links them using relationships.

The purpose of Normalization in SQL is to eliminate redundant (repetitive) data and ensure data is stored logically.