Develop the relations from the ER diagram. Show the output during each step of t
ID: 3827746 • Letter: D
Question
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.Explanation / Answer
Flight leg: needy on flight as well as on airport as it has identify relationship on also of its sides.
Fare: needy on flight.
Leg instance: needy on flight leg
Seat: needy on leg instance.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.