PLEASE I ONLY WANT ANSWER TO THE SECOND QUESTION ONLY, THAT IS NUMBER TWO (2).

I BELIEVE THE COMPLETE IMAGE I JUST UPLOADED WILL HELP AND AID YOU TO UNDERSTAND THE QUESTION VERY WELL.

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 codeCity Sate Name DEPARTURE AIRPORT N Leg.no AIRPORT Scheduled_dep_timeScheduled_arr tim FLIGHT LEG 1ARRIVAL CAN LAND InstancesLEGS AIRPORT Number Type name) Max seats INSTANCE_OF Company Airline FLIGHT AIRPLANE- TYPE Arr time Weekdays DEPARTS> 1 ARRIVES Restrictions FARES Dep time Amount TYPE CodeFARE Airplane_ idTotal_ no_of_seats o_of_avail_seat Date AIRPLANE ASSIGNED LEG INSTANCE Customer, name Seat no SEAT Cphone RESERVATION Notes: A LEG (segment) is a nonstop portion of a flight A LEG INSTANCE is a particular occurrence of a LEG on a particular date. 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 (CityStateName DEPARTURE AIRPORTN Leg no AIRPORTScheduled dep. time Scheduled. arr meFLIGHT LEG Scheduled_arr_tim ARRIVAL AIRPORT Instances LEGS CAN LAND Number INSTANCE OF Tvpe name) Max seats AirlineFLIGHT Compan Arr time Weekdays AIRPLANE TYPE DEPARTS 1 Restrictions FARES ARRIVES Dep time Amount TYPE o of_avail seat Airplane-id 1 ARRIVES Restrictions FARES Dep time Amount TYPE CodeFARE Airplane_ idTotal_ no_of_seats o_of_avail_seat Date AIRPLANE ASSIGNED LEG INSTANCE Customer, name Seat no SEAT Cphone RESERVATION Notes: A LEG (segment) is a nonstop portion of a flight A LEG INSTANCE is a particular occurrence of a LEG on a particular date. 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 (CityStateName DEPARTURE AIRPORTN Leg no AIRPORTScheduled dep. time Scheduled. arr meFLIGHT LEG Scheduled_arr_tim ARRIVAL AIRPORT Instances LEGS CAN LAND Number INSTANCE OF Tvpe name) Max seats AirlineFLIGHT Compan Arr time Weekdays AIRPLANE TYPE DEPARTS 1 Restrictions FARES ARRIVES Dep time Amount TYPE o of_avail seat Airplane-id