exercise_4

Tables (9)

ACTOR (Untitled6)

  • actorCode (Key) — char(15) — Primary key — NOT NULL
  • actorName (Field) — char(20)

CUSTOMER (Untitled)

  • customerID (Key) — char(15) — Primary key — NOT NULL
  • customerName (Field) — char(20)
  • customerAddress (Field2) — text

DIRECTOR (Untitled7)

  • directorCode (Key) — char(15) — Primary key — NOT NULL
  • directorName (Field) — char(20)

DVD (Untitled2)

  • dvdCode (Key) — char(15) — Primary key — NOT NULL
  • movieCode (Key3) — char(10) — Foreign key → MOVIE.movieCode — NOT NULL
  • dvdRentedCount (Field) — int(5)
  • dvdPurchasedDate (Field2) — date
  • dvdDescription (Field3) — text
  • dvdGenre (Field4) — char(30)
  • originalDvdCode (Key2) — char(15) — Foreign key → DVD.dvdCode — NOT NULL
  • movieCode (Key32) — char(10) — Foreign key → DVD.movieCode — NOT NULL

GENRE (Untitled9)

  • genreID (Key) — char(20) — Primary key — NOT NULL
  • genreName (Field) — char(20)
  • genreDescription (Field2) — text

IS_RENTED (Untitled3)

  • customerID (Key) — char(15) — Foreign key → CUSTOMER.customerID — NOT NULL
  • dvdCode (Key2) — char(15) — Foreign key → DVD.dvdCode — NOT NULL
  • movieCode (Key3) — char(10) — Foreign key → DVD.movieCode — NOT NULL
  • rentedDate (Field) — date
  • rentedTime (Field2) — float

MOVIE (Untitled4)

  • movieCode (Key) — char(10) — Primary key — NOT NULL
  • movieName (Field) — char(20)
  • movieCreatedYear (Field2) — int(4)
  • movieDescription (Field3) — text

MOVIE_GENRE (Untitled5)

  • movieCode (Key) — char(10) — Foreign key → MOVIE.movieCode — NOT NULL
  • genreID (Key2) — char(20) — Foreign key → GENRE.genreID — NOT NULL

PARTICIPATED_IN (Untitled8)

  • movieCode (Key) — char(10) — Foreign key → MOVIE.movieCode — NOT NULL
  • actorCode (Key2) — char(15) — Foreign key → ACTOR.actorCode — NOT NULL
  • directorCode (Key3) — char(15) — Foreign key → DIRECTOR.directorCode — NOT NULL