[다시]ERD 연습문제 6

테이블 (6)

Untitled (publisher)

  • Key (pcode) — char(20) — 기본 키 — NOT NULL
  • Field (pname) — char(30)
  • Field (paddress) — char(30)
  • Field (pphone) — int(15)

Untitled (author)

  • Key (assn) — char(20) — 기본 키 — NOT NULL
  • Field (aname) — char(20)
  • Field (aaddress) — char(30)

Untitled (book_author)

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

Untitled (print)

  • Key (prcode) — char(20) — 기본 키 — NOT NULL
  • Field (prname) — char(20)
  • Field (praddress) — char(30)
  • Field (prphone) — int(15)

Untitled (contract)

  • Key (ccode) — char(20) — 기본 키 — NOT NULL
  • Field (cdate) — date
  • Field (pamount) — int(10)
  • Field (plimitdate) — date
  • Key (isbn) — char(20) — 외래 키 → book.Key — NOT NULL
  • Key (prcode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (pcode) — char(20) — 외래 키 → Untitled.Key — NOT NULL

book

  • Key (isbn) — char(20) — 기본 키 — NOT NULL
  • Field (bname) — char(30)
  • Field (bpdate) — date
  • Field (bprice) — int(10)
  • Key (pcode) — char(20) — 외래 키 → Untitled.Key — NOT NULL