4.5 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- riesone 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? c. How much did each salesperson sell? f. How many customers live in Arizona? g. How much credit does cach customer still have available? Com Customer Customer Name 1000 Benih 100L Ponies 2002 lettres 103 Gilkev O Lanka 1005 Kelle 1006 Pagnoza BOOT Mocha 0 City State Phoenix AZ SE LOUIS MO Atlanta GA Phen AZ Phoven AZ Chico Sa Lake City UT Chicago Credit Limite 2500 1500 4000 5000 2000 3000 1000 0 AR Shanti Item Number Sales Inventory Invoice Number - 101 101 Quantity 1025 1 1 3 Deventer X 102 103 103 1 Unit Price 1 Description 1010 blend 1015 Toast 1020 MM 102.5 Teluisson 1030 Wrex 1035 Rengan 1040 Radio 1045 Clock 0 quantity on Hand. 200 300 250 74 103 104 104 Unte 114.00 $22.00 $223.00 149.00 $9.00 SES.00 $45.00 SM9.00 SOLO $29.95 $19.95 $33.95 $69.55 $999.95 $$49.95 $79.95 $99.95 $0.00 1005 1045 1010 1015 1025 1025 1045 1005 1outs 1030 1009 1040 1045 Extension $699.99 $49.95 $299.85 $29.95 $19.95 $1,399.00 $699.95 $99.95 $843.95 $99.95 $999.95 $849.95 $159.90 $199.90 $699.95 $99.95 $0.00 32 25 105 106 107 107 107 1 100 300 12 2 2 Recordar Search 1025 1 108 108 1045 1 Searth Amount Customer Number 1000 1003 Invoice Number 101 102 103 104 105 10 107 108 Date -Salesperson 10/3/2018 Wilson 10/5/2018 Mahomet 10/5/2018 Jackson 10/15/2018 Drezen 10/15/2018 Martinez 19/16/2018 Martinaz 10/29/2018 Mahonet 11/2018 Martinez 1005 1007 1002 1000 SCO Acordo Search 4.5 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- riesone 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? c. How much did each salesperson sell? f. How many customers live in Arizona? g. How much credit does cach customer still have available? Com Customer Customer Name 1000 Benih 100L Ponies 2002 lettres 103 Gilkev O Lanka 1005 Kelle 1006 Pagnoza BOOT Mocha 0 City State Phoenix AZ SE LOUIS MO Atlanta GA Phen AZ Phoven AZ Chico Sa Lake City UT Chicago Credit Limite 2500 1500 4000 5000 2000 3000 1000 0 AR Shanti Item Number Sales Inventory Invoice Number - 101 101 Quantity 1025 1 1 3 Deventer X 102 103 103 1 Unit Price 1 Description 1010 blend 1015 Toast 1020 MM 102.5 Teluisson 1030 Wrex 1035 Rengan 1040 Radio 1045 Clock 0 quantity on Hand. 200 300 250 74 103 104 104 Unte 114.00 $22.00 $223.00 149.00 $9.00 SES.00 $45.00 SM9.00 SOLO $29.95 $19.95 $33.95 $69.55 $999.95 $$49.95 $79.95 $99.95 $0.00 1005 1045 1010 1015 1025 1025 1045 1005 1outs 1030 1009 1040 1045 Extension $699.99 $49.95 $299.85 $29.95 $19.95 $1,399.00 $699.95 $99.95 $843.95 $99.95 $999.95 $849.95 $159.90 $199.90 $699.95 $99.95 $0.00 32 25 105 106 107 107 107 1 100 300 12 2 2 Recordar Search 1025 1 108 108 1045 1 Searth Amount Customer Number 1000 1003 Invoice Number 101 102 103 104 105 10 107 108 Date -Salesperson 10/3/2018 Wilson 10/5/2018 Mahomet 10/5/2018 Jackson 10/15/2018 Drezen 10/15/2018 Martinez 19/16/2018 Martinaz 10/29/2018 Mahonet 11/2018 Martinez 1005 1007 1002 1000 SCO Acordo Search