What is normalization and what are the different forms of normalization?

Question

Accepted Answer

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

Normalization is used to eliminate data redundancy and ensure data integrity.
There are different forms of normalization such as First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF), and Boyce-Codd Normal Form (BCNF).
Each form of normalization has specific rules to follow in order to achieve a well-structured database.
For example, in First Normal Form (1NF), each column in a table must contain atomic values, and there should be no repeating groups.

Accepted Answer

Normalization is a database design technique to reduce redundancy and dependency by organizing fields and table relations. It divides larger tables into smaller tables and links them using relationships.

Forms of normalization:

1NF (First Normal Form): Ensures each column contains atomic values and each record is unique.
2NF (Second Normal Form): Meets 1NF and all non-key attributes are fully dependent on the primary key.
3NF (Third Normal Form): Meets 2NF and all attributes are directly dependent only on the primary key.

Asked in LTIMindtree

Top Software Engineer Interview Questions Asked at LTIMindtree

Interview Questions Asked to Software Engineer at Other Companies

Top Skill-Based Questions for LTIMindtree Software Engineer