Question: Using the World War II database, write a transaction that -Deletes all German ship in all the tables -Add a new ship for USA That

Using the World War II database, write a transaction that

-Deletes all German ship in all the tables

-Add a new ship for USA

That is you want to ensure that both delete and insert will occur togetherUsing the World War II database, write a transaction that -Deletes allGerman ship in all the tables -Add a new ship for USA

mysql> SELECT FROM Ships; name | class | launched | 1921 | 1915 | 1914 | 1943 1915 | 1913 | 1944 | 1942 I 1943 1941 | 1917 | 1916 | 1916 | 1916 | 1916 | 1916 | 1916 | 1916 | 1916 | 1920 I 1941 | 1944 | 1941 | | California | Tennessee | Kongo | Kongo | Iowa | Kongo | Kongo | Iowa | Yamato | Iowa Haruna Hiei | Iowa | Kirishima | Kongo | Missouri |Musashi |New Jersey | North Carolina North Carolina | | Ramillies |Renowrn |Renowrn |Revenge |Renowrn |Renowrn |Renowrn |Renowrn |Revenge |Revenge |Revenge Repulse Repulse | Resolutiorn |Revenge | Royal 0ak | Royal Sovereign | Revenge | Tennessee | Washington | Tennessee | North Carolina | Iowa | Yamato Wisconsin | Yamato 23 rows in set (0.00 sec) mysql>

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!