Exercise 2

Tables (5)

activity (Untitled)

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

class (Untitled2)

  • classNo (Key) — char(8) — Primary key — NOT NULL
  • activityCode (Key2) — char(10) — Foreign key → activity.activityCode — NOT NULL
  • memberName (Key3) — char(20) — Foreign key → member.name — NOT NULL
  • memberLimit (Field3) — integer(2)
  • memberNow (Field4) — integer(2)

level (Untitled5)

  • activity (Key) — char(20) — Primary key — NOT NULL
  • name (Key2) — char(20) — Foreign key → member.name — NOT NULL
  • classNo (Key3) — char(8) — Foreign key → class.classNo — NOT NULL
  • 1 (Field5) — char(10)
  • 2 (Field) — char(10)
  • 3 (Field2) — char(10)
  • 4 (Field3) — char(10)
  • 5 (Field4) — char(10)

member (Untitled3)

  • name (Key) — char(20) — Primary key — NOT NULL
  • address (Field) — char(50)
  • age (Field2) — date

timetable (Untitled4)

  • classTime (Key) — char(11) — Primary key — NOT NULL
  • classNo (Key2) — char(8) — Foreign key → class.classNo — NOT NULL
  • activityCode (Key22) — char(10) — Foreign key → class.activityCode — NOT NULL
  • name (Key3) — char(20) — Foreign key → class.memberName — NOT NULL