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: PEARSON
Bartleby Related Questions Icon

Related questions

Q: Design an algorithm that will prompt a terminal operator for three characters, accept those…
A: Algorithm: The algorithm for the given statements is as given below:
Q: el and a numb
A: P(a vowel and a number less than 3)
Q: An ISBN-10 (International Standard Book Number) consists of 10 digits: The last digit, is a…
A: Java code: import java.util.Scanner; public class Main{    public static void main(String[] args){…
Q: Explain the use of the 51 and 59 modifiers.
A: We need to write about the use of 51 and 59 modifiers.
Q: 0,1 a 0 O b a
A: Regular Expression: A regular expression is exists for all the regular languages. A regular…
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.
expand button
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
expand button
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
Check Mark
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
bartleby
This is a popular solution
See solutionCheck out a sample Q&A here
Step 1
VIEW
Step 2
VIEW
Step 3
VIEW
Step 4
VIEW
bartleby

Trending nowThis is a popular solution!

bartleby

Step by stepSolved in 4 steps with 1 images

See solution
Check out a sample Q&A here
Blurred answer
Still need help?
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
by Bartleby Expert
SEE SOLUTION
Follow-up Question

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

Solution
Bartleby Expert
by 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
by Bartleby Expert
SEE SOLUTION
Follow-up Question

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

Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
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
by Bartleby Expert
SEE SOLUTION
Follow-up Question

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

Solution
Bartleby Expert
by 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
by Bartleby Expert
SEE SOLUTION
Follow-up Question

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

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