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
English,
7 months ago
Social Sciences,
7 months ago
Physics,
1 year ago
English,
1 year ago
Math,
1 year ago