ERD exercise 4

Tables (8)

Untitled (CUSTOMER)

  • Key (cusID) — char(15) — Primary key — NOT NULL
  • Field (cusName) — char(20)
  • Field (address) — char(70)

Untitled (VIDEO)

  • Key (videoID) — char(15) — Primary key — NOT NULL
  • Field (copyID) — char(15)
  • Field (purchaseDate) — date
  • Field (timesRanted) — char(20)
  • Key (movieID) — char(15) — Foreign key → Untitled.Key — NOT NULL

Untitled (MOVIE)

  • Key (movieID) — char(15) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field (yearMade) — int(4)

Untitled (ACTOR)

  • Key (actorID) — char(15) — Primary key — NOT NULL
  • Field (actorName) — char(20)
  • Field (actorBiography) — text

Untitled (DIRECTOR)

  • Key (dirID) — char(15) — Primary key — NOT NULL
  • Field (dirName) — char(20)
  • Field (dirBiography) — text

Untitled (RENTAL)

  • Key (rentalID) — char(15) — Primary key — NOT NULL
  • Field (rentalDate) — date
  • Field (rentalTime)
  • Key (cusID) — char(15) — Foreign key → Untitled.Key — NOT NULL
  • Key (videoID) — char(15) — Foreign key → Untitled.Key — NOT NULL

Untitled (ACTOR_MOVIE)

  • Key (actorID) — char(15) — Foreign key → Untitled.Key — NOT NULL
  • Key (movieID) — char(15) — Foreign key → Untitled.Key — NOT NULL

Untitled (DIRECTOR_MOVIE)

  • Key (dirID) — char(15) — Foreign key → Untitled.Key — NOT NULL
  • Key (movieID) — char(15) — Foreign key → Untitled.Key — NOT NULL