과제1

테이블 (4)

Untitled (product part)

  • Key (productID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • partID — char(10) — 외래 키 → part.partID — NOT NULL
  • Field (quentity) — int(10)

Untitled (producer)

  • Key (producerID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field (phone) — char(11)

Untitled (product)

  • Key (productID) — char(10) — 기본 키 — NOT NULL
  • Field (explanation) — char(30)
  • Field (price) — int(10)

part

  • partID — char(10) — 기본 키 — NOT NULL
  • (explanation) — char(30) — NOT NULL
  • Key (producerID) — char(10) — 외래 키 → Untitled.Key — NOT NULL