Exercise 4 _ DB

Tables (9)

Untitled (CLIENT)

  • Key (ClientId) — char — Primary key — NOT NULL
  • Field (name)
  • Field (address)

Untitled (RENTAL)

  • Key (rentalId) — int — Primary key — NOT NULL
  • Field (dateAndTimeRented) — char
  • Key (ClientId) — char — Foreign key → Untitled.Key — NOT NULL
  • Key (dvdCodeId) — char — Foreign key → Untitled2.Key — NOT NULL

Untitled (PERSON)

  • Key (personId) — Primary key — NOT NULL
  • Field (biography)
  • Field (name)
  • Field (birthDate)

Untitled (MOVIE_DIRECTOR)

  • Key (personId) — Foreign key → Untitled2.Key — NOT NULL
  • Key (movieId) — char — Foreign key → Untitled3.Key — NOT NULL

Untitled (MOVIE_ACTOR)

  • Key (personId) — Foreign key → Untitled3.Key — NOT NULL
  • Key (movieId) — char — Foreign key → Untitled3.Key — NOT NULL

Untitled2 (DVD)

  • Key (dvdCodeId) — char — Primary key — NOT NULL
  • Field (dateOdPurchase) — date
  • Field (rentalCount) — int
  • Key (movieId) — char — Foreign key → Untitled3.Key — NOT NULL

Untitled2 (DIRECTOR)

  • Key (personId) — Foreign key → Untitled.Key — NOT NULL
  • Field (role)

Untitled3 (MOVIE)

  • Key (movieId) — char — Primary key — NOT NULL
  • Field (title) — char
  • Field (yearMade) — date
  • Field (description) — texta
  • Field (award)

Untitled3 (ACTOR)

  • Key (personId) — Foreign key → Untitled.Key — NOT NULL
  • Field (role)