ERD예제 2

테이블 (4)

Untitled (CLASS)

  • Key (classID) — 기본 키 — NOT NULL
  • Field (time)
  • Field (level)
  • Field (limitedNumber)
  • Field (numberOf registerred)
  • Key (programName) — 외래 키 → Untitled.Key — NOT NULL

Untitled (MEMBER)

  • Key (name) — char(30) — 기본 키 — NOT NULL
  • Field (address) — char(30)
  • Field (age)
  • Field (telephone)

Untitled (PROGRAM)

  • Key (programName) — 기본 키 — NOT NULL

Untitled (ACTIVITY)

  • Key (activityID) — 기본 키 — NOT NULL
  • Key (name) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (classID) — 외래 키 → Untitled.Key — NOT NULL