Exercise2

Tables (4)

ACTIVITY

  • Key (actCode) — char(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field2 (description) — text

SPORTS

  • Key (code) — char(10) — Primary key — NOT NULL
  • Field (direction) — text
  • Field2
  • Field3

Untitled (CLASS)

  • Key (classID) — integer — Primary key — NOT NULL
  • Field (classname) — char(30)
  • Field2 (time) — char(30)
  • Field3 (limite) — char(30)
  • Field4 (registration) — char(30)
  • Field5 (year) — integer(2)
  • Field6 (month)
  • Field
  • Field2
  • Field3
  • Field4
  • Key (actCode) — char(10) — Foreign key → ACTIVITY.Key — NOT NULL

Untitled (MEMBER)

  • Key (memID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(15)
  • Field (adress) — char(15)
  • Field (age) — char(15)
  • Field (leveltest) — char(15)
  • Field