What is Normalisation and basic nf forms

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 table into smaller tables and defining relationships between them.
The goal of normalization is to eliminate redundant data and ensure data dependencies make sense.
There are different normal forms (NF) such as 1NF, 2NF, 3NF, BCNF, and 4NF, each with specific rules to follow.
For example, 1NF requires that each column in a table must contain atomic values, and 2NF requires that all non-key attributes are fully functional dependent on the primary key.

Top Velocis Systems ETL Developer Lead interview questions & answers