exercise 2
Tables (4)
ACTIVITY (Untitled)
- activityID (Key) — char(10) — Primary key — NOT NULL
- explanation (Field) — char(50)
- activityName (Field2) — longtxt
CLASS (Untitled2)
- classID (Key4) — Primary key — NOT NULL
- code (Field) — char(10)
- time (Field2) — time
- level (Key3) — int(1) — Foreign key → DIFFICULTY.level — NOT NULL
- member (Field3) — char(30)
- limitedMember (Field4) — char(30)
- name (Key) — char(10) — Foreign key → MEMBER.name — NOT NULL
- activityID (Key2) — char(10) — Foreign key → ACTIVITY.activityID — NOT NULL
DIFFICULTY (Untitled4)
- level (Key) — int(1) — Primary key — NOT NULL
MEMBER (Untitled3)
- name (Key) — char(10) — Primary key — NOT NULL
- address (Field) — char(30)
- age (Field2) — int(3)
- name (Key4) — Foreign key → CLASS.classID — NOT NULL