ERD Exercise 4

Tables (10)

ACTOR (Untitled7)

  • actorSSN (Key) — char(10) — Primary key — NOT NULL
  • biography (Field) — char(40)

CUSTOMER (Untitled)

  • customerID (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(30)

CUSTOMER_DVD (Untitled9)

  • customerID (Key) — char(10) — Foreign key → CUSTOMER.customerID — NOT NULL
  • dvdCode (Key2) — char(10) — Foreign key → DVD.dvdCode — NOT NULL

DIRECTOR (Untitled6)

  • directorSSN (Key) — char(10) — Primary key — NOT NULL
  • biography (Field) — char(40)
  • movieSSN (Key2) — char(10) — Foreign key → MOVIE.movieSSN — NOT NULL

DVD (Untitled2)

  • dvdCode (Key) — char(10) — Primary key — NOT NULL
  • buyDate (Field) — char(8)
  • lendCount (Field2) — integer
  • lendDate (Key2) — char(10) — Foreign key → STORE.lendDate — NOT NULL

DVD COPY (Untitled3)

  • copyCode (Key) — char(10) — Primary key — NOT NULL
  • dvdCode (Key2) — char(10) — Foreign key → DVD.dvdCode — NOT NULL

DVD_MOVIE (Untitled10)

  • dvdCode (Key) — char(10) — Foreign key → DVD.dvdCode — NOT NULL
  • movieSSN (Key2) — char(10) — Foreign key → MOVIE.movieSSN — NOT NULL

MOVIE (Untitled5)

  • movieSSN (Key) — char(10) — Primary key — NOT NULL
  • title (Field) — char(20)
  • whenYear (Field2) — char(4)

MOVIE_ACTOR (Untitled8)

  • movieSSN (Key) — char(10) — Foreign key → MOVIE.movieSSN — NOT NULL
  • actorSSN (Key2) — char(10) — Foreign key → ACTOR.actorSSN — NOT NULL

STORE (Untitled4)

  • lendDate (Key) — char(10) — Primary key — NOT NULL
  • lendTime (Field) — char(10)