ERD_Exercise_4

Tables (6)

Untitled (customer)

  • Key (customerNo) — Char — Primary key — NOT NULL
  • Field (name) — Char
  • Field (address) — Text

Untitled (dvd)

  • Key (dvdCode) — Char — Primary key — NOT NULL
  • Field (dvdDate) — Date
  • Field (rentNo) — Int
  • Key (MoveNo) — Char — Foreign key → Untitled.Key — NOT NULL

Untitled (Rent)

  • Key (customerNo) — Char — Foreign key → Untitled.Key — NOT NULL
  • Key (dvdCode) — Char — Foreign key → Untitled.Key — NOT NULL
  • Field (rentDate) — Date

Untitled (move)

  • Key (MoveNo) — Char — Primary key — NOT NULL
  • Field (Title) — Char
  • Field (yearMade) — Date
  • Key (actorCode) — Char — Foreign key → Untitled.Key — NOT NULL
  • Key (directorCode) — Char — Foreign key → Untitled.Key — NOT NULL

Untitled (actor)

  • Key (actorCode) — Char — Primary key — NOT NULL
  • Field (Name) — Char

Untitled (director)

  • Key (directorCode) — Char — Primary key — NOT NULL
  • Field (name) — Char