[다시]ERD 연습문제 1

테이블 (4)

Untitled (producer)

  • Key (proCode) — char(10) — 기본 키 — NOT NULL
  • Field (proName) — char(10)
  • Field (proAddress) — char(20)
  • Field (proCell) — int(12)

Untitled (part)

  • Key (paCode) — char(10) — 기본 키 — NOT NULL
  • Field (paDescription) — text
  • Field (paName) — char(10)
  • Key (proCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (product_part)

  • Key (paCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (pCode) — char(10) — 외래 키 → product.Key — NOT NULL
  • Field (paAmount) — int(4)

product

  • Key (pCode) — char(10) — 기본 키 — NOT NULL
  • Field (pName) — char(10)
  • Field (pPrice) — int(3)
  • Field (pDesctiption) — text