Design a database for airlines reservation system
Answers
Answered by
1
each Aircraft can have one or more TravelClasses
each Aircraft has many Seats.
each Flight has only one AircraftInstance (of Aircraft)
prices for Flight differ for TravelClasses that are known through AircraftInstance assigned to Flight
Client must know which seats are available for Flight booking and a price of the seat
What I have for now:

Please, leave suggestions. Thank you!
each Aircraft has many Seats.
each Flight has only one AircraftInstance (of Aircraft)
prices for Flight differ for TravelClasses that are known through AircraftInstance assigned to Flight
Client must know which seats are available for Flight booking and a price of the seat
What I have for now:

Please, leave suggestions. Thank you!
Similar questions