2023사서교육원_준사서C반_김종우_예제문제2

테이블 (4)

Untitled (Activity)

  • Key (activityCode) — char(30) — 기본 키 — NOT NULL
  • Field (activityName) — char(30)
  • Field (activityExplanation) — char(30)

Untitled (Class)

  • Key (classNumber) — char(30) — 기본 키 — NOT NULL
  • Field (runningTime) — time
  • Field (등록제한인원) — int
  • Field (현재등록인원) — int
  • Field (className) — char(30)
  • Key (activityCode) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Member)

  • Key (memberSsn) — int — 기본 키 — NOT NULL
  • Field (memberName) — char(30)
  • Field (memberAddress) — char(30)
  • Field (memberAge) — int
  • Field (memberPhoneNumber) — char(11)
  • Field (memberGender) — char(11)

Untitled (Registration)

  • Field (level) — char(10)
  • Key (classNumber) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (fee) — int
  • Field (period) — date
  • Key (memberSsn) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (date) — date