Question: I. Explain how you would enforce the rule that SHIPMENT ITEM.InsuredValue be at least as great as ITEM.PriceUSD. Using the MI database, create an SQL








I. Explain how you would enforce the rule that SHIPMENT ITEM.InsuredValue be at least as great as ITEM.PriceUSD. Using the MI database, create an SQL script named MI-Insert-Data.sql to answer part J J. 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. Using the MI database, create an SQL script named MI-DML-CH07.sql to answer parts K and L K. Write an UPDATE statement to change values of STORE.City from New York City to NYC L. 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 state ments did you have to use? Why
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
