Consider the following relations and specify relational algebra statements.
Note: For relational algebra symbols use Microsoft Word -> Insert -> Symbol or any other tool.
FLIGHT (FlightCode, AirlineName, FromAirport, DestAirport, Date, DepartureTime, NoOfAvailSeats)
PRICES (FlightCode, EconomyFare, BusinessFare)
PASSENGER (PassengerCode, Name, Address, Telephone)
BOOKING (BookingRefNo, PassengerCode, FlightCode, Deposit, TotalFare)
a. Find the codes and names of the flights coming from Lahore.
b. Find the names and telephone numbers of the passengers who have booked any ticket.
c. Find the code, airline name and departure time of the flight with the economy fare.
d. Find the booking reference number along with airline names, date and number of available seats.