Customer Customer Customer Name - 1000 Smith 1001 Jones 2002 Jeffries 1003 Gilkey 1004 Lankford 1005 Zeile 1006 Pagnozzi 1007 Arocha o City Phoenix St. Louis Atlanta Phoenix Phoenix Chicago Salt Lake City Chicago State AZ MO GA AZ AZ IL UT IL Inventory Item Description - Unit Cost Unit Price 1010 Blender $14.00 $29.95 1015 Toaster $12.00 $19.95 1020 Mixer $23.00 $33.95 1025 Television $499.00 $699.95 1030 Freezer $799.00 $999.95 1035 Refrigerator $699.00 $$49.95 1040 Radio $45.00 $79.95 1045 Clock $79.00 $99.95 Sales-Inventory Invoice Number Item Number - Quantity 101 1025 101 1035 102 1045 103 1010 103 1015 103 1025 104 1025 1046 1045 1 105 1035 106 1045 107 1030 107 1035 107 10-10 107 1045 108 1025 108 10-15 Sales tric Nurnbet 101 102 103 104 Dale - Salon - Custom Numb 10/3/2018 Wilson 1000 10/5/2018 Mahomet 1003 10/5/2018 Jackson 1002 10/15/2018 Drexen 1000 10/15/2018 Martinez UUS 10/16/2018 Martinez 1007 10/29/2018 Mahomet 1002 11/3/2018 Martinez 1000 106 107 108 Requirement: 1. Create the four tables (3 marks) 2. Edit all the necessary relationships (2 marks) 3. Create the following queries: (5 marks) a. What are sales invoice numbers, salesperson for the customer Smith? b. What are items number, description, quantity and price sold to customer Jeffries? c. Who are salespersons, invoices date and number, for customer number 1000? d. What are sales invoice numbers, the name, city and state for customer number 1005? e. Who are customers (name and number) who bought item number 1025