0811ex04

Tables (7)

ACTOR (Untitled4)

  • acode (Key) — CHAR(30) — Primary key — NOT NULL
  • aname (Field) — CHAR(30)
  • ayearborn (Field2) — INT(8)

BIOGRAPHY (Untitled6)

  • dcode (Key) — CHAR(30) — Foreign key → DIRECTOR.dcode — NOT NULL
  • acode (Key2) — CHAR(30) — Foreign key → ACTOR.acode — NOT NULL
  • mtitle (Key3) — CHAR(30) — Foreign key → MOVIE.mtitle — NOT NULL

CUSTOMER (Untitled)

  • ccode (Key) — CHAR(30) — Primary key — NOT NULL
  • cname (Field) — CHAR(30)
  • caddress (Field2) — CHAR(50)

DIRECTOR (Untitled5)

  • dcode (Key) — CHAR(30) — Primary key — NOT NULL
  • dname (Field) — CHAR(30)
  • dyearborn (Field2) — INT(8)

MOVIE (Untitled7)

  • mtitle (Key) — CHAR(30) — Primary key — NOT NULL
  • myearmade (Field) — INT(4)
  • acode (Key2) — CHAR(30) — Foreign key → ACTOR.acode — NOT NULL
  • dcode (Key3) — CHAR(30) — Foreign key → DIRECTOR.dcode — NOT NULL

RENTALRECORD (Untitled3)

  • ccode (Key) — CHAR(30) — Foreign key → CUSTOMER.ccode — NOT NULL
  • vcode (Key2) — CHAR(30) — Foreign key → VIDEO.vcode — NOT NULL
  • rdate (Field) — INT(8)
  • rtime (Field2) — INT(4)

VIDEO (Untitled2)

  • vcode (Key) — CHAR(30) — Primary key — NOT NULL
  • vdateofpurchase (Field3) — INT(8)
  • mtitle (Key4) — CHAR(30) — Foreign key → MOVIE.mtitle — NOT NULL