Intermediate
Open
Pro
Normalising an Order System That Keeps Breaking Reports
An e-commerce team stores order_items with only product_id, qty,
and no price snapshot — the current price is looked up from products
at read time. Finance complains that historical revenue reports change
retroactively whenever a product's price is edited.
- Diagnose the modelling mistake.
- Propose the fix, and name which of normalisation/denormalisation it represents.
- What new problem does the fix introduce, and how do you handle it?
Share this question