Data Modeling & Warehousing Fundamentals

Back to Foundations: Why Models Matter

Quiz: When to Normalize and When to Stop

The textbook says 3NF. The warehouse says 'usually denormalize'. Both are right — for different reasons.

7 minutesInteractive tutorial

🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.

Question 1 of 9Answer saved0 answered

Your e-commerce OLTP database has a table `orders(order_id, customer_id, customer_name, customer_email, ...)`. Which normal form does this violate?

← Back to Database Normalization — 1NF Through 5NF (and When to Stop)