중간시험

테이블 (4)

Untitled (BOOK)

  • Key (ISBN) — int — 기본 키 — NOT NULL
  • Key (KDC) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (Resident registration number) — 외래 키 → Untitled.Key — NOT NULL
  • Field (publishing date)

Untitled (PUBLISHER)

  • Key (ID) — int — 기본 키 — NOT NULL
  • Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (KDC) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (Resident registration number) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name)
  • Field (address)

Untitled (WRITER)

  • Key (Resident registration number) — 기본 키 — NOT NULL
  • Field (name) — char
  • Field (address)
  • Field (co-author) — int

Untitled (KEYWORK)

  • Key (KDC) — char(20) — 기본 키 — NOT NULL
  • Field (person)
  • Field (incident)