What is Normalisation and it's types

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.
There are different levels of normalization, including first normal form (1NF), second normal form (2NF), and third normal form (3NF).
1NF involves eliminating duplicate columns and creating a primary key.
2NF involves ensuring that all non-key attributes are dependent on the primary key.
3NF involves removing transitive dependencies between non-key attributes.
Normalization helps to prevent data inconsistencies and anomalies.
Example: A customer table with customer name, address, and phone number can be normalized into a customer table and an address table.
Example: A product table with product name, description, and category can be normalized into a product table and a category table.

Top TransOrg Analytics Data Analyst interview questions & answers