Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
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.

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.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
Question
Please answer from ‘a’ to ‘i’
Tennessee Yamato name bb USA bb California Haruna Hiei Iowa Kirishima Kongo Missouri Musashi ship Arizona Bismarck California Duke of York Fuso Hood King George V Kirishima Prince of Wales Rodney Scharnhorst South Dakota Tennessee Washington Japan name Denmark Strait Guadalcanal West Virginia Yamashiro (a) Sample data for relation Classes date North Cape Surigao Strait Ramillies Renown Repulse Resolution. 2.4. AN ALGEBRAIC QUERY LANGUAGE Tennessee Washington Wisconsin Yamato (b) Sample data for relation Battles battle Pearl Harbor Denmark Strait Surigao Strait North Cape New Jersey North Carolina Revenge Royal Oak Royal Sovereign (c) Sample data for relation Outcomes 12 class Figure 2.22: Data for Exercise 2.4.3 5/24-27/41 11/15/42 12/26/43 10/25/44 Surigao Strait Denmark Strait Denmark Strait Guadalcanal Denmark Strait Denmark Strait North Cape Guadalcanal Surigao Strait Guadalcanal Surigao Strait Surigao Strait sunk Tennessee Kongo Kongo Iowa Kongo Kongo Iova Yamato Revenge Revenge Revenge Revenge Tennessee Iowa North Carolina Revenge Renown Renown result sunk sunk ok ok 14 18 North Carolina Iowa Yamato sunk sunk ok sunk damaged ok sunk damaged ok ok ok launched 1921 1915 1914 1943 1915 1913 1944 1942 1943 1941 1917 1916 1916 1916 1916 1916 1916 1920 1941 1944 1941 Figure 2.23: Sample data for relation Ships 32000 65000 57 ! 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 in one battle, but later fought in another.
Transcribed Image Text:Tennessee Yamato name bb USA bb California Haruna Hiei Iowa Kirishima Kongo Missouri Musashi ship Arizona Bismarck California Duke of York Fuso Hood King George V Kirishima Prince of Wales Rodney Scharnhorst South Dakota Tennessee Washington Japan name Denmark Strait Guadalcanal West Virginia Yamashiro (a) Sample data for relation Classes date North Cape Surigao Strait Ramillies Renown Repulse Resolution. 2.4. AN ALGEBRAIC QUERY LANGUAGE Tennessee Washington Wisconsin Yamato (b) Sample data for relation Battles battle Pearl Harbor Denmark Strait Surigao Strait North Cape New Jersey North Carolina Revenge Royal Oak Royal Sovereign (c) Sample data for relation Outcomes 12 class Figure 2.22: Data for Exercise 2.4.3 5/24-27/41 11/15/42 12/26/43 10/25/44 Surigao Strait Denmark Strait Denmark Strait Guadalcanal Denmark Strait Denmark Strait North Cape Guadalcanal Surigao Strait Guadalcanal Surigao Strait Surigao Strait sunk Tennessee Kongo Kongo Iowa Kongo Kongo Iova Yamato Revenge Revenge Revenge Revenge Tennessee Iowa North Carolina Revenge Renown Renown result sunk sunk ok ok 14 18 North Carolina Iowa Yamato sunk sunk ok sunk damaged ok sunk damaged ok ok ok launched 1921 1915 1914 1943 1915 1913 1944 1942 1943 1941 1917 1916 1916 1916 1916 1916 1916 1920 1941 1944 1941 Figure 2.23: Sample data for relation Ships 32000 65000 57 ! 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 in one battle, but later fought in another.
Exercise 2.4.3: This exercise builds upon Exercise 2.3.2 concerning World 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 heavier than 35,000 tons. List the ships that violated the treaty of Washington. e) List the name, displacement, and number of guns of the ships engaged in the battle of Guadalcanal. f) List all the capital ships mentioned in the database. (Remember that all these 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. 56 CHAPTER 2. THE RELATIONAL MODEL OF DATA class Bismarck bb Iowa bb Kongo bc North Carolina bb Renown bc bb bb bb Revenge Tennessee Yamato type country Germany 8 USA 9 Japan 8 USA 9 Gt. Britain 6 Gt. Britain 8 USA Japan name Denma Denmark Strait Guadalcanal (a) Sample data for relation Classes date numGuns bore displacement 15 16 14 16 15 15 14 18 ship Arizona Bismarck 5/24-27/41 11/15/42 North Cape 12/26/43 Surigao Strait 10/25/44 12 9 (b) Sample data for relation Battles battle result Pearl Harbor sunk Denmark Strait sunk Surigao Strait ok North Cape ok California Duke of York Fuso Hood King George V Kirishima Prince of Wales Rodney Scharnhorst South Dakota Tennessee Washington West Virginia Yamashiro Surigao Strait Denmark Strait Denmark Strait Guadalcanal Denmark Strait Denmark Strait North Cape Guadalcanal Surigao Strait Guadalcanal sunk sunk ok sunk damaged ok sunk damaged ok ok Surigao Strait ok Surigao Strait sunk 42000 46000 32000 37000 32000 29000 32000 65000
Transcribed Image Text:Exercise 2.4.3: This exercise builds upon Exercise 2.3.2 concerning World 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 heavier than 35,000 tons. List the ships that violated the treaty of Washington. e) List the name, displacement, and number of guns of the ships engaged in the battle of Guadalcanal. f) List all the capital ships mentioned in the database. (Remember that all these 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. 56 CHAPTER 2. THE RELATIONAL MODEL OF DATA class Bismarck bb Iowa bb Kongo bc North Carolina bb Renown bc bb bb bb Revenge Tennessee Yamato type country Germany 8 USA 9 Japan 8 USA 9 Gt. Britain 6 Gt. Britain 8 USA Japan name Denma Denmark Strait Guadalcanal (a) Sample data for relation Classes date numGuns bore displacement 15 16 14 16 15 15 14 18 ship Arizona Bismarck 5/24-27/41 11/15/42 North Cape 12/26/43 Surigao Strait 10/25/44 12 9 (b) Sample data for relation Battles battle result Pearl Harbor sunk Denmark Strait sunk Surigao Strait ok North Cape ok California Duke of York Fuso Hood King George V Kirishima Prince of Wales Rodney Scharnhorst South Dakota Tennessee Washington West Virginia Yamashiro Surigao Strait Denmark Strait Denmark Strait Guadalcanal Denmark Strait Denmark Strait North Cape Guadalcanal Surigao Strait Guadalcanal sunk sunk ok sunk damaged ok sunk damaged ok ok Surigao Strait ok Surigao Strait sunk 42000 46000 32000 37000 32000 29000 32000 65000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Can you draw the expression tree for g h and i ?

Solution
Bartleby Expert
SEE SOLUTION
Follow-up Question

Can you draw the expression tree for each of these expressions?

Solution
Bartleby Expert
SEE SOLUTION
Follow-up Question

Thank you, can you answer the last subparts of the questions 'g','h', and  'i'

Solution
Bartleby Expert
SEE SOLUTION
Follow-up Question

Can you please answer 'd', 'e', 'f' as well please? 

Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS