exercise2

Tables (4)

ACTIVITY (Untitled)

  • activID (Key) — char(10) — Primary key — NOT NULL
  • description (Field) — text

CLASS (Untitled2)

  • classID (Key) — char(10) — Primary key — NOT NULL
  • activID (Key2) — char(10) — Foreign key → ACTIVITY.activID — NOT NULL
  • level (Field5) — int(5)
  • people (Field3) — int(5)
  • code (Field) — char(10)
  • time (Field2) — int(3)
  • capacity (Field4) — int(3)
  • membID (Key3) — char(10) — Foreign key → MEMBER.membID — NOT NULL

CLASS-MEMBERTYPE (Untitled4)

  • classID (Key2) — char(10) — Foreign key → CLASS.classID — NOT NULL
  • membID (Key3) — char(10) — Foreign key → MEMBER.membID — NOT NULL
  • activID (Key22) — char(10) — Foreign key → CLASS.activID — NOT NULL

MEMBER (Untitled3)

  • membID (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(30)
  • age (Field3) — int(3)
  • classID (Key2) — char(10) — Foreign key → CLASS.classID — NOT NULL
  • activID (Key22) — char(10) — Foreign key → CLASS.activID — NOT NULL