Question

1 Approved Answer

Posted on Sep 22, 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 - Credit Limit - 2500 AZ GA Customer Customer. Customer Name 1000 Smith 1001 Jones 1002 Jeffries 1003 Okey 1004 Lankford 1005 Zeile 1006 Pagnozzi 1007 Arocha City Phoenix St. Louis Atlanta phoenie phoenix Chicago Salt Lake City Chicago AZ 4000 5000 2000 2000 3000 UT 1000 2 Sales Brentory Invoice Number - ter Search Quantity - 101 Item Number - 1025 1035 1045 103 103 1010 1015 1025 1025 103 30 Inventory Item# - Description - 1010 Blender 1015 Toaster 1020 Mixer 1025 Television 1030 Freezer 1035 Refrigerator 1040 Radio 104 Clock 104 104 105 RRRRR Unit Cost - Unit Price - Cuantity on Hand - $14.00 $29.95 $12.00 $19.95 $23.00 $33.95 $499.00 $699.95 $799.00 $999.95 $699.00 $849.95 $45.00 $79.95 $79.00 $99.95 $0.00 $0.00 Search 1045 1035 Extension. $699.95 $149.95 $299.85 $29.95 $19.95 $1,399.90 $699.95 $99.95 $849.95 $99.95 $999.95 $$49.95 $159.90 $199.90 $699.95 $99.95 $0.00 106 1045 107 107 1030 1035 1040 1045 107 Record 9 of 9 107 108 1025 108 1045 Record 1 4 17 of 17 Search Invoice Number - 101 102 104 105 105 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 10/29/2018 Mahomet 11/3/2018 Martinez 1000 Amount $1,549.90 $299.95 $1.449.80 $799.90 $349.95 $99.95 $2,209.70 $779.90 $0.00 1007 1002 Record 9 of 9 Search TABLE 4-15 Problem 4.5 Tables m . Customer Name City State O jones 1000 Lankford Salt Lake City UT 1005 Pagnoza 1007 Arocha Description und Cast & $1000 $1200 Unit Price 25 $19.95 $1295 $499.00 $99.00 S . $999. ss 1035 Refrigerator 1040 Radio 1045 Clock $45.00 SSS $99.95 no Customer Number - 101 102 Date Salespeon 102 Wilson 10/5/2018 Mahomet 30/1/2018 con 10/15/2018 Drecen I Martine 10/16 Martinez 10/25/2018 Mahomet 11/20 Martinez 105 105 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 - Credit Limit - 2500 AZ GA Customer Customer. Customer Name 1000 Smith 1001 Jones 1002 Jeffries 1003 Okey 1004 Lankford 1005 Zeile 1006 Pagnozzi 1007 Arocha City Phoenix St. Louis Atlanta phoenie phoenix Chicago Salt Lake City Chicago AZ 4000 5000 2000 2000 3000 UT 1000 2 Sales Brentory Invoice Number - ter Search Quantity - 101 Item Number - 1025 1035 1045 103 103 1010 1015 1025 1025 103 30 Inventory Item# - Description - 1010 Blender 1015 Toaster 1020 Mixer 1025 Television 1030 Freezer 1035 Refrigerator 1040 Radio 104 Clock 104 104 105 RRRRR Unit Cost - Unit Price - Cuantity on Hand - $14.00 $29.95 $12.00 $19.95 $23.00 $33.95 $499.00 $699.95 $799.00 $999.95 $699.00 $849.95 $45.00 $79.95 $79.00 $99.95 $0.00 $0.00 Search 1045 1035 Extension. $699.95 $149.95 $299.85 $29.95 $19.95 $1,399.90 $699.95 $99.95 $849.95 $99.95 $999.95 $$49.95 $159.90 $199.90 $699.95 $99.95 $0.00 106 1045 107 107 1030 1035 1040 1045 107 Record 9 of 9 107 108 1025 108 1045 Record 1 4 17 of 17 Search Invoice Number - 101 102 104 105 105 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 10/29/2018 Mahomet 11/3/2018 Martinez 1000 Amount $1,549.90 $299.95 $1.449.80 $799.90 $349.95 $99.95 $2,209.70 $779.90 $0.00 1007 1002 Record 9 of 9 Search TABLE 4-15 Problem 4.5 Tables m . Customer Name City State O jones 1000 Lankford Salt Lake City UT 1005 Pagnoza 1007 Arocha Description und Cast & $1000 $1200 Unit Price 25 $19.95 $1295 $499.00 $99.00 S . $999. ss 1035 Refrigerator 1040 Radio 1045 Clock $45.00 SSS $99.95 no Customer Number - 101 102 Date Salespeon 102 Wilson 10/5/2018 Mahomet 30/1/2018 con 10/15/2018 Drecen I Martine 10/16 Martinez 10/25/2018 Mahomet 11/20 Martinez 105 105 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