Exercise 2.
Tables (5)
Activity
- Key (activitycode) — char(20) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — text
Class
- Key (classnumber) — char(20) — Primary key — NOT NULL
- Field (activity_code) — char(20)
- Field (level) — char(5)
- Field (description) — text
- Field (price) — integer(20)
- Field (capacity) — integer(5)
- Key (activitycode) — char(20) — Foreign key → Activity.Key — NOT NULL
Member
- Key (memberID) — integer(20) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (adress) — char(20)
- Field (age) — integer(3)
Untitled (Enroll)
- Key (classnumber) — char(20) — Foreign key → Class.Key — NOT NULL
- Key (memberID) — integer(20) — Foreign key → Member.Key — NOT NULL
Untitled (Class_Time)
- Key (classnumber) — char(20) — Foreign key → Class.Key — NOT NULL