실습

테이블 (4)

Complete (Untitled3)

  • subQntity (Field) — int(5)
  • mainSSN (Key3) — Char(10) — 외래 키 → MainProduct.mainSSN — NOT NULL
  • subSSN (Key4) — Char(10) — 외래 키 → SubProduct.subSSN — NOT NULL

MainProduct (Untitled2)

  • mainSSN (Key) — Char(10) — 기본 키 — NOT NULL
  • mainDsc (Field) — Char(30)
  • mainPr (Field2) — Char(10)

PRODUCER (Untitled)

  • pSSN (Key) — Char(8) — 기본 키 — NOT NULL
  • pName (Field) — char(30)
  • pAdr (Field2) — Char(30)
  • pPNum (Field3) — Char(15)

SubProduct (Untitled4)

  • subSSN (Key) — Char(10) — 기본 키 — NOT NULL
  • subDsc (Field2) — Char(30)
  • pSSN (Key2) — Char(8) — 외래 키 → PRODUCER.pSSN — NOT NULL