Question: A supermarket needs to develop the following software to encourage customer loyalty For this loyalty scheme each customer needs to supply his/her residence address, telephone

 A supermarket needs to develop the following software to encourage customer

loyalty For this loyalty scheme each customer needs to supply his/her residence

A supermarket needs to develop the following software to encourage customer loyalty For this loyalty scheme each customer needs to supply his/her residence address, telephone number, and the driving license number. Each customer who registers for this scheme is assigned a unique customer number (CN) by the computer. A customer can present their number to the checkout staff when they make any purchases. In this case the value of the purchase is credited against the Customer Number. At the end of each year, the supermarket intends to award surprise gifts to 10 customers who make the highest total purchase over the year. Also, it intends to award a gold coin to every customer whose purchase exceeded 10,000. The entries against the CN are reset each year after the prize winners' lists are generated

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!