ERD exercise4_DVD

Tables (8)

Untitled (Customer)

  • Key (cusCode) — CHAR(10) — Primary key — NOT NULL
  • Field (cusName) — CHAR(10)
  • Field (cusAddress) — CHAR(20)

Untitled (DVD)

  • Key (DVDCode) — CHAR(10) — Primary key — NOT NULL
  • Field (purchaseDate) — DATE
  • Field (rentedTime) — INT
  • Key (DVDMovieCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (RENTAL)

  • Key (rentalCode) — CHAR(10) — Primary key — NOT NULL
  • Field (rentalDatetime) — DATE
  • Key (rentalcusCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (rentalDVDCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (MOVIE)

  • Key (movieCode) — CHAR(10) — Primary key — NOT NULL
  • Field (movieTitle) — CHAR(10)
  • Field (Year) — DATE

Untitled (ACTOR)

  • Key (actorCode) — CHAR(10) — Primary key — NOT NULL
  • Field (actorName) — CHAR(10)
  • Field (actorBiography) — CHAR(30)

Untitled (DIRECTOR)

  • Key (directorCode) — CHAR(10) — Primary key — NOT NULL
  • Field (directorName) — CHAR(10)
  • Field (directorBiography) — CHAR(30)

Untitled (STARRING)

  • Key (movieCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (actorCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (PRODUCE)

  • Key (movieCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (directorCode) — CHAR(10) — Foreign key → Untitled.Key — NOT NULL