Quesion 1 [30 marks] (a) Create a database for a small hardware shop with following data dictionaries (You figure out what are the foreign keys). 1. Customer(CustomerlD int, Name char(30], Phone charl30]. City char[50] AccountBalance real) Data CustomerlD Name Phone City AccountBalance $200.00 $21.00 $1280 00 50.00 $550.00 $230.00 Terry 111-111-2222 Madison Leanne 222-333-4444Madison Jim 333-444-2222 Chicago Katy 444-555-1111 San Francisco 4 David 555-222-1111 New York Willie 333-111-3333 Atlanta 2. Inventory(ItemID int, Description charl100], ListPrice real) Data Description Garden rake Leaf reke Garden shovel Trowel Hoe Pruning shears Machete Culivator Bulb planter Pitchfork ListPrice $899 $7.99 $1599 57 99 $5.99 $15 99 %9.99 $5.99 $3.89 $2199 quentiy 28 43 21 20 12 42 10 3. Sale (SaleID int, CustomerlD int, SaleDate) Data SaleDate 02/05/2015 0207/2015 01107/2015 03/08/2015 03/09 2013 03/10/2014 031112015 04/12/2015 04/13/2015 04/14/2015 SalelD CustomerlD 101 102 103 104 105 106 107 108 109 110