Please answer from ‘a’ to ‘i’ TennesseeYamatonamebb USAbbCaliforniaHarunaHieiIowaKirishimaKongoMissouriMusashishipArizonaBismarckCaliforniaDuke of YorkFusoHoodKing George VKirishimaPrince of WalesRodneyScharnhorstSouth DakotaTennesseeWashingtonJapannameDenmark StraitGuadalcanalWest VirginiaYamashiro(a) Sample data for relation ClassesdateNorth CapeSurigao StraitRamilliesRenownRepulseResolution.2.4. AN ALGEBRAIC QUERY LANGUAGETennesseeWashingtonWisconsinYamato(b) Sample data for relation BattlesbattlePearl HarborDenmark StraitSurigao StraitNorth CapeNew JerseyNorth CarolinaRevengeRoyal OakRoyal Sovereign(c) Sample data for relation Outcomes12classFigure 2.22: Data for Exercise 2.4.35/24-27/4111/15/4212/26/4310/25/44Surigao StraitDenmark StraitDenmark StraitGuadalcanalDenmark StraitDenmark StraitNorth CapeGuadalcanalSurigao StraitGuadalcanalSurigao StraitSurigao Strait sunkTennesseeKongoKongoIowaKongoKongoIovaYamatoRevengeRevengeRevengeRevengeTennesseeIowaNorth CarolinaRevengeRenownRenownresultsunksunkokok1418North CarolinaIowaYamatosunksunkoksunkdamagedoksunkdamagedokokoklaunched192119151914194319151913194419421943194119171916191619161916191619161920194119441941Figure 2.23: Sample data for relation Ships320006500057! g) Find the classes that had only one ship as a member of that class.! h) Find those countries that had both battleships and battlecruisers.! i) Find those ships that "lived to fight another day"; they were damaged inone battle, but later fought in another. Exercise 2.4.3: This exercise builds upon Exercise 2.3.2 concerning WorldWar 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. Notethat, unlike the data for Exercise 2.4.1, there are some "dangling tuples" in thisdata, e.g., ships mentioned in Outcomes that are not mentioned in Ships.Write expressions of relational algebra to answer the following queries. Youmay 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 workfor arbitrary data, not just the data of these figures.a) Give the class names and countries of the classes that carried guns of atleast 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 heavier than35,000 tons. List the ships that violated the treaty of Washington.e) List the name, displacement, and number of guns of the ships engaged inthe battle of Guadalcanal.f) List all the capital ships mentioned in the database. (Remember that allthese ships may not appear in the Ships relation.)*Source: J. N. Westwood, Fighting Ships of World War II, Follett Publishing, Chicago.1975 and R. C. Stern, US Battleships in Action, Squadron/Signal Publications, Carrollton,TX, 1980.56CHAPTER 2. THE RELATIONAL MODEL OF DATAclassBismarckbbIowabbKongobcNorth Carolina bbRenownbcbbbbbbRevengeTennesseeYamatotype countryGermany8USA9Japan8USA9Gt. Britain 6Gt. Britain 8USAJapannameDenmaDenmark StraitGuadalcanal(a) Sample data for relation ClassesdatenumGuns bore displacement1516141615151418shipArizonaBismarck5/24-27/4111/15/42North Cape12/26/43Surigao Strait 10/25/44129(b) Sample data for relation BattlesbattleresultPearl HarborsunkDenmark Strait sunkSurigao StraitokNorth CapeokCaliforniaDuke of YorkFusoHoodKing George VKirishimaPrince of WalesRodneyScharnhorstSouth DakotaTennesseeWashingtonWest VirginiaYamashiroSurigao StraitDenmark StraitDenmark StraitGuadalcanalDenmark StraitDenmark StraitNorth CapeGuadalcanalSurigao StraitGuadalcanalsunksunkoksunkdamagedoksunkdamagedokokSurigao Strait okSurigao Strait sunk4200046000320003700032000290003200065000

Question

