Q1. Create an EDD and a CDD based on the information below. (8 marks) Random Books Tax Invoice Order# Store : 5705 : Whitfords Date : Dec 28 2021 09:42:36 Random Loyalty Programme Customer Customer Number Loyalty Grade Loyalty Points : Clem Jeffers : 00123 : Platinum : 500 Your Purchases Item ISBN Description Num Price Total 1 2 9780571311460 9781409103196 Eruption 1 A Biography of LZ 1 $35.00 $23.00 $35.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. Q1. Create an EDD and a CDD based on the information below. (8 marks) Random Books Tax Invoice Order# Store : 5705 : Whitfords Date : Dec 28 2021 09:42:36 Random Loyalty Programme Customer Customer Number Loyalty Grade Loyalty Points : Clem Jeffers : 00123 : Platinum : 500 Your Purchases Item ISBN Description Num Price Total 1 2 9780571311460 9781409103196 Eruption 1 A Biography of LZ 1 $35.00 $23.00 $35.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