Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following data model and the relational model to answer the remaining questions. CRUISE VISITS V Order H Sailing Dute Return Dute Shame weight

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Use the following data model and the relational model to answer the remaining questions. CRUISE VISITS V Order H Sailing Dute Return Dute Shame weight Year but Passenger Capacity BOOKING Price Satisfaction date PORT PAKIR Port Name country Docking Fee PASSENGER Name First Name, Middle Name, Last Name Address Street Address, City State, Postal Code Country SHIP Ship ShipName Weight YearBuilt PassengerCapacity CRUISE Cruise SerialNo Sailing Date ReturnDate Shipid Booking Cruise Ser Passenger Price SatisfactionRate Passenger Passenger PFirstName PlastName PStreetAddress PCity Pstate PPostalCode PCountry PASSENGER Name (First Name, Middle Name, Last Name) Address Street Address, City, State, Postal Code, Country) SHIP Ship ShipName Weight YearBuilt PassengerCapacty CRUISE Cruise SerialNo Sailing Date ReturnDate Shipid Booking Cruise SerialNg Passenger Price Satisfaction Rate Passenger Passenger PFirstName PlastName PStreetAddress PCityPState PPostalCode PCountry VISIT Cruise SerialNo portid VisitOrder PORT Portid PortName PortCountry Docking Fee Which ports have not been visited? Display PortName, PortCountry and DockingFree. Explain what the following SQL query does. SELECT CruiseSerialNo, SUM(DockingFee) From Port, Visit WHERE Port.PortID= Visit.PortID GROUP BY Cruise SerialNo Explain what the following SQL query does. SELECT * FROM Passenger, Booking WHERE Passenger.PassengerID = Booking.PassengerID AND SatisfactionRate = (SELECT min(Satisfaction Rate) FROM Booking) OR SatisfactionRate = (SELECT max(Satisfaction Rate) FROM Booking); Explain what the following SQL query does. SELECT ShipName, SailingDate, PortName FROM Ship, Cruise, Visit, Port WHERE Ship.ShipID=Cruise.ShipID AND Cruise.CruiseSerialNo=Visit.CruiseSerialNo AND Port.PortID=Visit.PortID AND (PortName = 'Istanbul' OR PortName = 'Izmir') AND YEAR(CruiseSailingDate) = 2015

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

More Books

Students also viewed these Databases questions

Question

1. Identify what positions are included in the plan.

Answered: 1 week ago

Question

2. Identify the employees who are included in the plan.

Answered: 1 week ago

Question

7. Discuss the implications of a skill-based pay plan for training.

Answered: 1 week ago