Database Normalization ka Funda

Understand how Database Normalization works with Fullstackgada

Instagram icon More Diagrams

🔄 Data Redundancy ki Problem

Bhide ki Pareshani: Ek hi customer ka data baar-baar store ho raha hai. Update karne mein dikkat!
Upar ke buttons click karo aur dekho redundant aur normalized data ka fark!

📊 Normal Forms ka Explorer

Jethalal ka Gyaan: Alag-alag Normal Forms se data ko step-by-step clean karte hain!

🏠 Gokuldham Society ka Example

🤔
Koi Normal Form select karo aur Jethalal ka explanation dekho!

🎭 Step-by-Step Normalization ka Process

❌ Unnormalized Table (Problems ka Mela!)

OrderID CustomerName CustomerAddress Products ProductPrices CustomerCity CustomerPincode
1 Babita Gokuldham Society Soap, Shampoo 50, 120 Mumbai 400001
2 Babita Gokuldham Society Toothpaste 80 Mumbai 400001
3 Jethalal Gokuldham Society Fafda, Dhokla 30, 25 Mumbai 400001
Problems:
• Ek cell mein multiple values (Products, Prices)
• Customer data repeat ho raha hai (Data Redundancy)
• Babita ka address change ho toh dikkat
• Storage ka wastage

1️⃣ First Normal Form (1NF) - Atomic Values

OrderID CustomerName CustomerAddress Product ProductPrice CustomerCity CustomerPincode
1 Babita Gokuldham Society Soap 50 Mumbai 400001
1 Babita Gokuldham Society Shampoo 120 Mumbai 400001
2 Babita Gokuldham Society Toothpaste 80 Mumbai 400001
3 Jethalal Gokuldham Society Fafda 30 Mumbai 400001
3 Jethalal Gokuldham Society Dhokla 25 Mumbai 400001
✅ 1NF Done: Har cell mein sirf ek value!
Jethalal: "Ek cell mein ek hi cheez - comma wala mix-up nahi!"

2️⃣ Second Normal Form (2NF) - Partial Dependencies Hatao

📋 Orders Table
OrderID CustomerID ProductID
1101201
1101202
2101203
3102204
3102205
👥 Customers Table
CustomerID CustomerName CustomerAddress City Pincode
101BabitaGokuldham SocietyMumbai400001
102JethalalGokuldham SocietyMumbai400001
🛍️ Products Table
ProductID ProductName Price
201Soap50
202Shampoo120
203Toothpaste80
204Fafda30
205Dhokla25
✅ 2NF Done: Partial dependencies hata di!
Jethalal: "Customer info bas CustomerID pe depend kare, Product info bas ProductID pe!"

3️⃣ Third Normal Form (3NF) - Transitive Dependencies Hatao

👥 Customers Table (Updated)
CustomerID CustomerName CustomerAddress LocationID
101BabitaGokuldham Society1
102JethalalGokuldham Society1
📍 Locations Table (New)
LocationID City Pincode
1Mumbai400001
✅ 3NF Done: Transitive dependencies hata di!
Jethalal: "City aur Pincode pe depend karta hai, toh Locations table alag banaya!"

⚖️ Normalization vs Denormalization

Aspect ✅ Normalization ⚡ Denormalization
Data Redundancy Minimum duplication Speed ke liye jaan bujhkar duplication
Storage Space Kam storage chahiye Zyaada storage chahiye
Query Performance JOINs chahiye (thodi slow reading) Direct access (fast reading)
Data Consistency High consistency Inconsistency ka risk
Updates Ek jagah update karo (aasaan) Kayi jagah update karna padta hai (mushkil)
Best For OLTP systems, frequent updates ke liye OLAP systems, reporting, read-heavy ke liye
Jethalal ki Salah: Jaise garmi mein AC mast lagta hai, par bijli gayi toh pankha kaam aata hai! Waise hi normalization generally better hai, par reporting ke liye kabhi-kabhi denormalization bhi karna padta hai.