(Solved) : Please Help Database Relational Algebra Example Need Answer Format Concat Fname Lname Full Q35375322 . . . .

Please help me with this database relational algebra(forexample, I need answer to have this format. “πconcat(Fname,Lname)->fullname,Bdate,Sex σSuper_ssn=333445555(Employee)” questions refer to the table given below.Thank you

1) How many airports are in each state?

2) List all airlines that operate at Los Angeles InternationalAirport (LAX)

Hint – Use a union on the flight leg relation between departingand arriving flights

3) What is the least expensive flight number withoutrestrictions. Show a single result using the appropriate mathfunction (use Gamma operator).

4) List the name and phone number of all customers with a seatreserved on a flight that leaves Stockton airport (SCK) on January28, 2018.

Hint – Use the