Exercise2

Tables (4)

Untitled (Activity)

  • Key (ActCold) — char(5) — Primary key — NOT NULL
  • Field (ActName) — char(20)
  • Field (ActDesciption) — text

Untitled (Class)

  • Key (CkassNumber) — char(5) — Primary key — NOT NULL
  • Key (ActCold) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (ClassName) — char(20)
  • Field (ClassTime) — char(10)
  • Field (ClassLevel) — char(1)
  • Field (ClassMemver) — int(3)

Untitled (Member)

  • Key (MemID) — char(5) — Primary key — NOT NULL
  • Field (NemName) — char(20)
  • Field (MemBirthday) — date
  • Field (MemAdress) — char(30)

Untitled (Nroll)

  • Key (MemID) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (CkassNumber) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (ActCold) — char(5) — Foreign key → Untitled.Key — NOT NULL