중간고사

테이블 (4)

Untitled (BOOK)

  • Key (ISBN) — char(13) — 기본 키 — NOT NULL
  • Field (keyword) — char(50) — 외래 키 → Untitled4.Field
  • Field (bookName) — char(30)
  • Field (physicalDescription) — char(50)
  • Field (publishDate) — gYear
  • Field (KDC) — float
  • Key (authorID) — char(11) — 외래 키 → Untitled2.Key — NOT NULL
  • Key (publisherID) — char(13) — 외래 키 → Untitled3.Key — NOT NULL

Untitled2 (AUTHOR)

  • Key (authorID) — char(11) — 기본 키 — NOT NULL
  • Field (authorName) — char(20)
  • Field (address) — char(50)
  • Field (phone) — char(11)
  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (keyword) — char(50) — 외래 키 → Untitled.Field

Untitled3 (PUBLISHER)

  • Key (publisherID) — char(13) — 기본 키 — NOT NULL
  • Field (publisherName) — char(20)
  • Field (address) — char(50)
  • Field (phone) — char(11)
  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Field (keyword) — char(50) — 외래 키 → Untitled.Field
  • Field (memo) — char(100)

Untitled4 (SUBJECT)

  • Field (keyword) — char(50) — 기본 키
  • Field (relatedPerson) — char(20)
  • Field (relatedEvent) — char(20)
  • Field (description) — char(100)
  • Field (memo) — char(100)