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