Question 1: Consider the following relational database schema used to keep track of Ship cruise details.
Ships (ShipID, Ship_Name, Manufacturer)
Cruises (CruiseID, CruiseName, ShipID, Start_date, End_date )
Rooms (RoomID, ShipID, RoomName, Type, Price)
Passenger_Reservation(ReservationID, CruiseID, PassengerID, RoomID)
Passenger (PassengerID, SSN, Name, Gender, Age)
Ports (PortName, PortID, City)
Cruise_stay_at_Ports(CruiseID, PortID)
Write down relational expressions for the following queries.
1. Find all the cruises that are offered by the ship named “SuperX”.
2. List all family rooms with a price above Rs 10000 per night.
3. List the name of Passenger who have reserved a room with a price above Rs 5000 per night.
4. For the cruise named “Crex” retrieve the list of ports it includes. Output: CruiseID,PortID,PortName.