Computer Science, asked by mannanp625, 1 year ago

Design a database for airlines reservation system

Answers

Answered by ayush579
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!

Similar questions