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.InsuredValuebe at least as great as ITEM.PriceUSD. Using the MI database, createan SQL script named MI-Insert-Data.sql to answer part J J. Write INSERTstatements 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.sqlto answer parts K and L K. Write an UPDATE statement tochange values of STORE.City from New York City to NYC L. Createand INSERT new data records to record a SHIPMENT and the SHIPMENT_ITEMs

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!