Develop the relations from the ER diagram. Show the output during each step of the ER-to-Relation algorithm. At the end, specify the final set of tables, their keys, and their foreign keys. In the final set of tables, do not specify all the attributes, only the keys and foreign keys.

An ER diagram for an AIRLINE database schema. Airport code Cty State Name DEPARTURE AIRPORT N Leg no AIRPORT Scheduled dep time Scheduled arr time FLIGHT LEG 1 ARRIVAL CAN AIRPORT Instances LEGS LAND Number INSTANCE OF Type name Max seats FLIGHT Airline Company AIRPLANE Arr time Weekdays TYPE DEPARTS 1 FARES Restrictions ARRIVES Dep-time Amount TYPE Code FARE Airplane id Total no of seats o of avail seats Date ASSIGNED LEG INSTANCE AIRPLANE Customer name Cphone Seat no RESERVATION Notes A LEG (segment) is a nonstop portion of a flight. SEAT A LEG INSTANCE is a particular occurrence of a LEG on a particular date