Flight Booking

Tables (10)

Airline (Untitled9)

  • Airline_code (Key) — Primary key — NOT NULL

Airport (Untitled8)

  • Airport_Code (Key) — Primary key — NOT NULL

Booking Agency (Untitled3)

  • Agency_Code (Key) — Primary key — NOT NULL
  • Passport_ID — Foreign key → Passenger.Passport_ID — NOT NULL
  • Passenger_ID (Field)
  • Flight_ID (Field2)
  • Ticket_Price (Field3)
  • CreditCard_info (Field4)
  • seat_class (Field5)
  • Airline (Field6)

Cabin Crew (CopyOfUntitled6)

  • EMP_NUM (Key) — Primary key — NOT NULL
  • Position (Field)

Employee (Untitled5)

  • EMP_NUM (Key2) — Foreign key → Pliot.EMP_NUM — NOT NULL
  • EMP_Name (Field)
  • EMP_mobile (Field2)
  • Depart_Code (Field3)

Flight (Untitled2)

  • Flight_ID (Key) — Primary key — NOT NULL
  • EMP_NUM (Key2) — Foreign key → Employee.EMP_NUM — NOT NULL
  • Airport_Code (Key3) — Foreign key → Airport.Airport_Code — NOT NULL
  • Passport_ID — Foreign key → Passenger.Passport_ID — NOT NULL
  • Airline_code (Key5) — Foreign key → Airline.Airline_code — NOT NULL
  • Airline_ID (Field)
  • From (Field2)
  • to (Field3)
  • Departure_time (Field4)
  • Arrival_time (Field5)

Luggage (Untitled4)

  • Luggage_Code (Key) — Primary key — NOT NULL
  • Passport_ID — Foreign key → Passenger.Passport_ID — NOT NULL
  • weight (Field)
  • price (Field2)

Passenger (Untitled)

  • Passport_ID — Primary key — NOT NULL
  • Flight_ID (Key)
  • Visa_num
  • mileage (Field)

Pliot (Untitled6)

  • EMP_NUM (Key) — Primary key — NOT NULL
  • license_ID (Field)

Seat (Untitled7)

  • Seat_num (Key) — Primary key — NOT NULL
  • Passport_ID — Foreign key → Passenger.Passport_ID — NOT NULL
  • Flight_ID (Key2) — Foreign key → Flight.Flight_ID — NOT NULL
  • EMP_NUM (Key22) — Foreign key → Flight.EMP_NUM — NOT NULL
  • Airport_Code (Key3) — Foreign key → Flight.Airport_Code — NOT NULL
  • Passport_ID (Passport_ID2) — Foreign key → Flight.Passport_ID — NOT NULL
  • Airline_code (Key5) — Foreign key → Flight.Airline_code — NOT NULL