What is Normalisation and Denormalisation? When do we use them? Give a real-time example that is implemented in your project.

Question

Accepted Answer

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

Normalisation is used to eliminate data redundancy and improve data integrity.
Denormalisation is used to improve query performance by reducing the number of joins required.
A real-time example of normalisation is breaking down a customer's information into separate tables such as customer details, order details, and payment details.
A real-time example of denormalisation is combining the customer details, order details, and payment details into a single table for faster query performance.

What is Normalisation and Denormalisation? When do we use them? Give a real-time example that is implemented in your project.

Top 7 Eleven Senior Data Engineer interview questions & answers

Popular interview questions of Senior Data Engineer

Top HR questions asked in 7 Eleven Senior Data Engineer