Write SQL statements to do the following on the database schema shown in figure 3. a. Insert a new airport, , in the database. b. update the seat_reservation of customer Smith to 32. c. Insert a new airplane, . d. Delete the record for the Birmingham Airport that you inserted in question 4a. e. Retrieve all airplane types on Birmingham airport

Figure 3- Airline Relational Database Schema AIRPORT Airport_code Name City State FLIGHT Flight_number Airline Weekdays FLIGHT_LEG Flight_number Leg_number Departure_airport_code Arrival_airport_code Scheduled_departure_time Scheduled_arrival_time LEG_INSTANCE Flight number Leg_number Date Number_of_available_seats Airplane_id Departure_airport_code Departure_time Arrival_airport_code Arrival_time FARE Flight_number Fare_code Amount Restrictions AIRPLANE_TYPE Airplane_type_name Max_seats Company CAN_LAND Airplane_type_name Airport_code AIRPLANE Airplane id Total_number_of_seats Airplane_type SEAT RESERVATION Flight_number Leg. number Date Seat number Customer_name Customer_phone