진기 중간시험

테이블 (4)

Untitled (book information)

  • Key (ISBN) — int — 기본 키 — NOT NULL
  • Field (signature) — char(30)
  • Field2 (publication data) — data
  • Field (writer) — char(30)

Untitled (publisher)

  • Key (ID) — int — 기본 키 — NOT NULL
  • Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field2 (name) — char(30)
  • Field (address) — char(20)

Untitled (writer)

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

Untitled (topic)

  • Key (KDC) — int — 기본 키 — NOT NULL
  • Field (key word) — char(1)
  • Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL