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 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 warehouse. Assume that an order can be shipped from several warehouses.

Give an update operation to a database state that violates a key constraint, stating any assumptions on the database state you make.