Consider the following six relations for an order-processing database application in a company:

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)

Here, Ord Amt refers to the total dollar amount of an order; Odate is the date the order was placed; Ship date is the date an order is shipped from the

Specify foreign keys for this schema, stating any assumptions you make. Note that you do not need to write SQL statements for the above updates and foreign keys