Q2. what is 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 a database into smaller, more manageable tables.
Each table should have a primary key and only contain data that is related to that key.
Normalization helps to prevent data inconsistencies and anomalies.
There are different levels of normalization, with each level building on the previous one.
For example, first normal form (1NF) requires that each table have a primary key and that each column contains atomic values.
Second normal form (2NF) requires that each non-key column be dependent on the entire primary key.
Third normal form (3NF) requires that each non-key column be dependent only on the primary key and not on other non-key columns.

Top Bank of America Team Lead interview questions & answers