Consider the following six relations for an order-processing database

application in a company:

CUSTOMER (Cust#, Cname, City)

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

ORDERITEM (Order#, Item#, Qty)

ITEM (Item#, Unitprice)

SHIPMENT (Order#, Warehouse#, Shipdate)

WAREHOUSE (Warehouse#, City)

Here, OrdAmt refers to total dollar amount of an order; Odate is the

date the order was placed; Shipdate 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 vi-

olates a referential integrity constraints, stating any assumptions

on the database state you make.