2023_webDB_week4_ex4

Tables (6)

Untitled (CUSTOMER)

  • Key (cusNo) — int — Primary key — NOT NULL
  • Field (cusName) — char(30)
  • Field (address) — char(70)

Untitled (DVD)

  • Key (dvdCode) — int — Primary key — NOT NULL
  • Field (copyCode) — char(13)
  • Field (purchaseDate) — date
  • Field (rentalNo) — int
  • Key (movieCode) — char(13) — Foreign key → Untitled.Key — NOT NULL

Untitled (RENTAL)

  • Key (rentalDate) — date — Primary key — NOT NULL
  • Field (rentalTime) — time
  • Key (cusNo) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (movieCode) — char(13) — Foreign key → Untitled.Key — NOT NULL

Untitled (MOVIE)

  • Key (movieCode) — char(13) — Primary key — NOT NULL
  • Field (title) — char(40)
  • Field (movieDate) — date
  • Key (actorCode) — char(13) — Foreign key → Untitled.Key — NOT NULL
  • Key (directorCode) — char(13) — Foreign key → Untitled.Key — NOT NULL

Untitled (ACTOR)

  • Key (actorCode) — char(13) — Primary key — NOT NULL
  • Field (actorName) — char(30)
  • Field (biography) — char(100)

Untitled (DIRECTOR)

  • Key (directorCode) — char(13) — Primary key — NOT NULL
  • Field (directorName) — char(30)
  • Field (biography) — char(100)