What is Normalisation in DBMS?
Normalization is a process in database management systems (DBMS) that is used to minimize data redundancy and improve data integrity. Normalization is the process of organizing data in a database so that data is stored only once, and relationships between data elements are established through the use of foreign keys.

The goal of normalization is to reduce data redundancy and improve data consistency by ensuring that each data element is stored in only one place, and by ensuring that the relationships between data elements are properly defined. This helps to avoid data inconsistencies, such as multiple copies of the same data, and it makes it easier to maintain and update the database over time.

There are several levels of normalization, ranging from First Normal Form (1NF) to Fifth Normal Form (5NF). Each level of normalization imposes a set of rules and constraints on the data in the database to ensure that it is properly structured and optimized for efficient data retrieval and modification.

Normalization is an important process in database design, and it is used by many organizations to ensure that their databases are well-structured, consistent, and easy to maintain and update over time.