연습 문제 4

테이블 (6)

Untitled (Customer ID)

  • Key (name) — int — 기본 키 — NOT NULL
  • Field (address) — int

Untitled (DVD)

  • Key (Movie Title) — chart(50) — 기본 키 — NOT NULL
  • Field (Purchase Date) — int
  • Field (Rental Count) — int
  • Key (Movie Title2) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Movie ID)

  • Key (Movie Title) — char(20) — 기본 키 — NOT NULL
  • Field (Release Year) — int
  • Key (Actor Name) — int — 외래 키 → Untitled2.Key — NOT NULL
  • Key (Director Name) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Director)

  • Key (Director Name) — int — 기본 키 — NOT NULL
  • Field (Director Biography) — int

Untitled (Rental)

  • Key (Rental DateTime) — 기본 키 — NOT NULL
  • Field (DVD Code) — int
  • Field (Customer ID) — int
  • Key (Movie Title) — chart(50) — 외래 키 → Untitled.Key — NOT NULL
  • Key (name) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled2 (Actor)

  • Key (Actor Name) — int — 기본 키 — NOT NULL
  • Field (Actor Biography) — int