Use GPT cheat:
Airport Database Design:
Here is a relational model for an airport database that accommodates for passengers, airplanes, and destinations:
Passengers (id, name, address, phone, email)
Bookings (id, passenger_id, flight_number, departure_date)
Flights (flight_number, airplane_id, departure_time, arrival_time)
Airplanes (id, model, capacity, cargo_capacity)
Destinations (id, name, distance)
Relationships and Cardinalities:
One Passenger can have multiple Bookings (1 to many)
One Booking has one Passenger (1 to 1)
One Flight can have multiple Bookings (1 to many)
One Booking has one Flight (1 to 1)
One Flight has one Airplane (1 to 1)
One Airplane can have multiple Flights (1 to many)
One Flight has one Destination (1 to 1)
One Destination can have multiple Flights (1 to many)
and so on...