What is normalisation? Explain different types of normalisation.

Question

Accepted Answer

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

Normalization involves breaking down a database into smaller, more manageable tables and defining relationships between them.
There are different normal forms such as 1NF, 2NF, 3NF, BCNF, and 4NF, each with specific rules to ensure data integrity.
Normalization helps in reducing data redundancy, improving data consistency, and making the database more efficient.
For example, in 1NF, each column in a table must contain atomic values, and in 2NF, it should be in 1NF and all non-key attributes are fully functional dependent on the primary key.