EXERCISE 5

Tables (8)

ACTOR (Untitled8)

  • actorId (Key) — CHAR(30) — Primary key — NOT NULL
  • fname (Field) — CHAR(30)
  • mname (Field5) — CHAR(30)
  • lname (Field2) — CHAR(30)
  • actorSsn (Field3) — CHAR(30)
  • biography (Field4) — CHAR(30)

BORROW (Untitled2)

  • rentCode (Key3) — CHAR(10) — Primary key — NOT NULL
  • customerId (Key) — CHAR(30) — Foreign key → CUSTOMER.customerId — NOT NULL
  • dvdId (Key2) — CHAR(30) — Foreign key → DVD.dvdId — NOT NULL
  • date (Field2) — date
  • time (Field) — time
  • returned (Field3) — int(1)

CUSTOMER (Untitled)

  • customerId (Key) — CHAR(30) — Primary key — NOT NULL
  • ssn (Field) — CHAR(30)
  • fname (Field2) — CHAR(20)
  • lname (Field5) — CHAR(20)
  • gender (Field3) — CHAR(10)
  • address (Field4) — CHAR(30)
  • phone (Field6) — CHAR(20)
  • bday (Field7) — date
  • age (Field8) — CHAR(10)

DIRECTOR (Untitled9)

  • directorId (Key) — CHAR(30) — Primary key — NOT NULL
  • fname (Field) — CHAR(30)
  • mname (Field5) — CHAR(10)
  • lname (Field2) — CHAR(30)
  • directorSsn (Field3) — CHAR(30)
  • biography (Field4) — CHAR(40)

DVD (Untitled3)

  • dvdId (Key) — CHAR(30) — Primary key — NOT NULL
  • purchaseDate (Field) — date
  • borrowedNum (Field2) — int(4)
  • movieId (Key2) — CHAR(30) — Foreign key → MOVIE.movieId — NOT NULL

MOVIE (Untitled5)

  • movieId (Key) — CHAR(30) — Primary key — NOT NULL
  • title (Field) — CHAR(30)
  • releaseDate (Field3) — date
  • genre (Field4) — CHAR(30)
  • award (Field2) — CHAR(30)

MOVIE_ACTOR (Untitled7)

  • movieId (Key) — CHAR(30) — Foreign key → MOVIE.movieId — NOT NULL
  • actorId (Key2) — CHAR(30) — Foreign key → ACTOR.actorId — NOT NULL

MOVIE_DIRECTOR (Untitled6)

  • movieId (Key) — CHAR(30) — Foreign key → MOVIE.movieId — NOT NULL
  • directorId (Key2) — CHAR(30) — Foreign key → DIRECTOR.directorId — NOT NULL
  • role (Field) — CHAR(30)