중간고사

테이블 (5)

Untitled (publishing house)

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

Untitled (book)

  • Key (Book name) — 기본 키 — NOT NULL
  • Key (price) — 외래 키 → Untitled.Key — NOT NULL
  • Field (time of publication)
  • Key (Publisher name) — 외래 키 → Untitled.Key — NOT NULL
  • Key (Author's name) — 외래 키 → Untitled.Key — NOT NULL
  • Key (KDC) — 외래 키 → Untitled.Key — NOT NULL
  • Key (Tyoe) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Author)

  • Key (Author's name) — 기본 키 — NOT NULL
  • Field (address)
  • Field (resident registration number)

Untitled (book sorting)

  • Key (KDC) — 기본 키 — NOT NULL
  • Key (Tyoe) — 기본 키 — NOT NULL
  • Field (Keyword)

Untitled (book price)

  • Key (price) — 기본 키 — NOT NULL