Exercise6

Tables (7)

CUSTOM (CUSTOMER)

  • Key (customId) — Primary key — NOT NULL
  • Field (customAddress)
  • Field (customName)

Untitled (VIDEO)

  • Key (videoCode) — Primary key — NOT NULL
  • Field (purchaseDate)
  • Key (movieCode) — Foreign key → Untitled.Key — NOT NULL

Untitled (RENT)

  • Key (customId) — Foreign key → CUSTOM.Key — NOT NULL
  • Key (videoCode) — Foreign key → Untitled.Key — NOT NULL
  • Field (rentDate)

Untitled (MOVIE)

  • Key (movieCode) — Primary key — NOT NULL
  • Field (movieName)
  • Field (movieDate)
  • Key (producerId) — Foreign key → Untitled.Key — NOT NULL

Untitled (PRODUCER)

  • Key (producerId) — Primary key — NOT NULL
  • Field (producerName)

Untitled (ACTOR)

  • Key (actorId) — Primary key — NOT NULL
  • Field (actorName)
  • Key (movieCode) — Foreign key → Untitled.Key — NOT NULL

Untitled (ACTOR_LIST)

  • Key (movieCode) — Foreign key → Untitled.Key — NOT NULL
  • Key (actorId) — Foreign key → Untitled.Key — NOT NULL