Suppose you have the following database.Using Procedures i.e. CURSORS display Flightid, Departure and Arrival date, Departure airport city and Arrival Airport city

Passenger passengerID INT firstName VARCHAR(45) lastName VARCHAR(45) email VARCHAR(45) age INT Booking ticketIDINT flightID INT seatNum VARCHAR(5) dass VARCHAR(45) passengerID INT ------ Indexes Indexes - - Airport airportID INT name VARCHAR(45) aty VARCHAR(45) country VARCHAR(45) code VARCHAR(45) - - - - Indexes Flight flightID INT departure Time TIME departureDate DATE arrival Time TIME arrivalDate DATE routeID INT - - - - , Route routeID INT airlineID INT departureAirportID INT arrivalAirportID INT Indexes Indexes Airline airlineID INT name VARCHAR(45) code VARCHAR(45) country VARCHAR(45) Indexes Pilot pilotID INT firstName VARCHAR(45) lastName VARCHAR(45) experience INT Flight_Pilot flightID INT pilotID INT ---- Indexes Indexes Passenger passengerID INT firstName VARCHAR(45) lastName VARCHAR(45) email VARCHAR(45) age INT Booking ticketIDINT flightID INT seatNum VARCHAR(5) dass VARCHAR(45) passengerID INT ------ Indexes Indexes - - Airport airportID INT name VARCHAR(45) aty VARCHAR(45) country VARCHAR(45) code VARCHAR(45) - - - - Indexes Flight flightID INT departure Time TIME departureDate DATE arrival Time TIME arrivalDate DATE routeID INT - - - - , Route routeID INT airlineID INT departureAirportID INT arrivalAirportID INT Indexes Indexes Airline airlineID INT name VARCHAR(45) code VARCHAR(45) country VARCHAR(45) Indexes Pilot pilotID INT firstName VARCHAR(45) lastName VARCHAR(45) experience INT Flight_Pilot flightID INT pilotID INT ---- Indexes Indexes