exercise4

Tables (7)

ACTOR & ACTRESS (Untitled5)

  • code (Key2) — char(7) — Primary key — NOT NULL
  • movieIdentifier (Key) — char(6) — Foreign key → MOVIE.identifier — NOT NULL
  • biography (Field) — long text

CUSTOMER (Untitled)

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

DIRECTOR (Untitled6)

  • code (Key) — char(7) — Primary key — NOT NULL
  • biography (Field) — long text

DVD (Untitled2)

  • ID (Key) — char(8) — Primary key — NOT NULL
  • copyId (Field) — char(8)
  • dateOfPurchase (Field2) — date
  • timeOfRental (Field3) — int(3)
  • identifier (Key2) — char(6) — Foreign key → MOVIE.identifier — NOT NULL

MOVIE (Untitled3)

  • identifier (Key) — char(6) — Primary key — NOT NULL
  • title (Field) — char(30)
  • yearOfProduction (Field2) — int(4)

borrows (Untitled4)

  • customerID (Key) — char(10) — Foreign key → CUSTOMER.ID — NOT NULL
  • dvdID (Key2) — char(8) — Foreign key → DVD.ID — NOT NULL
  • dateOfRental (Field) — date
  • timeOfRental (Field2) — time

hasCodes (Untitled7)

  • identifier (Key) — char(6) — Foreign key → MOVIE.identifier — NOT NULL
  • Key (Key2) — Foreign key → DIRECTOR.code — NOT NULL