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)