hw

Tables (9)

ACTOR (Untitled5)

  • actID (Key) — int — Primary key — NOT NULL
  • actname (Field)

ACTOR-DIRECTOR LINK (Untitled7)

  • actID (Key) — int — Foreign key → ACTOR.actID — NOT NULL
  • directorID (Key2) — int — Foreign key → DIRECTOR.directorID — NOT NULL

CUSTOMER (Untitled)

  • cusID (Key) — int — Primary key — NOT NULL
  • cusName (Field) — char(30)
  • cusAdress (Field2) — char(50)

DIRECTOR (Untitled6)

  • directorID (Key) — int — Primary key — NOT NULL
  • directorName (Field) — char(30)

MOVIE (Untitled4)

  • moID (Key) — int — Primary key — NOT NULL
  • moTitle (Field) — char(30)
  • date (Field2)

MOVIE-ACTOR LINK

  • moID (Key) — int — Foreign key → MOVIE.moID — NOT NULL
  • actID (Key2) — int — Foreign key → ACTOR.actID — NOT NULL

MOVIE-DIRECTOR LINK (Untitled8)

  • moID (Key) — int — Foreign key → MOVIE.moID — NOT NULL
  • directorID (Key2) — int — Foreign key → DIRECTOR.directorID — NOT NULL

RENTAL TRANSATION (Untitled3)

  • Transaction ID (Key) — int — Primary key — NOT NULL
  • date (Field) — int
  • moID (Key2) — int — Foreign key → MOVIE.moID — NOT NULL
  • cusID (Key3) — int — Foreign key → CUSTOMER.cusID — NOT NULL

VEDIOCASSETTE (Untitled2)

  • veID (Key) — int — Primary key — NOT NULL
  • Purchase Date (Field) — int
  • Rental Count (Field2) — int
  • cusID (Key2) — int — Foreign key → CUSTOMER.cusID — NOT NULL
  • Field3