Consider the following relations for an order$-$processing database application:

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$)$

The primary keys for the relations in the above schema are underlined, and the foreign keys for this schema are as below:

Warehouse# is a foreign key of SHIPMENT referencing WAREHOUSE

Order# is a foreign key of ORDER$\_$ITEM referencing ORDER

Order# is a foreign key of SHIPMENT referencing ORDER

Item# is a foreign key of ORDER$\_$ITEM referencing ITEM

Cust# is a foreign key of ORDER referencing CUSTOMER

Discuss the integrity constraints that could be violated and the required conditions if a WAREHOUSE tuple is deleted from the

WAREHOUSE relation.