Explain normalization

Question

Accepted Answer

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

Normalization involves breaking down data into smaller, more manageable parts.
It helps in reducing data redundancy by storing data in a structured way.
Normalization ensures data integrity by avoiding anomalies like insertion, update, and deletion anomalies.
There are different levels of normalization such as 1NF, 2NF, 3NF, and BCNF.
Example: In a database table, instead of storing customer details like name and address in multiple rows, normalization would involve creating a separate table for customer details and linking it to the main table using a unique identifier.

Popular interview questions of Softwaretest Engineer