Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following relational database for Happy Cruise Lines. It keeps track of ships, cruises, ports, and passengers. A cruise is a particular sailing of

Consider the following relational database for Happy Cruise Lines. It keeps track of ships, cruises, ports, and passengers. A \"cruise\" is a particular sailing of a ship on a particular date. For example, the sevenday journey of the ship Pride of Tampa that leaves on June 13, 2003, is a cruise. Note the following facts about this environment. Both ship number and ship name are unique in the SHIP Relation. A ship goes on many cruises over time. A cruise is associated with a single ship. A port is identified by the combination of port name and country. As indicated by the VISIT Relation, a cruise includes visits to several ports and a port is typically included in several cruises. Both Passenger Number and Social Security Number are unique in the PASSENGER Relation. A particular person has a single Passenger Number that is used for all of the cruises that she takes. The VOYAGE Relation indicates that a person can take many cruises and a cruise, of course, has many passengers. Ship Table Ship Ship Number Name Cruise Launch Builder Date Weight Cruise Table Cruise Start End Cruise Ship Number Date Date Director Number Port Table Port Name Country Number of Port Docks Manager Visit Table Cruise Port Country Arrival Departure Number Name Date Date Passenger Table Passenger Passenger Social Security Home Telephone Number Name Number Address Number Voyage Table Passenger Cruise Stateroom Number Number Number Fare Write SQL SELECT commands to answer the following queries. a. Find the start and end dates of cruise number 35218. b. List the names and ship numbers of the ships built by the Ace Shipbuilding Corp. that weigh more than 60,000 tons. c. List the company's that have built ships for Happy Cruise Lines. d. Find the total number of docks in all of the ports in Canada. e. Find the average weight of the ships built by the Ace Shipbuilding Corp. that have been launched since 2000. f. How many ports in Venezuela have at least three docks? g. Find the total number of docks in each country. List the results in order from most to least. h. Find the total number of ports in each country i. Find the total number of docks in each country but only include those countries that have at least twelve docks in your answer. j. Find the name of the ship that operated on (was used on) cruise number 35218. k. List the names, addresses, and telephone numbers of the passengers who sailed on The Spirit of Nashville on cruises that began during July, 2003. l. Find the names of the company's heaviest ships. m. Find the names of the company's heaviest ships that began a cruise between July 15, 2003 and July 31, 2003

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management An Introduction

Authors: David Boddy

6th Edition

129200424X, 978-1292004242

More Books

Students also viewed these General Management questions

Question

Would you recommend dynamic addressing for your organization? Why?

Answered: 1 week ago