EXERCISE
Tables (4)
ACTIVTY (Activity)
- Key (activityNo) — int(3) — Primary key — NOT NULL
- Field (name) — char(15)
- Field (descrition) — text
- Key (classNo) — int(3) — Foreign key → Class.Key — NOT NULL
Class (class)
- Key (classNo) — int(3) — Primary key — NOT NULL
- Field (worktime) — time
- Key (activityNo) — int(3) — Foreign key → ACTIVTY.Key — NOT NULL
- Field (registraionLimit) — int(3)
- Field — int(3)
class_member (Registration)
- Key (memberNo) — int(3) — Foreign key → member.Key — NOT NULL
- Field (level) — char(5)
- Key (classNo) — int(3) — Foreign key → Class.Key — NOT NULL
member
- Key (memberNo) — int(3) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (address) — char(30)
- Field (age) — char(5)