Question: Q1. Create an EDD and a CDD based on the information below. (8 marks) Random Books Tax Invoice Order# : 5705 Store : Whitfords Date

Q1. Create an EDD and a CDD based on the information below. (8 marks) Random Books Tax Invoice Order# : 5705 Store : Whitfords Date : Dec 28 2021 09:42:36 Random Loyalty Programme Customer : Clem Jeffers Customer Number : 00123 Loyalty Grade : Platinum Loyalty Points : 500 Your Purchases Item ISBN Description Num Price Total 1 9780571311460 Eruption 1 $35.00 $35.00 2 9781409103196 A Biography of LZ 1 $23.00 $23.00 Total item cost: $58.00 Points this transaction: 58 New points balance: 558 Your order was filled by Jason (staff#8675309) Random Books (RB) has three locations, one in Joondalup, one in Whitfords and one in Perth City. To encourage customers to purchase from its stores, RB has introduced a loyalty scheme and plans to give customers discounts and special offers based on their loyalty grade. The Scheme has three tiers, Silver, Gold and Platinum, achieved when customers spend less than $100, $200-$499 and $500 or greater per year.

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!