SQL - Database Design and Normalization
A table has columns: ProductID, SupplierID, SupplierName, where SupplierName depends on SupplierID. How to fix the 3NF violation?
A table has columns: ProductID, SupplierID, SupplierName, where SupplierName depends on SupplierID. How to fix the 3NF violation?
medium📝 Debug Q7 of 15
Step-by-Step Solution
Solution:
Step 1: Identify transitive dependency
SupplierName depends on SupplierID, a non-key attribute, causing 3NF violation.Step 2: Normalize by splitting tables
Move SupplierID and SupplierName to a separate Supplier table to remove transitive dependency.Final Answer:
Create a separate Supplier table with SupplierID as primary key -> Option DQuick Check:
Separate related data to fix 3NF violations [OK]
Quick Trick: Fix 3NF by splitting tables to remove transitive dependencies [OK]
Common Mistakes:
- Adding non-key attributes to primary key
- Removing foreign keys incorrectly
- Making columns nullable to fix normalization
Master "Database Design and Normalization" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes