ERD_EXERCISE_2

Tables (5)

ACTIVITY (Untitled)

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

CLASS (Untitled2)

  • classId (Key) — char(10) — Primary key — NOT NULL
  • activityCode (Key2) — char(10) — Foreign key → ACTIVITY.activityCode — NOT NULL
  • classTime (Field) — char(10)
  • maxNum (Field2) — integer
  • currentNum (Field3) — integer
  • classLevel (Field4) — char(10)

CLASS_MEMBER (Untitled4)

  • classId (Key) — char(10) — Foreign key → CLASS.classId — NOT NULL
  • activityCode (Key2) — char(10) — Foreign key → CLASS.activityCode — NOT NULL
  • memberId (Key3) — char(10) — Foreign key → MEMBER.memberId — NOT NULL
  • memberLevel (Field5) — char(10) — Foreign key → MEMBER.memberLevel

MEMBER (Untitled3)

  • memberId (Key) — char(10) — Primary key — NOT NULL
  • memberName (Field) — char(20)
  • address (Field2) — char(50)
  • age (Field3) — integer
  • activityCode (Key2) — char(10) — Foreign key → MEMBER_INFO.activityCode — NOT NULL
  • memberLevel (Field5) — char(10) — Foreign key → MEMBER_INFO.memberLevel

MEMBER_INFO (Untitled5)

  • memberLevel (Field) — char(10) — Primary key
  • activityCode (Key) — char(10) — Foreign key → ACTIVITY.activityCode — NOT NULL