ERD EXCERCISE 4

Tables (9)

Untitled (CUSTOMER)

  • Key (custNO) — integer — Primary key — NOT NULL
  • Field

Untitled (dvd)

  • Key (dvdid) — integer — Primary key — NOT NULL
  • Field
  • Key (id2) — in — Foreign key → Untitled.Key — NOT NULL

Untitled (dvd-copy)

  • Key (id) — int — Primary key — NOT NULL
  • Field
  • Key (dvdid) — integer — Foreign key → Untitled.Key — NOT NULL

Untitled (movie title)

  • Key (id) — in — Primary key — NOT NULL
  • Field

Untitled (actor)

  • Key (id) — int — Primary key — NOT NULL
  • Field

Untitled (diecter)

  • Key (id) — int — Primary key — NOT NULL
  • Field

Untitled (customer rental)

  • Key (custNO) — integer — Foreign key → Untitled.Key — NOT NULL
  • Key (id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (title-actor)

  • Key (id) — in — Foreign key → Untitled.Key — NOT NULL
  • Key (id2) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (title-director)

  • Key (id) — in — Foreign key → Untitled.Key — NOT NULL
  • Key (id2) — int — Foreign key → Untitled.Key — NOT NULL