DVD Store

Tables (9)

Cast (Untitled6)

  • castID (Key) — int — Primary key — NOT NULL
  • biography (Field) — char(200)

Copy Of DVD (CopyOfUntitled2)

  • dvdID (Key2) — int — Foreign key → DVD.dvdID — NOT NULL

Customer (Untitled)

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

DVD (Untitled2)

  • dvdID (Key) — int — Primary key — NOT NULL
  • movieID (Field) — int
  • boughtDate (Field2) — date
  • amountRental (Field3) — int

Director (CopyOfUntitled6)

  • directorID (Key) — int — Primary key — NOT NULL
  • biography (Field) — char(200)

Movie (Untitled3)

  • moiveID (Key) — int — Primary key — NOT NULL
  • dvdID (Key2) — int — Foreign key → DVD.dvdID — NOT NULL
  • title (Field2) — char(10)
  • published (Field) — int
  • casts (Field3) — int
  • directors (Field4) — int

MovieCast (Untitled4)

  • castID (Key) — int — Foreign key → Cast.castID — NOT NULL
  • moiveID (Key2) — int — Foreign key → Movie.moiveID — NOT NULL
  • dvdID (Key22) — int — Foreign key → Movie.dvdID — NOT NULL

MovieDirector (CopyOfUntitled4)

  • directorID (Key3) — int — Foreign key → Director.directorID — NOT NULL
  • moiveID (Key) — int — Foreign key → Movie.moiveID — NOT NULL
  • dvdID (Key2) — int — Foreign key → Movie.dvdID — NOT NULL

Rental (Untitled5)

  • rentID (Key3) — int — Primary key — NOT NULL
  • customerID (Key) — int — Foreign key → Customer.customerID — NOT NULL
  • dvdID (Key2) — int — Foreign key → DVD.dvdID — NOT NULL
  • rentalDate (Field) — date
  • time (Field2) — date