Question: 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








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
