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

 Exercise 9.3.2: Write the following embedded SQL queries, based on the
database schema Classes (class, type, country, numGuns, bore, displacement) Ships (name, class,

Exercise 9.3.2: Write the following embedded SQL queries, 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 a) The firepowe r of a ship is roughly proportional to the number of guns times the cube of the bore of the guns. Find the class with the largest firepower. er for the name of a battle. Find the countries of the ships )An the battle. Print the country with the most ships sunk and !b) the country with the most ships damaged el Ask the user for the name of a class and the other information required for a tuple of table Classes. Then ask for a list of the names of the ships of that class and their dates launched. However, the user need not give rst name, which will be the name of the class. Insert the information gathered into Classes and Ships. !d) Examine the Battles, Outcomes, and Ships relations for ships that were in battle before they were launched. Prompt the user when there is an error found, offering the option to change the date of launch or the date of the battle. Make whichever change is requested

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!