Question

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? 

g. 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) 

i. 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:

Answer 1

a. Smith, Zelle, Arocha

b. 1003 Gilkey Credit limit 5000

c. $ 10,418.35

d. Item No. 1015

Price - 1399.9

Qty - 2

e.

	Amout sold
Wilson	1549.9
Mahomet	2509.65
Jackson	1449.8
Drezen	799.9
Matinez	1729.8

f. 3