Added on:
Mar 13, 2025
User Prompt
A database is being constructed to keep the record of all airlines, airplanes and (inboarding/outboarding) flights operated in an airport. Each airline company has a number of airplanes. Each airplane has an unique identify number, model number(ex. BOE-747, AIRBUS-A380) and other information (like number of seats and so on). It is desirable for the database to keep track of the airline and airplane on each flight. Each flight should have the departure airport which may include airport name, city, capacity, etc. While each flight only has one departure airport to start from, it may have more than one stop place (airport). Design an ER schema diagram for this application, stating any extra assumptions you'd like to make.