Exercise 2

Tables (4)

Untitled (Activity)

  • Key (actCode) — char(5) — Primary key — NOT NULL
  • Field (actName) — char(20)
  • Field (desciption) — text

Untitled (Class)

  • Key (classIDy) — char(10) — Primary key — NOT NULL
  • Key (actCode) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (className) — char(20)
  • Field (classTime) — char(30)
  • Field (classMaxRegi) — int(3)
  • Field (classLevel) — int(4)

Untitled (Member)

  • Key (memID) — char(10) — Primary key — NOT NULL
  • Field (MemName) — char(20)
  • Field (memBirthDate) — date
  • Field (memAddress) — char(30)
  • Field (memPhone) — char(12)

Untitled (Enroll)

  • Key (classIDy) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (actCode) — char(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (memID) — char(10) — Foreign key → Untitled.Key — NOT NULL