문제2

테이블 (5)

AUTHOR (Untitled4)

  • resistrationNumber (Key) — char(13) — 기본 키 — NOT NULL
  • authorName (Field) — char(30)
  • athorAddress (Field2) — char(30)
  • ISBN (Key2) — char(30) — 외래 키 → BOOK.ISBN — NOT NULL

BOOK (Untitled)

  • ISBN (Key) — char(30) — 기본 키 — NOT NULL
  • bookName (Field) — char(30)
  • pubID (Key2) — char(30) — 외래 키 → PUBLISHER.pubID — NOT NULL

CONTRACT INOFRMATION (Untitled3)

  • ISBN (Key) — char(30) — 외래 키 → BOOK.ISBN — NOT NULL
  • shopID (Key2) — char(30) — 외래 키 → PRINT SHOP.shopID — NOT NULL
  • numberOfVolumes (Field) — int(100)
  • dueDate (Field2) — date

PRINT SHOP (Untitled5)

  • shopID (Key) — char(30) — 기본 키 — NOT NULL
  • shopName (Field) — char(30)
  • shopAddress (Field2) — char(30)

PUBLISHER (Untitled2)

  • pubID (Key) — char(30) — 기본 키 — NOT NULL
  • pubName (Field) — char(30)
  • pubAddress (Field2) — cahr(30)