A company decided to award its customers a certain percentage of their total amount of the products they purchased. If the total purchase reaches
a specific amount the customer will be awarded for example 5% of the total amount as a gift or cash. The company is planning to perform this process every 3 or 4 months.
The company needs to know who the awarded customers are. How much? On which period of time they are awarded? The customer should not be awarded
twice for the same period of time.
Please I need your advice on how I can address the above scenario and come up with a way to satisfy this new requirement?
In the current system database there is a customer and invoice tables which represent the customers and their purchase.
View Complete Post