Relations for ER Figure 3.16

asterisks next to attribute names indicate primary key attribute(s).
plusses indicate foreign keys

AIRPORT(AirportCode*, Name, City, State)
AIRPLANE_TYPE(TypeName*, Max-seats, Company)
AIRPLANE(AirplaneId*, Total_no_of_seats, TypeName+)
FLIGHT(Number*, Weekdays, Airline)

FLIGHT_LEG(LegNo*, FLIGHTNumber*, DEPARTUREAIRPORTAirportCode+, ARRIVALAIRPORTAirportCode+, Scheduled_DepTime, Scheduled_ArrTime)
LEG_INSTANCE(Date*, LegNo*, FLIGHTNumber*, No_of_avail_seats, DEPARTUREAIRPORTAirportCode+, ARRIVALAIRPORTAirportCode+, DepTime, ArrTime, AirplaneId+)
FARE(Code*, FLIGHTNumber*, Amount, Restrictions)
SEAT(SeatNo*, Date*, LEGLegNo*, FLIGHTNumber*, CustomerName, CPhone)

CAN_LAND(AIRPORTAirportCode*, AIRPLANE_TYPETypeName*)