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)
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...
Related questions
Question
Please answer from ‘a’ to ‘i’
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.
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images
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
by Bartleby ExpertFollow-up Question
Can you draw the expression tree for each of these expressions?
Solution
by Bartleby ExpertFollow-up Question
Thank you, can you answer the last subparts of the questions 'g','h', and 'i'
Solution
by Bartleby ExpertFollow-up Question
Can you please answer 'd', 'e', 'f' as well please?
Solution
by Bartleby ExpertRecommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY