Paragraph Styles Using the data tables found on Appendix 1, answer the following questions and indicate, the table(s), field(s), primary key and foreign key required to determine the answer. 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 invoice number 103? e. How much did each salesperson sell? f. How many customers live in Arizona? 8. How much credit does each customer still have available? h. How much of each item was sold? (Include the description of each item in your answer) 1. Which customers still have more than $1,000 in available credit? J. For which items are there at least 100 units on hand? Appendix 1: CUSTOMER TABLE State Credit Limit Customer 1000 Customer Name Smith City Phoenix w] Using the data tables. ] ACC1022 - Assignme. Desktop erences Mailings Review View Tell me what you want to do Aa. 2T . 1 Normal TNo Spac... Heading 1 Heading 2 Title Sub Paragraph Which customers still have more than $1,000 in available credit? j. For which items are there at least 100 units on hand? Styles Appendix 1: CUSTOMER TABLE Customer 1000 State Customer Name Smith Credit Limit City Phoenix 2,500 1001 Jones St.Louis 1,500 1002 Jeffries Atlanta Gilkey Phoenix 5,000 Lankford Phoenix 1004 1005 2,000 Zeile Chicago I 2,000 1006 Pagnozzi Salt Lake City 3,000 Arocha Chicago 1,000 Uking the data tables... ACC1022 - Assignme Desktop DOLL 1 Normal W ADD Habble Hd TNo Spac... Heading 1 Heading 2 Title Paragraph Styles INVENTORY TABLE Quantity on Hand Item # 1010 1015 1020 1025 1030 1035 1040 Description Blender Toaster Mixer Television Freezer Refrigerator Radio Clock Unit Cost $ 14.00 $ $ 12.00 $ 23.00 $ 499.00 $ 799.00 $ $ 699.00 $ 45.00 $ $ 79.00 $ Unit Price 29.95 19.95 33.95 699.95 999.95 849.95 79.95 99.95 $ 1045 0 SALES TABLE Invoice Number Date 10/3/2018 Amount Salesperson Customer Number Wilson 1000 1,549.90 10/5/2018 Mahomet 1003 299.95 10/5/2018 Jackson 1002 1,449.80 104 10/15/2018 Drezen 1000 799.90 10 10/15/2018 100 Using the data tables. ACC1022 - Assignme Desktop DOLL W ys Review Views 1 Normal T No Spac.. Heading 1 Heading 2 Title Su Paragraph Styles SALES TABLE Invoice Number 101 Date 10/3/2018 Salesperson Customer Number Wilson 1000 Amount 1,549.90 10/5/2018 Mahomet 1003 299.95 10/5/2018 Jackson 1002 1000 1,449.80 10/15/2018 Drezen 799.90 10/15/2018 Matinez 849.95 10/16/2018 Martinez 1007 99.95 10/29/2018 Mahomet 2,209.70 11/3/2018 Matinez 779.90 g the data tables... ] ACC1022 - Assignme... Desktop DOLL Appendix 1 (Continued): SALES-INVENTORY TABLE Invoice Numbe 699.95 1035 849.95 $ 299.85 29.95 19.95 1.199.90 699 95 99.95 w] ACC1022 - Assignme.. Desktop
