ex4

Tables (9)

Actor (Untitled5)

  • aCode (Key) — char(14) — Primary key — NOT NULL
  • aBiography (Field) — char(50)

Customer (Untitled)

  • cId (Key) — char(14) — Primary key — NOT NULL
  • cName (Field) — char(10)
  • cAdress (Field2) — char(40)

Director (CopyOfUntitled5)

  • DirectorCode (Key) — char(14) — Primary key — NOT NULL
  • DirectorBiography (Field) — char(50)

Dvd (Untitled2)

  • dCode (Key) — char(14) — Primary key — NOT NULL
  • mCode (Key2) — char(14) — Foreign key → Movie.mCode — NOT NULL
  • dPurchaseDate (Field2) — date
  • dRentalquantity (Field3) — integer

DvdRental (Untitled3)

  • rentalCode (Key3) — Primary key — NOT NULL
  • dCode (Key2) — char(14) — Foreign key → Dvd.dCode — NOT NULL
  • mCode (Key22) — char(14) — Foreign key → Dvd.mCode — NOT NULL
  • rentalDate (Field) — date
  • rentalTime (Field2) — AA
  • cId (Key) — char(14) — Foreign key → Customer.cId — NOT NULL

GENRE (Untitled7)

  • genreId (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)

Movie (Untitled4)

  • mCode (Key) — char(14) — Primary key — NOT NULL
  • mTitle (Field) — char(30)
  • mYear (Field2) — integer

MovieInformation (Untitled6)

  • Infocode (Key4) — Primary key — NOT NULL
  • DirectorCode (Key2) — char(14) — Foreign key → Director.DirectorCode — NOT NULL
  • aCode (Key3) — char(14) — Foreign key → Actor.aCode — NOT NULL
  • mCode (Key) — char(14) — Foreign key → Movie.mCode — NOT NULL

movie Genre (Untitled8)

  • mCode (Key) — char(14) — Foreign key → Movie.mCode — NOT NULL
  • genreId (Key2) — Foreign key → GENRE.genreId — NOT NULL