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)