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