exercise4

Tables (8)

ACTOR (Untitled4)

  • actorCODE (Key) — char(10) — Primary key — NOT NULL
  • biography (Field) — text

CUSTOMER (Untitled)

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

CopyDvd (Untitled7)

  • copyID (Key) — char(10) — Primary key — NOT NULL

DIRECTOR (Untitled5)

  • CODE (Key) — Primary key — NOT NULL
  • biography (Field)

DVD (Untitled3)

  • dvdCODE (Key) — char(10) — Primary key — NOT NULL
  • copyID (Key2) — char(10) — Foreign key → CopyDvd.copyID — NOT NULL
  • purchaseDate (Field) — date
  • time (Field2) — int(2)

MOVIE (Untitled8)

  • MOVIEID (Key) — Primary key — NOT NULL
  • CODE (Key2) — Foreign key → DIRECTOR.CODE — NOT NULL
  • actorCODE (Key3) — char(10) — Foreign key → ACTOR.actorCODE — NOT NULL

STORE (Untitled2)

  • MOVIEID (Key) — Foreign key → MOVIE.MOVIEID — NOT NULL
  • CODE (Key23) — Foreign key → MOVIE.CODE — NOT NULL
  • actorCODE (Key32) — char(10) — Foreign key → MOVIE.actorCODE — NOT NULL
  • time (Field) — int(2)
  • lentDate (Field2) — date
  • Field3
  • customerID (Key2) — char(10) — Foreign key → CUSTOMER.customerID — NOT NULL
  • dvdCODE (Key3) — char(10) — Foreign key → DVD.dvdCODE — NOT NULL
  • copyID (Key22) — char(10) — Foreign key → DVD.copyID — NOT NULL

Untitled6