ERD Exercise 6(여영규)

테이블 (5)

AUTHOR (Untitled3)

  • authorID (Key) — char(20) — 기본 키 — NOT NULL
  • authorName (Field) — char(20)
  • authorAddress (Field2) — char(30)
  • bookISBN (Key2) — char(20) — 외래 키 → BOOK.bookISBN — NOT NULL

BOOK (Untitled)

  • bookISBN (Key) — char(20) — 기본 키 — NOT NULL
  • bookName (Field) — char(50)
  • bookPublisherdate (Field2) — date
  • bookPublisher (Field3) — char(20)

CONTRACINFORMATION (Untitled5)

  • contractNumberofprint (Key) — char(10) — 기본 키 — NOT NULL
  • contractDeadlinedate (Field) — date

PRINTER (Untitled4)

  • printerID (Key) — char(10) — 기본 키 — NOT NULL
  • bookISBN (Key2) — char(20) — 외래 키 → BOOK.bookISBN — NOT NULL
  • printerName (Field) — char(20)
  • printerAddress (Field2) — char(30)
  • printerCapacity (Field3) — char(10)
  • contractNumberofprint (Key3) — char(10) — 외래 키 → CONTRACINFORMATION.contractNumberofprint — NOT NULL
  • publisherID (Key4) — char(10) — 외래 키 → PUBLISHER.publisherID — NOT NULL
  • bookISBN (Key22) — char(20) — 외래 키 → PUBLISHER.bookISBN — NOT NULL

PUBLISHER (Untitled2)

  • publisherID (Key) — char(10) — 기본 키 — NOT NULL
  • bookISBN (Key2) — char(20) — 외래 키 → BOOK.bookISBN — NOT NULL
  • publisherName (Field) — char(20)
  • publisherAddress (Field2) — char(30)