Problem 1 Consider the AIRLINE relational database schema shown below. Specify the following queries in relational algebra: a. For each flight, list the flight number, the departure airport for the first leg of the flight, and the arrival airport for the last leg of the flight. b. List the flight numbers and weekdays of all flights or flight legs that depart from Houston Intercontinental Airport (airport code 'iah') and arrive in Los Angeles International Airport (airport code 'lax) c. List all fare information for flight number 'co197 d. Retrieve the number of available seats for flight number 'co197' on '2009-10-09'. e. Make up 3 additional queries in English and provide the respective relational algebra commands. Be creative