Please answer exercise 2.4.3, parts a-h and you can charge for multiple questions. Thanks. The hint for h is that ships are built in classes from the same design, and the class is usually named for the first ship of that class. I sent 3 pics to include figures 2.22 and figure 2.23. Part g and h are in the 3rd picture. Thanks again! Ill give you a big thumbs up for a correct answer!

Exercise 2.4.3: This exercise builds upon Exercise 2.3.2 concerning Word War II capital ships. Recall it involves the following relations Classes(class, type, country, numGuns, bore, displacement) Ships (name, class, launched) Battles (name, date) Outcomes (ship, battle, result) Figures 2.22 and 2.23 give some sample data for these four relations Note that, unlike the data for Exercise 2.4.1, there are some "dangling tuples" in this data, e.g, ships mentioned in Outcomes that are not mentioned in Ships Write expressions of relational algebra to answer the following queries. You may use the linear notation of Section 2.4.13 if you wish. For the data of Figs 2.22 and 2.23, show the result of your query. However, your answer should work for arbitrary data, not just the data of these figures a) Give the class names and countries of the classes that carried guns of at least 16-inch bore. b) Find the ships launched prior to 1921. c) Find the ships sunk in the battle of the Denmark Strait d) The treaty of Washington in 1921 prohibited capital ships hearier then 35,000 tons. List the ships that violated the treaty of Washington e) List the name, displacement, and mumber of guns of the ships the battle of Guadalcanal f) List all the capital ships mentioned in the database. (Re thas al these ships may not appear in the Ships relation.) Souce .N. Westwood, Pighting Ships of World War II. Folles Pasi 1975 and R. C.Stern, US Battleships in Action, Squadron/Sigial Pa Ch TX,10