20251001-2

Tables (4)

Activity

  • Key (activityCode) — char — Primary key — NOT NULL
  • Field (description) — char

Untitled (CLASS)

  • Key (classNumber) — char — Primary key — NOT NULL
  • Key (activityCode) — char — Foreign key → Activity.Key — NOT NULL
  • Field (schedule) — char
  • Field (capacity) — int
  • Field (currentEnrollment) — int
  • Field (InstructorName) — char
  • Field (level) — int

Untitled (MEMBER)

  • Key (memberID) — char — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (address) — char(30)
  • Field (age) — int

Untitled (REGISTRATION)

  • Key (memberID) — char — Foreign key → Untitled.Key — NOT NULL
  • Key (classNumber) — char — Foreign key → Untitled.Key — NOT NULL
  • Key (activityCode) — char — Foreign key → Untitled.Key — NOT NULL