Perform the complete transformation steps from the following ER Diagram to obtain the corresponding relational model....

Transcribed Image Text:

Perform the complete transformation steps from the following ER Diagram to obtain the corresponding relational model. Airport code City State Name AIRPORT Company CAN LAND N Type name Max_seats M AIRPLANE TYPE TYPE N Airplane id AIRPLANE Seat no SEAT Scheduled_dep_time Scheduled_arr_time Dep_time Total_no_of_seats Customer_name DEPARTS N N ASSIGNED DEPARTURE AIRPORT ARRIVAL AIRPORT ARRIVES RESERVATION N Arr_time Cphone N INSTANCE OF N Number Airline Weekdays Restrictions Amount Code No_of_avail_seats LEG_INSTANCE Date Leg no FLIGHT LEG N LEGS FLIGHT FARES N FARE 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. Perform the complete transformation steps from the following ER Diagram to obtain the corresponding relational model. Airport code City State Name AIRPORT Company CAN LAND N Type name Max_seats M AIRPLANE TYPE TYPE N Airplane id AIRPLANE Seat no SEAT Scheduled_dep_time Scheduled_arr_time Dep_time Total_no_of_seats Customer_name DEPARTS N N ASSIGNED DEPARTURE AIRPORT ARRIVAL AIRPORT ARRIVES RESERVATION N Arr_time Cphone N INSTANCE OF N Number Airline Weekdays Restrictions Amount Code No_of_avail_seats LEG_INSTANCE Date Leg no FLIGHT LEG N LEGS FLIGHT FARES N FARE 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.