기말고사

테이블 (4)

AUTHOR (Untitled2)

  • authorID (Key) — int(10) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • birthdate (Field2) — int(10)
  • famous work (Field3) — text

BOOK-AUTHOR (Untitled4)

  • ISBN (Key2) — char(13) — 외래 키 → Book.ISBN — NOT NULL
  • authorID (Key) — int(10) — 외래 키 → AUTHOR.authorID — NOT NULL

Book (Untitled)

  • ISBN (Key) — char(13) — 기본 키 — NOT NULL
  • title (Field) — char(50)
  • kdc (Field2) — char(20)
  • pubyear (Field3) — int(4)
  • type (Field4) — char(10)
  • pages (Field5) — int(10)
  • age group (Field6) — char(10)
  • location (Field7) — char(15)
  • company id (Key2) — int(10) — 외래 키 → PUBLISHING COMPANY.company id — NOT NULL

PUBLISHING COMPANY (Untitled3)

  • company id (Key) — int(10) — 기본 키 — NOT NULL
  • company name (Field) — char(20)
  • adress (Field2) — char(10)