Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Wednesday, July 5, 2017

General advice needed - database design - Is this a bad way to design a pricing table?

SQLServerCentral » Latest topics
General advice needed - database design - Is this a bad way to design a pricing table?

Suppose we are selling bottles of water that can be bought in sizes of 1 to 10 litres (1, 2, 3, etc...) . In this example the customer can buy up to 4 bottles of a single size (1, 2, 3 or 4 bottles).

Ignoring the fact that a formula can be use

No comments: