중간고사

테이블 (3)

Untitled (BOOK INFORMATION)

  • Field (ISBN) — char(30) — 기본 키
  • Key (Aname) — char(50) — 외래 키 → Untitled.Key — NOT NULL
  • Field (publication date) — date
  • Key (book name) — char(30) — NOT NULL
  • Field (author) — char(50)
  • Field (press) — char(50)
  • Field (category number) — char(50)
  • Field (ket word) — char(500)

Untitled (AUTHOR)

  • Key (Aname) — char(50) — 기본 키 — NOT NULL
  • Field (id number) — char(20)
  • Field (address) — char(50)

Untitled2 (PRESS)

  • Key (ID) — char(10) — 기본 키 — NOT NULL
  • Field (ISBN) — char(30) — 외래 키 → Untitled.Field
  • Key (Aname) — 외래 키 → Untitled.Key — NOT NULL
  • Field (Pname) — char(50)
  • Field (address) — char(100)