An order-processing database for a company may have the following six relations:

CUSTOMER (Cust#, Cname, City)

ORDER (Order#, Odate, Cust#, Ord_Amt)

ORDER_ITEM (Order#, Item#, Qty)

ITEM (Item#, Unit_price)

SHIPMENT (Order#, Warehouse#, Ship_date)

WAREHOUSE (Warehouse#, City)

where Ord_Amt is the total spent on an order (in dollars); Odate refers to when an order was placed; Ship_date refers to when an order was shipped from a warehouse.

Assumption: an order can be shipped from multiple warehouses

Based on intuition, which of these attributes are foreign keys for this schema, and to which relation (and primary/candidate key) would each reference? Explicitly state any assumptions you make. (15 Points)