Question: Use the following data model and the relational model to answer the remaining questions, CRUISE VISITS Vat Order Sailing Date Return Date weight Passenger capety

 Use the following data model and the relational model to answer
the remaining questions, CRUISE VISITS Vat Order Sailing Date Return Date weight
Passenger capety BOOKING Price Satisfaction tate PORT BALTIR Port Name Country Docking
Fee PASSENGER be Name First name, Middle Name, Last Name Address Street
Address City State, Potcode Country SHIP Shiol ShioName Weight YearBuilt PassengerCapacty CRUISE

Use the following data model and the relational model to answer the remaining questions, CRUISE VISITS Vat Order Sailing Date Return Date weight Passenger capety BOOKING Price Satisfaction tate PORT BALTIR Port Name Country Docking Fee PASSENGER be Name First name, Middle Name, Last Name Address Street Address City State, Potcode Country SHIP Shiol ShioName Weight YearBuilt PassengerCapacty CRUISE Cruise Serialo Sailing Date ReturnDate Shipid Booking Cruise SerialNo Passenger Price Satisfaction Rate Passenger Passenger FirstName PlastName StreetAddress PCityPState PostalCode PCountry PASSENGER Passenger Number Name (First Name, Middle Name, Last Name) Address Street Address, city, State, Postal Code, Country) SHIP Ship ShipName Weight YearBuilt PassengerCapacty CRUISE Cruise SerialNo SailingDate ReturnDate Shipid Booking Cruise SerialNg Passenger Price Satisfaction Rate Passenger PassengerDPFirstName PlastName PStreetAddress PCityPState PPostalCode PCountry VISIT Cruise SerialNo Portid VisitOrder PORT Portid PortName PortCountry Docking Fee What is the total number of bookings on each cruise? Display cruiseld and number of bookings. Which port has the highest docking fee? Display Portname and docking fee. S Question 32 Which cruises has an average satisfaction rating that is greater than 4? List the CruiseSerialNo and Satisfaction Rate for those cruises that have an average satisfaction rate greater than 4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!