Databases · Middle · Question 59 of 75
Why store an order's price at purchase time instead of always joining to the current product price?
- ✓Correct answer: Prices change; the order must keep what the customer actually paid
- 2It saves disk space
- 3Joins are not allowed between orders and products
Explanation
This isn't harmful duplication: it's a different fact (the historical price). The same goes for addresses on invoices.