ERD 연습문제 1번

테이블 (5)

Untitled (COMPANY)

  • Key (comID) — int — 기본 키 — NOT NULL
  • Field (comName) — char(20)
  • Field (comAddress) — char(50)
  • Field (comPhone) — int
  • Key (proID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (PRODUCER)

  • Key (proID) — int — 기본 키 — NOT NULL
  • Field (proName) — char(20)
  • Field (proAddress) — char(50)
  • Field (proPhone) — int
  • Key (comID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (GOODS)

  • Key (goodsID) — int — 기본 키 — NOT NULL
  • Field (goodsDescription) — char(100)
  • Field (goodsPrice) — int
  • Key (comID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (PART)

  • Key (partID) — int — 기본 키 — NOT NULL
  • Field (partDescription) — char(100)
  • Key (proID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (MAKEON)

  • Key (goodsID) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (partID) — int — 외래 키 → Untitled.Key — NOT NULL