중간고사

테이블 (6)

Book_Subject (Untitled2)

  • Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL
  • subID (Key) — int — 외래 키 → Subject.subID — NOT NULL

Subject (Untitled)

  • subID (Key) — int — 기본 키 — NOT NULL
  • KDCNumber (Field) — int
  • subKeyword (Field2) — char(20)

Untitled (Publisher)

  • Key (pubID) — int — 기본 키 — NOT NULL
  • Field (pubName) — char(20)
  • Field (pubAddress) — text

Untitled (Book)

  • Key (ISBN) — int — 기본 키 — NOT NULL
  • Field (booTitle) — char(30)
  • Field (booPublicationDate) — date
  • Key (pubID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Author)

  • Key (AutID) — int — 기본 키 — NOT NULL
  • Field (autName) — char(20)
  • Field (autAddress) — text

Untitled (Book_Author)

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