ERD exercise 5(20200928)

Tables (8)

ACTOR (Untitled4)

  • actId (Key) — CHAR(10) — Primary key — NOT NULL
  • actName (Field) — CHAR(20)
  • actSsn (Field2) — CHAR(20)
  • biography (Field3) — longtext

APPEAR (Untitled5)

  • actId (Key) — CHAR(10) — Foreign key → ACTOR.actId — NOT NULL
  • movId (Key2) — CHAR(10) — Foreign key → MOVIE.movId — NOT NULL
  • role (Field) — CHAR(10)

CLIENT (Untitled)

  • clId (Key) — CHAR(10) — Primary key — NOT NULL
  • clName (Field) — CHAR(20)
  • clSsn (Field2) — CHAR(20)
  • clAddress (Field3) — CHAR(50)
  • phone (Field4) — CHAR(20)
  • email (Field5) — CHAR(30)

CONTRACT (Untitled2)

  • conId (Key) — CHAR(10) — Primary key — NOT NULL
  • conDate (Field) — date
  • conTime (Field2) — time
  • price (Field3) — int(10)
  • dueDate (Field4) — date
  • dvdId (Key2) — CHAR(10) — Foreign key → DVD.dvdId — NOT NULL
  • clId (Key3) — CHAR(10) — Foreign key → CLIENT.clId — NOT NULL

DIRECTOR (Untitled7)

  • dirId (Key) — CHAR(10) — Primary key — NOT NULL
  • dirName (Field) — CHAR(20)
  • dirSsn (Field2) — CHAR(20)
  • biography (Field3) — longlext

DVD (Untitled3)

  • dvdId (Key) — CHAR(10) — Primary key — NOT NULL
  • dvdName (Field) — CHAR(20)
  • purchaseDate (Field2) — date
  • numOfContract (Field3) — int(10)
  • length (Field4) — int(10)
  • price (Field5) — int(10)
  • description (Field6) — CHAR(50)
  • movId (Key2) — CHAR(10) — Foreign key → MOVIE.movId — NOT NULL

MOVIE (Untitled6)

  • movId (Key) — CHAR(10) — Primary key — NOT NULL
  • title (Field) — CHAR(20)
  • subtitle (Field2) — CHAR(20)
  • productionYear (Field3) — date

PARTICIPATE (Untitled8)

  • dirId (Key) — CHAR(10) — Foreign key → DIRECTOR.dirId — NOT NULL
  • movId (Key2) — CHAR(10) — Foreign key → MOVIE.movId — NOT NULL
  • role (Field) — CHAR(10)