Question

1 Approved Answer

Posted on Sep 13, 2024

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

Ais: Requires MS Access image text in transcribed

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 Customer Customer Customer Name - City 1000 Smith Phoenix 1001 Jones St. Louis 1002 Jeffries Atlanta 1003 Gilkey Phoenix AZ 1004 Lankford Phoenix 1005 Zeile Chicago 1006 Pagnozzi Salt Lake City UT 1007 Arocha Chicago - Credit Limit - 2500 1500 4000 5000 2000 2000 3000 1000 AZ Record 9 of 9 Nofter Search Sales Inventory Invoice Number . Quantity Item Number - 1025 1 101 1035 102 Quantity on Hand- 200 103 103 103 104 211) 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 Search Unit Price $29.95 $19.95 $33.95 $699.95 $999.95 $849.95 $79.95 $99.95 $0.00 104 105 106 1045 1010 1015 1025 1025 1045 1035 1045 1030 1035 1040 1045 1025 1045 Extension , $199.95 $849.95 $299.85 $29.95 $19.95 $1,399.90 $699.95 $99.95 $89.95 $99.95 $999.95 $849.95 $159.90 $199.90 $699.95 $99.95 $0.00 107 107 107 107 Record of 9 108 108 Record 1 4 17 of 17 No Search Invoice Number - 101 102 103 104 105 105 107 108 Date Salesperson 10/3/2018 Wilson 10/5/2018 Mahomet 10/5/2018 lackson 10/15/2018 Drezen 10/15/2018 Martinez 10/16/2018 Martinez 10/29/2018 Mahomet 11/3/2018 Martinez Customer Number . 1000 1003 1002 1000 1005 Amount - $1,549.90 $299.95 $1,449.80 $799.90 $$49.95 $99.95 $2,209.70 $779.90 $0.00 1007 1002 1000 Record M 19 of 9 Search 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? 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 Customer Customer Customer Name - City 1000 Smith Phoenix 1001 Jones St. Louis 1002 Jeffries Atlanta 1003 Gilkey Phoenix AZ 1004 Lankford Phoenix 1005 Zeile Chicago 1006 Pagnozzi Salt Lake City UT 1007 Arocha Chicago - Credit Limit - 2500 1500 4000 5000 2000 2000 3000 1000 AZ Record 9 of 9 Nofter Search Sales Inventory Invoice Number . Quantity Item Number - 1025 1 101 1035 102 Quantity on Hand- 200 103 103 103 104 211) 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 Search Unit Price $29.95 $19.95 $33.95 $699.95 $999.95 $849.95 $79.95 $99.95 $0.00 104 105 106 1045 1010 1015 1025 1025 1045 1035 1045 1030 1035 1040 1045 1025 1045 Extension , $199.95 $849.95 $299.85 $29.95 $19.95 $1,399.90 $699.95 $99.95 $89.95 $99.95 $999.95 $849.95 $159.90 $199.90 $699.95 $99.95 $0.00 107 107 107 107 Record of 9 108 108 Record 1 4 17 of 17 No Search Invoice Number - 101 102 103 104 105 105 107 108 Date Salesperson 10/3/2018 Wilson 10/5/2018 Mahomet 10/5/2018 lackson 10/15/2018 Drezen 10/15/2018 Martinez 10/16/2018 Martinez 10/29/2018 Mahomet 11/3/2018 Martinez Customer Number . 1000 1003 1002 1000 1005 Amount - $1,549.90 $299.95 $1,449.80 $799.90 $$49.95 $99.95 $2,209.70 $779.90 $0.00 1007 1002 1000 Record M 19 of 9 Search 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