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