asd

Tables (4)

CreditCards

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Members.Key — NOT NULL
  • MemberID — VARCHAR(10)
  • CardNumber — VARCHAR(16)
  • ExpirationDate — VARCHAR(7)

Flights

  • Key — Primary key — NOT NULL
  • FlightNumber — VARCHAR(10)
  • DepartureDate — DATE
  • DepartureTime — TIME

Members

  • Key — Primary key — NOT NULL
  • MemberID — VARCHAR(10)
  • Password — VARCHAR(20)
  • Name — VARCHAR(50)

Seats

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Flights.Key — NOT NULL
  • SeatNumber — VARCHAR(10)
  • Class — VARCHAR(20)
  • FlightNumber — VARCHAR(10)
  • Key (Key3) — Foreign key — NOT NULL