Exercise2

Tables (3)

Activity (Untitled2)

  • ActivityCode (Key) — char(20) — Primary key — NOT NULL
  • ActivityDescript (Field) — text
  • Field2
  • ClassID (Key2) — Foreign key → Class.ClassID — NOT NULL

Class (Untitled)

  • ClassID (Key) — char(10) — Primary key — NOT NULL
  • Time (Field) — char(4)
  • EnrollmentLimit (Field2) — char(4)
  • ClassLevel (Field3) — char(3)
  • MemberID (Key2) — char(20) — Foreign key → Member.MemberID — NOT NULL

Member (Untitled3)

  • MemberID (Key) — char(20) — Primary key — NOT NULL
  • Name (Field) — char(20)
  • Adress (Field2) — char(20)
  • Age (Field3) — char(2)