In a denormalized Sales table containing repeated CustomerEmail for each order, what issue might arise when updating a customer's email?

medium📝 query result Q4 of 15

SQL - Database Design and Normalization

In a denormalized Sales table containing repeated CustomerEmail for each order, what issue might arise when updating a customer's email?

AThe update will automatically propagate to all related tables

BSome rows may retain the old email causing inconsistent data

CThe database will reject the update due to normalization rules

DNo issues will occur since denormalization prevents redundancy

Step-by-Step Solution

Solution:

Step 1: Identify denormalization effect
Repeated data means multiple rows hold the same customer email.
Step 2: Consider update impact
Updating one row may not update all, causing inconsistent emails.
Final Answer:
Some rows may retain the old email causing inconsistent data -> Option B
Quick Check:
Redundant data updates can cause inconsistency [OK]

Quick Trick: Updates must be applied to all duplicates in denormalized tables [OK]

Common Mistakes:

Master "Database Design and Normalization" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes