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 toanswer part J J. Write INSERT statements to insert the data shownin Figures 7-60, 7-61, 7-62, 7-63,7-64, 7-65, and 7-66. Using the MIdatabase, create an SQL script named MI-DML-CH07.sql to answer parts K andL K. Write an UPDATE statement to change values of STORE.City fromNew York City to NYC L. Create and INSERT new data recordsto record a SHIPMENT and the SHIPMENT_ITEMs for that SHIPMENT Then writea DELETE statement(s) to delete that SHIPMENT and all of the items

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!