exercise4

Tables (6)

ACTOR (Untitled5)

  • aid (Key) — Primary key — NOT NULL

CUSTOMERS (Untitled)

  • cno (Key) — Primary key — NOT NULL
  • cname (Field)
  • caddress (Field2)

DIRECTOR (Untitled6)

  • did (Key) — Primary key — NOT NULL

DVD (Untitled2)

  • vid (Key) — Primary key — NOT NULL
  • mid (Key3) — Foreign key → MOVIE.mid — NOT NULL

MOVIE (Untitled4)

  • mid (Key) — Primary key — NOT NULL
  • mqty (Field)
  • mtitle (Field2)
  • myearmade (Field3)
  • acode (Key2) — Foreign key → ACTOR.aid — NOT NULL
  • dcode (Key3) — Foreign key → DIRECTOR.did — NOT NULL

RENTAL (Untitled3)

  • cno (Key) — Foreign key → CUSTOMERS.cno — NOT NULL
  • vid (Key2) — Foreign key → DVD.vid — NOT NULL
  • rtimes (Field2)
  • rdate (Field)