ERD Exercise 4

Tables (12)

Copy Of Untitled (DVDITEM)

  • Key (itemID) — char(10) — Primary key — NOT NULL
  • Field (subject) — date
  • Field (price) — imt(10)
  • Field (statusLevel) — char(1)
  • Key (movieID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Copy Of Untitled2 (GENRE)

  • Key (genreID) — int(5) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (description) — LONGTEXT

Copy Of Untitled3 (MOVIE_AWARD)

  • Key (awardID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (description) — text
  • Key (movieID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (CLIENT)

  • Key (clientID) — char(10) — Primary key — NOT NULL
  • Field (clientName) — char(10)
  • Field (adress) — char(30)
  • Field (phone) — char(13)
  • Field (email) — char(30)

Untitled (MOVIE)

  • Key (movieID) — char(10) — Primary key — NOT NULL
  • Field (title) — char(30)
  • Field (pubYear) — imt(4)
  • Field (pubmonth) — int(2)
  • Field (description) — text
  • Field (award) — text

Untitled (CASTING)

  • Key (movieID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (roleID) — int(3) — Foreign key → Untitled2.Key — NOT NULL
  • Field (description) — LONGTEXT
  • Key (actorID) — int(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (RENT)

  • Key (rentID) — char(10) — Primary key — NOT NULL
  • Key (itemID) — char(10) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (tentdate) — date
  • Field (returndate) — date
  • Key (clientID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (ACTOR)

  • Key (actorID) — int(10) — Primary key — NOT NULL
  • Field (Name) — char(30)
  • Field (minit) — char(1)
  • Field (lname) — char(30)
  • Field (description) — LONGTEXT

Untitled (MOVIE_GENRE)

  • Key (movieID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (genreID) — int(5) — Foreign key → Copy Of Untitled2.Key — NOT NULL

Untitled (AWARD)

  • Key (awardID) — char(10) — Primary key — NOT NULL
  • Field (awardName) — char(30)
  • Field (year) — int(4)

Untitled (ACTOR_AWARD)

  • Key (actorID) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (awardID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (description) — text

Untitled2 (ROLE)

  • Key (roleID) — int(3) — Primary key — NOT NULL
  • Field (roletitle) — char(30)
  • Field (description) — LONGTEXT