과제 예제6_임미숙

테이블 (5)

AUTHOR (Untitled3)

  • Ssn (Key) — int — 기본 키 — NOT NULL
  • ISBN (Key2) — int — 외래 키 → BOOK.ISBN — NOT NULL
  • pub.ID (Key22) — char(10) — 외래 키 → BOOK.pub.ID — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(30)
  • phone (Field3) — int
  • email (Field4) — char(20)

BOOK (Untitled)

  • ISBN (Key) — int — 기본 키 — NOT NULL
  • pub.ID (Key2) — char(10) — 외래 키 → PUBLISHER.pub.ID — NOT NULL
  • title (Field) — char(20)
  • publishedDate (Field2) — date
  • publisher (Field3) — char(15)
  • author (Field4) — char(20)
  • printer (Field5) — char(20)

CONTRACT (Untitled5)

  • contractNo (Key) — char(10) — 기본 키 — NOT NULL
  • ISBN (Key2) — int — 외래 키 → BOOK.ISBN — NOT NULL
  • pub.ID (Key22) — char(10) — 외래 키 → BOOK.pub.ID — NOT NULL
  • printerID (Key3) — char(10) — 외래 키 → PRINTER.printerID — NOT NULL
  • QtyOfBook (Field) — char(10)
  • printingdeadline (Field2) — char(15)
  • contractdate (Field3)

PRINTER (Untitled4)

  • printerID (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(30)
  • phone (Field3) — int
  • email (Field4) — char(20)

PUBLISHER (Untitled2)

  • pub.ID (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(30)
  • phone (Field3) — char(15)
  • email (Field4)