Difference between normalisation and de-normalisation?

Question

Accepted Answer

Normalization is the process of organizing data in a database while denormalization is the process of intentionally introducing redundancy into a database.

Normalization is used to minimize data redundancy and improve data integrity.
Denormalization is used to improve query performance by reducing the number of joins needed.
Normalization involves breaking down a table into smaller tables and establishing relationships between them.
Denormalization involves combining tables to reduce the number of joins needed.
Normalization is a standard practice in database design while denormalization is used selectively.
Example of normalization: dividing a customer table into separate tables for customer details and orders.
Example of denormalization: adding a calculated column to a table to avoid the need for a join.

Difference between normalisation and de-normalisation?

Top KONE Intern interview questions & answers

Popular interview questions of Intern

Top HR questions asked in KONE Intern