SQL - Database Design and Normalization
You have a denormalized table with redundant customer addresses. You notice inconsistent addresses for the same customer. What is the likely cause?
You have a denormalized table with redundant customer addresses. You notice inconsistent addresses for the same customer. What is the likely cause?
medium📝 Debug Q6 of 15
Step-by-Step Solution
Solution:
Step 1: Identify cause of inconsistent redundant data
In denormalized tables, redundant data must be updated everywhere to stay consistent.Step 2: Analyze options
Updates were not applied to all redundant rows correctly identifies missed updates as cause; others are incorrect or unrelated.Final Answer:
Updates were not applied to all redundant rows -> Option CQuick Check:
Inconsistent redundant data = missed updates [OK]
Quick Trick: Missed updates cause inconsistency in denormalized data [OK]
Common Mistakes:
- Assuming automatic consistency fixes
- Blaming normalization for denormalization issues
- Ignoring redundant data update needs
Master "Database Design and Normalization" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes