Question: Exercise 6.5.2: Write the following database modifications, based on the database schema Classes (class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles (name,


Exercise 6.5.2: Write the following database modifications, based on the database schema Classes (class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles (name, date) Outcomes (ship, battle, result) of Exercise 2.4.3. Describe the effect of the modifications on the data of that exercise. - a) The two British battleships of the Nelson class Nelson and Rodney - were both launched in 1927, had nine 16-inch guns, and a displacement of 34,000 tons. Insert these facts into the database. - b) Two of the three battleships of the Italian Vittorio Veneto class - Vit- torio Veneto and Italia were launched in 1940; the third ship of that class, Roma, was launched in 1942. Each had nine 15-inch guns and a displacement of 41,000 tons. Insert these facts into the database. c) Delete from Ships all ships sunk in battle. d) Modify the Classes relation so that gun bores are measured in centime- ters (one inch = 2.5 centimeters) and displacements are measured in met- ric tons (one metric ton = 1.1 tons). e) Delete all classes with fewer than three ships.
Step by Step Solution
There are 3 Steps involved in it
To modify the database based on the given schema you need to perform insert delete and update operat... View full answer
Get step-by-step solutions from verified subject matter experts
