Q 2. Solve question 7.32 from textbook - Consider the ER diagram of Figure 7.29, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and constraints that resulted in this schema. Try to be as precise as possible in your requirements and constraints specification. An ER diagram for an AIRLINE database schema. Airport code City State Name DEPARTURE AIRPORT N Leg.no AIRPORT Scheduled_dep_time Scheduled_arr_time FLIGHT_LEG M N N ARRIVAL CAN AIRPORT Instances LEGS LAND N Number Type_name Max_seats INSTANCE OF Company Airline FLIGHT AIRPLANE Arr_time N TYPE Weekdays DEPARTS ARRIVES N Restrictions FARES (Dep_time) TYPE Amount N N Code FARE Airplane id Total_no_of_seats No_of_avail_seats 3 Date AIRPLANE ASSIGNED LEG_INSTANCE Customer_name Cphone Seat_no RESERVATION Notes: N SEAT A LEG (segment) is a nonstop portion of a flight A LEG_INSTANCE is a particular occurrence of a LEG on a particular date