EX4

Tables (4)

CUSTOMER (Untitled4)

  • customerId (Key) — Primary key — NOT NULL
  • name (Field)
  • phone (Field2)
  • address (Field3)

GENRE (Untitled2)

  • genreId (Key) — Primary key — NOT NULL
  • movieId (Key2) — Foreign key → MOVIE.movieId — NOT NULL
  • genreId (Key22) — Foreign key → MOVIE.genreId — NOT NULL
  • movieId (Key222) — Foreign key → MOVIE.movieId — NOT NULL
  • name (Field)
  • description (Field2)

MOVIE (Untitled)

  • movieId (Key) — Primary key — NOT NULL
  • genreId (Key2) — Foreign key → GENRE.genreId — NOT NULL
  • movieId (Key22) — Foreign key → GENRE.movieId — NOT NULL
  • title (Field)
  • description (Field2)

RENT (Untitled3)

  • rentId (Key) — Primary key — NOT NULL
  • customerId (Key2) — Foreign key → CUSTOMER.customerId — NOT NULL
  • rentDate (Field)
  • returnDate (Field2)
  • movieId (Key3) — Foreign key → MOVIE.movieId — NOT NULL
  • genreId (Key22) — Foreign key → MOVIE.genreId — NOT NULL
  • movieId (Key222) — Foreign key → MOVIE.movieId — NOT NULL