Please answer from ‘a’ to ‘i’ TennesseeYamatonamebb USAbbCaliforniaHarunaHieiIowaKirishimaKongoMissouriMusashishipArizonaBismarckCaliforniaDuke of YorkFusoHoodKing George VKirishimaPrince of WalesRodneyScharnhorstSouth DakotaTennesseeWashingtonJapannameDenmark StraitGuadalcanalWest VirginiaYamashiro(a) Sample data for relation ClassesdateNorth CapeSurigao StraitRamilliesRenownRepulseResolution.2.4. AN ALGEBRAIC QUERY LANGUAGETennesseeWashingtonWisconsinYamato(b) Sample data for relation BattlesbattlePearl HarborDenmark StraitSurigao StraitNorth CapeNew JerseyNorth CarolinaRevengeRoyal OakRoyal Sovereign(c) Sample data for relation Outcomes12classFigure 2.22: Data for Exercise 2.4.35/24-27/4111/15/4212/26/4310/25/44Surigao StraitDenmark StraitDenmark StraitGuadalcanalDenmark StraitDenmark StraitNorth CapeGuadalcanalSurigao StraitGuadalcanalSurigao StraitSurigao Strait sunkTennesseeKongoKongoIowaKongoKongoIovaYamatoRevengeRevengeRevengeRevengeTennesseeIowaNorth CarolinaRevengeRenownRenownresultsunksunkokok1418North CarolinaIowaYamatosunksunkoksunkdamagedoksunkdamagedokokoklaunched192119151914194319151913194419421943194119171916191619161916191619161920194119441941Figure 2.23: Sample data for relation Ships320006500057! g) Find the classes that had only one ship as a member of that class.! h) Find those countries that had both battleships and battlecruisers.! i) Find those ships that &#34;lived to fight another day&#34;; they were damaged inone battle, but later fought in another. Exercise 2.4.3: This exercise builds upon Exercise 2.3.2 concerning WorldWar 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. Notethat, unlike the data for Exercise 2.4.1, there are some &#34;dangling tuples&#34; in thisdata, e.g., ships mentioned in Outcomes that are not mentioned in Ships.Write expressions of relational algebra to answer the following queries. Youmay 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 workfor arbitrary data, not just the data of these figures.a) Give the class names and countries of the classes that carried guns of atleast 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 heavier than35,000 tons. List the ships that violated the treaty of Washington.e) List the name, displacement, and number of guns of the ships engaged inthe battle of Guadalcanal.f) List all the capital ships mentioned in the database. (Remember that allthese ships may not appear in the Ships relation.)*Source: J. N. Westwood, Fighting Ships of World War II, Follett Publishing, Chicago.1975 and R. C. Stern, US Battleships in Action, Squadron/Signal Publications, Carrollton,TX, 1980.56CHAPTER 2. THE RELATIONAL MODEL OF DATAclassBismarckbbIowabbKongobcNorth Carolina bbRenownbcbbbbbbRevengeTennesseeYamatotype countryGermany8USA9Japan8USA9Gt. Britain 6Gt. Britain 8USAJapannameDenmaDenmark StraitGuadalcanal(a) Sample data for relation ClassesdatenumGuns bore displacement1516141615151418shipArizonaBismarck5/24-27/4111/15/42North Cape12/26/43Surigao Strait 10/25/44129(b) Sample data for relation BattlesbattleresultPearl HarborsunkDenmark Strait sunkSurigao StraitokNorth CapeokCaliforniaDuke of YorkFusoHoodKing George VKirishimaPrince of WalesRodneyScharnhorstSouth DakotaTennesseeWashingtonWest VirginiaYamashiroSurigao StraitDenmark StraitDenmark StraitGuadalcanalDenmark StraitDenmark StraitNorth CapeGuadalcanalSurigao StraitGuadalcanalsunksunkoksunkdamagedoksunkdamagedokokSurigao Strait okSurigao Strait sunk4200046000320003700032000290003200065000

Accepted Answer

Since there are multiple subparts, we will answer the first three subparts as per Bartleby Expert…

Give the class names and countries of the classes that carried guns of at least 16-inch bore. Find the ships launched prior to 1921. Find the ships sunk in the battle of the Denmark Strait.