*****PLEASE ANSWER ONLY QUESTION E USING SQL STANDARD!!!!!!!!!!!!!!!!!

*****PLEASE ANSWER ONLY QUESTION E USING SQL STANDARD!!!!!!!!!!!!!!!!!

*****PLEASE ANSWER ONLY QUESTION E USING SQL STANDARD!!!!!!!!!!!!!!!!!

*****PLEASE ANSWER ONLY QUESTION E USING SQL STANDARD!!!!!!!!!!!!!!!!!

*****PLEASE ANSWER ONLY QUESTION E USING SQL STANDARD!!!!!!!!!!!!!!!!!

*****PLEASE ANSWER ONLY QUESTION E USING SQL STANDARD!!!!!!!!!!!!!!!!!

Exercise 7.5.3: Write the following as triggers. In each case, disallow or undo the modification if it does not satisfy the stated constraint. The database schema is from the battleships example of Exercise 2.4.3. Classes (class, type, country, numGuns, bore, displacement) Ships (name, class, launched) Battles (name, date) Outcomes(ship, battle, result) a) When a new class is inserted into Classes, also insert a ship with the b) When a new class is inserted with a displacement greater than 35,000 ! c) If a tuple is inserted into Outcomes, check that the ship and battle are name of that class and a NULL launch date. tons, allow the insertion, but change the displacement to 35,000. listed in Ships and Battles, respectively, and if not, insert tuples into one or both of these relations, with NULL components where necessary of Ships, check that no country has more than 20 ships. fought in a battle that was at a later date than another battle in which 1 d) When there is an insertion into Ships or an update of the class attribute !! e) Check, under all circumstances that could cause a violation, that no ship that ship was sunk