Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.

What is normalization process in DBMS?

Normalization is the process of minimizing redundancy from a relation or set of relations. ... So, it helps to minimize the redundancy in relations. Normal forms are used to eliminate or reduce redundancy in database tables.

What is the main purpose of a Normalisation process?

Basically, normalization is the process of efficiently organising data in a database. There are two main objectives of the normalization process: eliminate redundant data (storing the same data in more than one table) and ensure data dependencies make sense (only storing related data in a table).