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

CUSTOMER $($Custa$,$ Cname, City$)$

ORDER $($Ordere$,$ Odate, Custe, Ord amt$)$

ORDER ITEM $($Ordere$,$ lteme, Qty$)$

ITEM $($liteme$,$ Unit price$)$

SHIPMENT $($OrderE$,$ Warehqusea, Ship$\_$date$)$

WAREHOUSE $($WarehouseE$,$ City$)$

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

Warehouse# is a foreign key of SHIPMENT referencing WAREHOUSE

Orders is a foreign key of ORDER$\_$ITEM referencing ORDER

Ordert is a foreign key of SHIPMENT referencing ORDER

themt is a foreign key of ORDER.ITEM referencing ITEM

Custe 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.Consider the following relations for an order$-$processing database application:

CUSTOMER $($Custa$,$ Cname, City$)$

ORDER $($Ordere$,$ Odate, Custe, Ord amt$)$

ORDER ITEM $($Ordere$,$ lteme, Qty$)$

ITEM $($liteme$,$ Unit price$)$

SHIPMENT $($OrderE$,$ Warehqusea, Ship$\_$date$)$

WAREHOUSE $($WarehouseE$,$ City$)$

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

Warehouse# is a foreign key of SHIPMENT referencing WAREHOUSE

Orders is a foreign key of ORDER$\_$ITEM referencing ORDER

Ordert is a foreign key of SHIPMENT referencing ORDER

themt is a foreign key of ORDER.ITEM referencing ITEM

Custe 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.