Exercise4

Tables (6)

Copy of Videocassette (Untitled3)

  • ID (Key) — char(10) — Primary key — NOT NULL
  • number of time of rent (Field) — char(10)
  • purchase date (Field2) — char(10)

Customer (Untitled)

  • NmberID (Key) — char(10 — Primary key — NOT NULL
  • Name (Field) — char(10)
  • Adress (Field2) — char(10)
  • Date (Field3) — date
  • Time (Field4) — char(10)
  • ID (Key2) — char(10) — Foreign key → Videocassette.ID — NOT NULL

Director (Untitled6)

  • ID (Key) — char(30) — Primary key — NOT NULL
  • biograpy (Field) — text

Movie Title (Untitled4)

  • ID (Key) — char(30) — Primary key — NOT NULL
  • title (Field) — char(30)
  • made year (Field2) — char(4)
  • actor (Field3) — char(30)
  • ID (Key2) — char(30) — Foreign key → actor.ID — NOT NULL
  • ID (Key3) — char(30) — Foreign key → Director.ID — NOT NULL

Videocassette (Untitled2)

  • ID (Key) — char(10) — Primary key — NOT NULL
  • purchase date (Field) — date
  • number of time of rent (Field2) — char(10)
  • Field3
  • ID (Key2) — char(10) — Foreign key → Copy of Videocassette.ID — NOT NULL
  • ID (Key3) — char(30) — Foreign key → Movie Title.ID — NOT NULL

actor (Untitled5)

  • ID (Key) — char(30) — Primary key — NOT NULL
  • biograpy (Field) — text