Normalization is the process of reducing redundancy in a database. Redundancy in the database, such as duplicate records, can cause anomalies such as updating or deleting records that are not needed. Normal forms are used to eliminate redundancy and improve the performance of the database. There are various types of normalization in DBMS:
1. First Normal Form: Client-side relationships and constraints must be denormalized to storage-side relationships and constraints.
2. Second Normal Form: A table is said to be in second normal form if it satisfies the requirements of first normal form and every column in the table is determined by a candidate key.
3. Third Normal Form: A table is said to be in third normal form if it satisfies the requirements of second normal form and no non-key attributes depend on other non-key attributes.