What is normalization in DBMS?

Normalization is a process in database design that is used to organize data in a way that reduces data redundancy and improves data integrity. The goal of normalization is to separate data into multiple tables with clearly defined relationships between them. This helps to eliminate data inconsistencies and makes it easier to update and query the data. Normalization is typically performed using a series of rules, known as normal forms.

Normalization helps to reduce data duplication and improve data integrity by ensuring that data is stored in a logical and consistent manner.