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 schemaClasses (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

1 Expert Approved Answer
Step: 1 Unlock

To modify the database based on the given schema you need to perform insert delete and update operat... View full answer

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!