2 ms·
Why was the line between Customers and Orders removed? Adding CustomerID to Orders just does the same thing. All they've done is remove the connection between
by Groxx 16y ago
Why was the line between Customers and Orders removed? Adding CustomerID to Orders just does the same thing.
All they've done is remove the connection between Products and OrderLines, which is partially rational in the real world: what if you want to give a discount? A partial refund? What if your products change prices at times? If you don't include the cost on the OrderLine, you've gotta handle version issues for every single instance.
As to the product name... why would it change? A new company took over the product? I'll bet it has a different cost, new packaging, and a new description. Is it really the same product? And, by disconnecting them, they've now lost any ability to do comparative analysis, recommendations, num-sold... anything meaningful aside from displaying the order.
If your only goal is display, just save the rendered webpage you presented them. It has as much meaning, and will always look the same. If it's doing anything with your data, normalize away.