Question: What is the purpose of data normalization, and when would you use it?

Answer: Data normalization is the process of organizing data to reduce redundancy and dependency. It is used to eliminate data anomalies and improve data integrity.

Example:

Breaking down a large customer table into smaller tables like 'customers' and 'orders' to avoid repeating customer information for each order.