Normalizing A Table

Normalizing a table means organizing the data to reduce redundancy. This is done by following a set of rules known as normal forms, which break data into smaller, related tables and establish relationships using primary keys and foreign keys.

Example of Normalization

Denormalized Table (Repeating Data)

Date	Customer_ID	Customer_Name	Order_ID	Product_ID	Product	Quantity	Price
2025-05-25	101	Alice	1	1	Laptop	1	1000
2025-05-25	101	Alice	1	2	Mouse	1	50
2025-05-29	102	Bob	2	3	Phone	1	700

Normalized Tables

1. Orders Table

Date	Order_ID	Customer_ID
2025-05-25	1	101
2025-05-29	2	102

2. Customers Table

Customer_ID	Customer_Name
101	Alice
102	Bob

3. Order_Details Table

Order_ID	Product	Quantity	Price
1	Laptop	1	1000
1	Mouse	1	50
2	Phone	1	700

Now, customers and orders are stored separately, reducing redundancy and improving data consistency.