DAS Assignment

Tables (10)

Customer (customer)

  • booking_number — int(10) — Foreign key → Reservation.booking_number — NOT NULL
  • first_name — varchar(50) — NOT NULL
  • last_name — varchar(50) — NOT NULL
  • mailing_address — varchar(20) — NOT NULL
  • house_contact — number — NOT NULL
  • email — varchar(20) — NOT NULL

Each Flight Members (each_flight_members)

  • staff_number — INT(10) — Foreign key → Pilot.staff_number — NOT NULL
  • unique_id — int(10) — Foreign key → Flight Attendant.unique_id — NOT NULL
  • flight_id — int(11) — Foreign key → Flight.flight_id — NOT NULL

Flight (flight)

  • flight_id — int(11) — Primary key — NOT NULL
  • totalseats_business — numeric — NOT NULL
  • Total Seats Economy (totalseats_economy) — numeric — NOT NULL

Flight Attendant (flight_attendant)

  • unique_id — int(10) — Primary key — NOT NULL
  • fullname — varchar(50) — NOT NULL
  • position — varchar(20) — NOT NULL
  • phone_number — varchar(20) — NOT NULL
  • address — varchar(255) — NOT NULL
  • city — varchar(20) — NOT NULL
  • postal_code — number — NOT NULL
  • country — varchar(10) — NOT NULL

Mailing Address (mailing_address)

  • booking_number — int(10) — Foreign key → Customer.booking_number — NOT NULL
  • street — varchar(50) — NOT NULL
  • city — varchar(50) — NOT NULL
  • state (statev) — varchar(20) — NOT NULL
  • postal_code — number — NOT NULL
  • country — varchar(20) — NOT NULL
  • Field

One or more flight (one_or_more_flight)

  • staff_number — INT(10) — Foreign key → Pilot.staff_number — NOT NULL

Pilot (pilot)

  • staff_number — INT(10) — Primary key — NOT NULL
  • first_name — VARCHAR(50) — NOT NULL
  • last_name — VARCHAR(50) — NOT NULL
  • age — VARCHAR(20) — NOT NULL
  • year_of_experience — numeric — NOT NULL
  • flying_hours — numeric — NOT NULL
  • position — varchar(20) — NOT NULL
  • salary — money — NOT NULL

Reservation (reservation)

  • booking_number — int(10) — Primary key — NOT NULL
  • booking_state — varchar(50) — NOT NULL
  • booking_date — date — NOT NULL
  • date_of_depature — datetime — NOT NULL
  • time_of_depature — time — NOT NULL
  • date_of_arrival — datetime — NOT NULL
  • time_of_arrival — time — NOT NULL
  • class_indicator — varchar(20) — NOT NULL
  • price — money — NOT NULL
  • status_indicator — varchar(20) — NOT NULL
  • flight_id — int(11) — Foreign key → Flight.flight_id — NOT NULL
  • paid_by — varchar(50) — NOT NULL
  • amount_paid — decimal (5, 2) — NOT NULL
  • outstanding_balance — decimal(5, 2) — NOT NULL
  • first_name — varchar(50) — NOT NULL
  • last_name — varchar(50) — NOT NULL

Senior Pilot (senior_pilot)

  • staff_number — INT(10) — Foreign key → Pilot.staff_number — NOT NULL
  • flying_hpurs (flying_hours) — numeric — NOT NULL
  • first_name — varchar(50) — NOT NULL
  • last_name — varchar(50) — NOT NULL

Zero Or More House Number (zero_or_more_house_number)

  • booking_number — int(10) — Foreign key → Customer.booking_number — NOT NULL
  • house_contact — number — NOT NULL