ERD 연습문제 6

테이블 (6)

Untitled (Author)

  • Key (ssn) — char(20) — 기본 키 — NOT NULL
  • Field (aName) — char(10)
  • Field (aAddress) — char(20)

Untitled (book_author)

  • Key (isbn) — char(20) — 외래 키 → book.Key — NOT NULL
  • Key (ssn) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (publishCompany)

  • Key (puId) — char(20) — 기본 키 — NOT NULL
  • Field (pcName) — char(10)
  • Field (pcAddress) — char(30)

Untitled (printCompany_book)

  • Key (isbn) — char(20) — 외래 키 → book.Key — NOT NULL
  • Key (prID) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (prQty) — int(5)
  • Field (prFinDate) — date

Untitled (printCompany)

  • Key (prID) — char(20) — 기본 키 — NOT NULL
  • Field (prName) — char(10)
  • Field (prAddress) — char(30)

book

  • Key (isbn) — char(20) — 기본 키 — NOT NULL
  • Field (bName) — char(30)
  • Field (publishDate) — date
  • Field
  • Key (pcId) — char(20) — 외래 키 → Untitled.Key — NOT NULL