Submit Relational Model of ER diagram of Figure 7.29 in the Book (Q2 from Week 4 Lab)

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 N LEGS FLIGHT M ARRIVAL N CAN AIRPORT Instances LAND N Number Type_name Max_seats INSTANCE OF Company Airline AIRPLANE Arr_time TYPE Weekdays DEPARTS ARRIVES Restrictions N (Dep_time) N Amount TYPE N Code FARES FARE Airplane_id Total_no_of_seats No_of_avail_seats Date LEG_INSTANCE AIRPLANE ASSIGNED Customer_name Cphone Seat no RESERVATION N SEAT 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