ERD Exercise 4

Tables (7)

ACTOR (Untitled5)

  • actorCode (Key) — char(10) — Primary key — NOT NULL
  • biography (Field) — char(100)

COPY (Untitled7)

  • copyCodeNumber (Key) — char(10) — Primary key — NOT NULL
  • CodeNunmer (Key2) — char(10) — Foreign key → VIDEOCASSETTE.CodeNunmer — NOT NULL
  • movietitleNumber (Key22) — char(10) — Foreign key → VIDEOCASSETTE.movietitleNumber — NOT NULL
  • actorCode (Key3) — char(10) — Foreign key → VIDEOCASSETTE.actorCode — NOT NULL
  • directorCode (Key4) — char(10) — Foreign key → VIDEOCASSETTE.directorCode — NOT NULL
  • copyName (Field) — char(10)

CUSTOMER (Untitled)

  • CustomerNumber (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(40)
  • firstRentalDate (Field3) — date

DIRECTOR (Untitled6)

  • directorCode (Key) — char(10) — Primary key — NOT NULL
  • biography (Field) — char(100)

MOVIETITLE (Untitled4)

  • movietitleNumber (Key) — char(10) — Primary key — NOT NULL
  • actorCode (Key3) — char(10) — Foreign key → ACTOR.actorCode — NOT NULL
  • directorCode (Key4) — char(10) — Foreign key → DIRECTOR.directorCode — NOT NULL
  • titleName (Field) — char(20)
  • yearMade (Field2) — date
  • CodeNunmer (Key2) — char(10) — Foreign key → VIDEOCASSETTE.CodeNunmer — NOT NULL

RENT (Untitled3)

  • rentCodeNunmer (Key2) — char(10) — Foreign key → VIDEOCASSETTE.CodeNunmer — NOT NULL
  • movietitleNumber (Key23) — char(10) — Foreign key → VIDEOCASSETTE.movietitleNumber — NOT NULL
  • actorCode (Key3) — char(10) — Foreign key → VIDEOCASSETTE.actorCode — NOT NULL
  • directorCode (Key4) — char(10) — Foreign key → VIDEOCASSETTE.directorCode — NOT NULL
  • rentDate (Field) — date
  • CustomerNumber (Key) — char(10) — Foreign key → CUSTOMER.CustomerNumber — NOT NULL
  • CodeNunmer (Key22) — char(10) — Foreign key — NOT NULL

VIDEOCASSETTE (Untitled2)

  • CodeNunmer (Key) — char(10) — Primary key — NOT NULL
  • movietitleNumber (Key2) — char(10) — Foreign key → MOVIETITLE.movietitleNumber — NOT NULL
  • actorCode (Key3) — char(10) — Foreign key → MOVIETITLE.actorCode — NOT NULL
  • directorCode (Key4) — char(10) — Foreign key → MOVIETITLE.directorCode — NOT NULL
  • PurchaseNumber (Field2) — date
  • RentTimeNumber (Field3) — char(10)