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 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
Get step-by-step solutions from verified subject matter experts
