Ais: Requires MS Access
Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's website (or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer the following questions. Note: For some questions, you may have to create two queries-one to calculate an Invoice Total and the second to answer the question asked. a. How many different kinds of inventory items does S&S sell? b. How many sales were made during October? - State AZ MO Customer Customer Customer Name - 1000 Smith Phoenix 1001 Jones St. Louis 1002 Jeffries Atlanta 1003 Gilkey Phoenix 1004 Lankford Phoenix 1005 Zeile Chicago 1006 Pagnozzi Salt Lake City 1007 Arocha Chicago - Credit Limit - 2500 1500 4000 5000 2000 2000 3000 1000 AZ UT Record H 9 of 9 No Search Quantity Sales-Inventory Invoice Number. 101 101 102 103 103 Quantity on Hand- 31 Inventory Item# . Description 1010 Blender 1015 Toaster 1020 Mixer 1025 Television 1030 Freezer 1035 Refrigerator 1040 Radio 1045 Clock Unit Cost - $14.00 $12.00 $23.00 $499.00 $799.00 $699.00 $45.00 $79.00 $0.00 Noble Search Unit Price $29.95 $19.95 $33.95 $699.95 $999.95 $849.95 $79.95 $99.95 $0.00 104 104 105 106 107 Item Number - 1025 1035 1045 1010 1015 1025 1025 1045 1035 1045 1030 1035 1040 1045 1025 1045 Extension 1 $699.95 $$49.95 $299.85 $29.95 $19.95 $1,399.90 $699.95 $99.95 $849.95 $99.95 $999.95 $849.95 $159.90 $199.90 $699.95 $99.95 0 $0.00 88 W 107 Records 14 9019 107 107 108 108 Record H4 17 of 17 Noite Search Sales Invoice Number - 101 102 103 104 105 106 107 108 Date Salesperson - Customer Number - 10/3/2018 Wilson 1000 10/5/2018 Mahomet 1003 10/5/2018 Jackson 1002 10/15/2018 Drezen 1000 10/15/2018 Martinez 1005 10/16/2018 Martinez 1007 10/29/2018 Mahomet 11/3/2018 Martinez 1000 Amount - $1,549.90 $299.95 $1.449.80 $799.90 $$49.95 $99.95 $2,209.70 $779.90 $0.00 1002 Record M 4 9 of 9 1 2 Manomet 108 11/3/2018 Martinez 1002 1000 2.209.70 $779.90 $0.00 Record 9 of 9 NS Search c. What were total sales in October? d. What was the average amount of a sales transaction? -e. Which salesperson made the largest sale? f. How many units of each product were sold? g. Which product was sold most frequently? Enter the tables in Table 4-15 into a relational DBMS package. Write queries to answer the following questions. Note: For some questions, you may have to create two que- ries one to calculate a total and the second to answer the question asked. a. Which customers (show their names) made purchases from Martinez? b. Who has the largest credit limit? c. How many sales were made in October? d. What were the item numbers, price, and quantity of each item sold on in voice num- ber 103? e. How much did each salesperson sell? f. How many customers live in Arizona? g. How much credit does each customer still have available