question archive Write the following procedures, based on the database schema of Exercise 2
Write the following procedures, based on the database schema of Exercise 2
Subject:Computer SciencePrice: Bought3
Write the following procedures, based on the database schema of Exercise 2.4.3. Classes(class, type, country, numGuns, bore, displacement ) Ships (name, class , launched ) Battles(name, date) Outcomes (ship, battle , result) Note: SPs were named SP_[number] 1) The firepower of a ship is roughly proportional to the number of guns times the cube of the bore. Given a class as argument, return its firepower. 2) Take as arguments a new class name, type, country, number of guns, bore, and displacement. Add this information to Classes and also add the ship with the class name to Ships. 3) Given a ship name, determine if the ship was in a battle with a date before the ship was launched. If so, set the date of the battle and the date the ship was launched to NULL, and -1, respectively. 4) Given the name of a battle, produce the two countries whose ships were involved in the battle. If there are more or fewer than two countries involved, produce NULL for both countries.
