Flights

1
Passengers
PassengerType
1
1
M
M
Airlines
Passenger-Flights
1
M
1
M
M
1
M
1
Flights
Planes
Airports
1
M
Seating
2

• Give me all of the flights leaving from Columbus,
  OH (airport code CMH) to Cleveland, OH (airport
  code CLE) on February 14, 2000 between 1200 and
  1800 (6pm).

FlightNumber ,Name ,DepartureDate ,DepartureTime ,
ArrivalDate ,ArrivalTime
Airlines
AirlineID ID
(
)
Flights
Planes
DepartureAirportCMH and ArrivalAirpotCLE
and DepartureDateTime gt0214001200
and DepartureDateTime lt0214001800
ID PlaneID
3
2. Give me all the passengers on flight 1234 out
of Atlanta (code ATL) on March 10, 2000.
Passengers
)
(
PassengerNumber
(
)
Flights
Passenger-Flights
FlightNumber FlightNumber and DepartureDTDepart
ureDT and ArrivalDTArrivalDT and PlaneIDPlaneID
DepartureAirportATL and FlightNumber1234
and DepartureDateTime 031000
4
3. My name is John Smith, social security number
999-99-8888. I am flying out of Dayton, OH (code
DAY) on February 8, 2001 to New York (code LGA).
Can you tell me where I am seating on
my flight?
)
(
Seat, Category
Seating
PlaneID PlaneID and Seat Seat
(
)
(
)
Passenger-Flights
Flights
PassengerID999998888
FlightNumber FlightNumber and DepartureDTDepart
ureDT and ArrivalDTArrivalDT and PlaneIDPlaneID
DepartureAirportDAY and ArrivalAirportLGA
and DepartureDate 020800