system analysis 4

Tables (7)

Author (Untitled3)

  • AuthorID (Key) — Primary key — NOT NULL
  • 이름 (Field2)
  • 주소 (Field3)
  • 대표작 (Field4)

Book (Untitled)

  • ISBN (Key) — Primary key — NOT NULL
  • KDC번호 (Key3) — Foreign key → KDCClassification.KDC번호 — NOT NULL
  • Book name (Field2)
  • 출판일자 (Field3)
  • 출판사 ID (Key2) — Foreign key → Publisher.출판사 ID — NOT NULL
  • 인쇄소ID (Key4) — Foreign key → PrintingHouse.인쇄소ID — NOT NULL
  • AuthorID (Key5) — Foreign key → Author.AuthorID — NOT NULL
  • KeywordID (Key6) — Foreign key → Keyword.KeywordID — NOT NULL

Contract (Untitled5)

  • ContractID (Key) — Primary key — NOT NULL
  • ISBN (Key2) — Foreign key → Book.ISBN — NOT NULL
  • KDC번호 (Key3) — Foreign key → Book.KDC번호 — NOT NULL
  • 권수 (Field2)
  • 인쇄 마감일 (Field3)

KDCClassification (Untitled7)

  • KDC번호 (Key) — Primary key — NOT NULL
  • 분류 (Field2)

Keyword (Untitled6)

  • KeywordID (Key) — Primary key — NOT NULL
  • 키워드명 (Field2)

PrintingHouse (Untitled4)

  • 인쇄소ID (Key) — Primary key — NOT NULL
  • 명칭 (Field2)
  • 주소 (Field3)

Publisher (Untitled2)

  • 출판사 ID (Key) — Primary key — NOT NULL
  • 명칭 (Field2)
  • 주소 (Field3)