HW2 Chapter 3 Due at 11:59 pm, Friday, 2/8/2019 1. (50 points) Consider the ER diagram of Figure 1, which shows a simplified schema for an airline reservations system. 1) 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. 2) Convert the constraint of each relationship from cardinality ratio to the (min, max) convention along with any assumptions you may make. Figure 1 An ER diagram for an AIRLINE database schema. Airport code City SeDEPARTURE AIRPORTN Leg no AIRPORT Scheduled_dep tim Scheduled_arr_tim FLIGHT LEG 1ARRIVAL AIRPORT Instances LEGS CAN LAND Number INSTANCE OF Type name Max_seats Airline FLIGHT Compan Arr time Weekdays AIRPLANE TYPE DEPARTS> 1 Restrictions FARES ARRIVES Dep time Amount TYPE o_of_avail_seat Airplane-id / I-Total-no-of-seats Date 1 LEG-INSTANCE AIRPLANE-ASSIGNED)- Cphone stomer name Seat no A LEG (segment) is a nonstop portion of a flight. A LEG INSTANCE is a particular occurrence RESERVATIONNotes: SEAT of a LEG on a particular date