데이터베이스 중간고사

테이블 (8)

Untitled (BOOK)

  • Key (ISBN) — integer — 기본 키 — NOT NULL
  • Field (title) — char(20)
  • Field (publisher date) — char(20)
  • Field (publisher) — char(30)
  • Field (price) — integer
  • Key (publisherID) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (AUTHORS)

  • Key — integer — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(20)
  • Field (phone) — char(20)

Untitled (PUBLISHER)

  • Key (publisherID) — char(20) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(30)

Untitled (BOOK_PRINTER)

  • Key (prinID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ISBN) — integer — 외래 키 → Untitled.Key — NOT NULL

Untitled (PRINTER)

  • Key (prinID) — char(20) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (adrress) — char(20)
  • Field (phone) — char(20)

Untitled (PRINTER_CONTRACT)

  • Key (publisherID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (prinID) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (CONTRACT)

  • Key — 기본 키 — NOT NULL

Untitled (BOOK_AUTHORS)

  • Key (ISBN) — integer — 외래 키 → Untitled.Key — NOT NULL
  • Key — integer — 외래 키 → Untitled.Key — NOT NULL