A. Explain how you would enforce the rule that SHIPMENT_ ITEM. Insured Value be at least as great as ITEM. Price USD. B. Write INSERT statements to insert the data shown in Figures 7-60, 7-61, 7-62,...

A. Explain how you would enforce the rule that SHIPMENT_ ITEM. Insured Value be at least as great as ITEM. Price USD.

B. Write INSERT statements to insert the data shown in Figures 7-60, 7-61, 7-62, 7-63, 7-64, 7-65, and 7-66.

C. Write an UPDATE statement to change values of STORE. City from New York City to NYC.

D. Create and INSERT new data records to record a SHIPMENT and the SHIPMENT_ITEMs for that SHIPMENT. Then write a DELETE statement(s) to delete that SHIPMENT and all of the items on that SHIPMENT. How many DELETE statements did you have to use? Why?