3

Tables (4)

ACTIVITY (Untitled)

  • activityID (Key) — int(10) — Primary key — NOT NULL
  • activityName) (Field) — char(10)
  • description (Field2) — char(20)

CLASS (Untitled2)

  • classNo (Key) — int(10) — Primary key — NOT NULL
  • activityID (Key2) — int(10) — Foreign key → ACTIVITY.activityID — NOT NULL
  • time (Field) — int(4)
  • Max_Enrollment (Field2) — int(20)
  • Current_Enrollment (Field3) — int(20)

ENROLLMENT (Untitled4)

  • enrollmentID (Key) — int(10) — Primary key — NOT NULL
  • memberNo (Key3) — int(10) — Foreign key → MEMBER.memberNo — NOT NULL
  • classNo (Key2) — int(10) — Foreign key → CLASS.classNo — NOT NULL
  • activityID (Key22) — int(10) — Foreign key → CLASS.activityID — NOT NULL

MEMBER (Untitled3)

  • memberNo (Key) — int(10) — Primary key — NOT NULL
  • memberName (Field) — char(10)
  • adress (Field2) — char(20)
  • age (Field3) — int(2)