ex_04

Tables (7)

ACTOR (Untitled7)

  • ACTORId (Key) — char(10) — Primary key — NOT NULL
  • MovieName (Key2) — char(20) — Foreign key → MOVIE.MovieName — NOT NULL
  • ActorName (Field) — char(10)
  • AssociatedMovie (Field2) — char(30)
  • ActorBiographic (Field3) — char(60)

CUSTOMER (Untitled)

  • CustomerID (Key) — char(10) — Primary key — NOT NULL
  • Name (Field) — char(15)
  • Phone (Field2) — char(11)
  • Address (Field3) — char(30)
  • FirstRental (Field5) — date
  • RentHistory (Field4) — int
  • LateFee (Field6)

DIRECTOR (Untitled8)

  • DirectorID (Key) — char(10) — Primary key — NOT NULL
  • MovieName (Key2) — char(20) — Foreign key → MOVIE.MovieName — NOT NULL
  • DirectorName (Field) — char(20)
  • DirectorsFilm (Field2) — char(30)
  • DirectorBiographic (Field3) — char(60)

DVD (Untitled2)

  • DVDCode (Key) — char(10) — Primary key — NOT NULL
  • DateOfPurchase (Field2) — date
  • reservation (Field3) — char(2)
  • VideoQuantity (Field4) — int
  • MovieName (Key2) — char(20) — Foreign key → MOVIE.MovieName — NOT NULL

MOVIE (Untitled6)

  • MovieName (Key) — char(20) — Primary key — NOT NULL
  • YearMade (Field) — date

RENT (Untitled4)

  • RentCode (Key) — char(10) — Primary key — NOT NULL
  • RentDay (Field) — date
  • ReturnDay (Field2) — date
  • NumberOfRentals (Field3) — int
  • TimesOfRentals (Field4) — int
  • RentPrice (Field5) — int
  • CustomerID (Key2) — char(10) — Foreign key → CUSTOMER.CustomerID — NOT NULL
  • DVDCode (Key3) — char(10) — Foreign key → DVD.DVDCode — NOT NULL

RESERVATION (Untitled5)

  • ReservationOder (Key) — int — Primary key — NOT NULL
  • CustomerID (Key2) — char(10) — Foreign key → CUSTOMER.CustomerID — NOT NULL
  • OderOfReservation (Field) — int