a. Make up a table (i.e., a query) that has in it all the data for each order, i.e., the order data (order plus order-line-item), the sale data (e.g. shipment data sale plus sale line-item, etc), the customer data, and product data). Be sure to include at least the following fields in the table: sales order number, customer code, customer name, item number, item name, quantity ordered, quantity shipped.

b. Make up a table (i.e., a query) that has in it only inventory items that have not been ordered. Include the main/important fields relating to each of those inventory items.

c. Make up a table (i.e., a query) that has in it only customers that have not placed an order. Include the main/important fields relating to each of those customers.

d. Make up a table that has in it only inventory items that have been ordered but have not yet been shipped.

e. Make up a table (i.e., a query) that includes all inventory items and includes both the total cost i.e., (cost x quantity) and total sales price (sales price x quantity) for each item and sorted in descending order by total cost.

FIGURE .10 Relatatabase Shaded,Attribute(s)-Primary Key USTOMERS Cust Code Cust Name Sales PersBO y Credit Limit Sales YTD Custcit New York ke Bic.&Mopeds San Jose eelaway cycie Center Campbel1 10000.00 5000.00 Breitenste Bikes Et Cetera Inter. Bicycle Sales 4191.18 RODEBYKE Rodeby STANS Garcia 8330.00 6854.00 Garcia Stan's Cycler Hawthorne 10000.00 INVENTORY Unit Cost Unit Price Item Number Oty On Hand Item Name 20 in. Bicycle 26 in. Bicycle 24 in. Bicycle 20 in. Bicycle Kickstand Formed Handlebar Pedal Tire, 26 in Tire Tube, 26 in. Spoke Reflector Wheel, 26 in 150.00 1002-1 1003-1 1280-054 2010-0050 3050-2197 3961-1010 3961-1041 3965-1050 3970-1011 so Number Cust Code Cust Order Number so Date 1010 WHEEL 1011ETC 1012 WHEEL 1013 IBS 1014 ETC 1015 WHEEL 1016 ETC 061205 061205 061205 061205 061206 061206 5673 SALES Shipment Number 021207028 021207042 Invoice_ Number SO Number Cust_Code ORDERS line items INVENTORY SO Number Item Number Oty_Ordered Sales Price 137.50 1010 1000-1 1010 2010-0050 2 1011 1001-1 127.50 150.00 1011 1002-1 1012 1003-1 1012 1001-1 1013 1001-1 1014 1003-1 1015 1003-1 1016 1003-1 1016 3965-1050 1016 3961-1041 1016 1000-1 10 50 25 127.50 5 50 137.50 SALES line items INVENTORY Shipment Number Item Number Qty_Shipped 021207028 1001-1 021207028 1002-1 021207042 1001-1 5 FIGURE .10 Relatatabase Shaded,Attribute(s)-Primary Key USTOMERS Cust Code Cust Name Sales PersBO y Credit Limit Sales YTD Custcit New York ke Bic.&Mopeds San Jose eelaway cycie Center Campbel1 10000.00 5000.00 Breitenste Bikes Et Cetera Inter. Bicycle Sales 4191.18 RODEBYKE Rodeby STANS Garcia 8330.00 6854.00 Garcia Stan's Cycler Hawthorne 10000.00 INVENTORY Unit Cost Unit Price Item Number Oty On Hand Item Name 20 in. Bicycle 26 in. Bicycle 24 in. Bicycle 20 in. Bicycle Kickstand Formed Handlebar Pedal Tire, 26 in Tire Tube, 26 in. Spoke Reflector Wheel, 26 in 150.00 1002-1 1003-1 1280-054 2010-0050 3050-2197 3961-1010 3961-1041 3965-1050 3970-1011 so Number Cust Code Cust Order Number so Date 1010 WHEEL 1011ETC 1012 WHEEL 1013 IBS 1014 ETC 1015 WHEEL 1016 ETC 061205 061205 061205 061205 061206 061206 5673 SALES Shipment Number 021207028 021207042 Invoice_ Number SO Number Cust_Code ORDERS line items INVENTORY SO Number Item Number Oty_Ordered Sales Price 137.50 1010 1000-1 1010 2010-0050 2 1011 1001-1 127.50 150.00 1011 1002-1 1012 1003-1 1012 1001-1 1013 1001-1 1014 1003-1 1015 1003-1 1016 1003-1 1016 3965-1050 1016 3961-1041 1016 1000-1 10 50 25 127.50 5 50 137.50 SALES line items INVENTORY Shipment Number Item Number Qty_Shipped 021207028 1001-1 021207028 1002-1 021207042 1001-1 5