exercise 2

Tables (4)

ACTIVITY (Untitled)

  • activityID (Key) — char(10) — Primary key — NOT NULL
  • explanation (Field) — char(50)
  • activityName (Field2) — longtxt

CLASS (Untitled2)

  • classID (Key4) — Primary key — NOT NULL
  • code (Field) — char(10)
  • time (Field2) — time
  • level (Key3) — int(1) — Foreign key → DIFFICULTY.level — NOT NULL
  • member (Field3) — char(30)
  • limitedMember (Field4) — char(30)
  • name (Key) — char(10) — Foreign key → MEMBER.name — NOT NULL
  • activityID (Key2) — char(10) — Foreign key → ACTIVITY.activityID — NOT NULL

DIFFICULTY (Untitled4)

  • level (Key) — int(1) — Primary key — NOT NULL

MEMBER (Untitled3)

  • name (Key) — char(10) — Primary key — NOT NULL
  • address (Field) — char(30)
  • age (Field2) — int(3)
  • name (Key4) — Foreign key → CLASS.classID — NOT NULL