test

Tables (3)

Flight (Untitled)

  • FlightNo (Key) — Primary key — NOT NULL
  • name (Field)
  • date (Field2)

Passenger (Untitled3)

  • PassengerNo (Field) — Primary key

Reservation (Untitled2)

  • ReservedDate (Field) — Primary key
  • FlightNo (Key) — Foreign key → Flight.FlightNo — NOT NULL
  • PassengerNo (Field2) — Foreign key → Passenger.PassengerNo