Use the instance diagram depicting the ternary relationship Orders shown on the next page to answer the following questions.
a. Which customers order pens from the Galveston warehouse?
b. Which items are ordered by customers from both warehouses?
c. Which warehouse fills one or more orders of items from both customers?
d. Describe orders filled from both warehouses.
e. What changes must be made to the instance diagram for order r1 to involve both pencils and pens?
a. No customers order pens from the Galveston warehouse, as the Galveston warehouse does not supply pens.
b. Pencils are ordered from both warehouses.
c. The Galveston warehouse takes one or more orders from both customers.
d. This question is poorly worded and may generate several different answers. What we were looking for related to order r2, which involves Ives ordering pencils from both the Galveston and Charlotte warehouses. Some students may provide a description of all orders, which in essence contains what we were looking for along with a description of orders that technically we were not looking for.
e. Just as we have two warehouses going to order r2, this question necessitates two items leading into order r1. This was another question that perhaps could be worded better, as it can generate interesting answers to a slightly different question.