What is Normalisation?

Question

Accepted Answer

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

It involves dividing larger tables into smaller ones and defining relationships between them.
Normalization helps to eliminate data inconsistencies and anomalies.
There are different levels of normalization, such as first normal form (1NF), second normal form (2NF), and so on.
Normalization can improve database performance and make it easier to maintain.
Example: A customer table with repeated data like address can be normalized by creating a separate address table and linking it to the customer table.

Accepted Answer

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

It involves dividing larger tables into smaller ones and defining relationships between them.
Normalization helps to eliminate data inconsistencies and anomalies.
There are different levels of normalization, such as first normal form (1NF), second normal form (2NF), and so on.
Normalization can improve database performance and make it easier to maintain.

Top NTT Data Software Engineer interview questions & answers