Let us say that, in my business context, there are three different products, i.e., product
three, and I wish to offer price discounts when a condition like the following one takes place:
- If a customer buys 2 units of product
oneand 1 unit of product
two, I will give him a price discount of
x% on product
How should I model the situation described above in my database structure?