What is normalization in dbms?
What is the normalization in DBMS and what is the purpose of it?
Normalization is a processes of splitting larger set of tables into smaller tables to reduce redundancy in the database (duplicate data).
It avoid insert, update and delete anomaly problems.
It can also avoid null values in the tables.
Normalization Improves the performance of queries.