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 queriesone 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 number 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?

TABLE 4-15 Problem 4.5 Tables Customer Customer # . Customer Name City State . Credit Limit 1000 Smith 1001 Jones 1002 Jeffries 1003 Gilkey 1004 Lankford 1005 Zeile 1006 Pagnozzi 1007 Arocha Phoenix St. Louis Atlanta Phoenix Phoenix Chicago Salt Lake City Chicago AZ AZ UT 3000 1000 Record: H 9 of9N No Filter Search Invoice Number Item Number Quantity Extension $699.95 $849.95 $299.85 $29.95 $19.95 2 $1,399.90 $699.95 $99.95 $849.95 $99.95 $999.95 849.95 $159.90 $199.90 $699.95 95 $0.00 E Inventory Item # 103 1010 1015 1025 Description . Unit Cost Unit Price , Quantity on Hand . 1010 Blender 1015 Toaster 1020 Mixer 1025 Television 1030 Freezer 1035 Refrigerator 1040 Radio 1045 Clock $14.00 $12.00 $23.00 $499.00 $799.00 $699.00 $45.00 $79.00 $0.00 $29.95 $19.95 $33.95 $699.95 $999.95 $849.95 $79.95 $99.95 103 250 104 1035 1045 1030 1035 1040 32 100 300 107 Record: 4 49 of9N No FilterSearch 108 Record: 17 of 17 No Fliter Invoice Number Date Salesperson Customer Number Amount 101 10/3/2018 Wilson 102 10/5/2018 Mahomet 103 10/s/2018 Jackson 104 10/15/2018 Drezen 105 10/15/2018 Martinez 106 10/16/2018 Martinez 107 10/29/2018 Mahomet 108 11/3/2018 Martinez 1000 $1,549.90 1002 $1,449.80 $849.95 1002 $2,209.70 $779.90 $0.00 Record: 9 of9 H No Filter Search