ERD_Exercise2_답안

테이블 (4)

ACTIVITY (Untitled)

  • Key (actCode) — integer — 기본 키 — NOT NULL
  • Key (classCode) — 외래 키 → CLASS.Key — NOT NULL

CLASS (Untitled2)

  • Key (classCode) — 기본 키 — NOT NULL
  • Field (name)
  • Field (time)
  • Field (maxRe)
  • Field (nowRe)
  • Field (level)
  • Field (descriptiom)
  • Key (actCode) — integer — 외래 키 → ACTIVITY.Key — NOT NULL

ENROLL (Untitled4)

  • Key (actCode) — 기본 키 — NOT NULL
  • Key (memID) — 외래 키 → MEMBER.Key — NOT NULL
  • Key (classCode) — 외래 키 → CLASS.Key — NOT NULL

MEMBER (Untitled3)

  • Key (memID) — 기본 키 — NOT NULL
  • Field (name)
  • Field (phone)
  • Field (address)
  • Field (email)
  • Field (age)
  • Field (gender)