ERD_Exercise_2

Tables (4)

Untitled (Activity)

  • Key (code) — Char(10) — Primary key — NOT NULL
  • Field (name) — Char(20)
  • Field (description) — text

Untitled (class)

  • Key (classNo) — Char(10) — Primary key — NOT NULL
  • Field (StartTime) — DateTime
  • Field (EndTime) — DateTime
  • Field (LimitPeople) — Char(10)
  • Field (RegistrationPeople) — Char(10)
  • Field (level) — Char(1)
  • Key (code) — Char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (member)

  • Key (memberNo) — Char(5) — Primary key — NOT NULL
  • Field (name) — Char(10)
  • Field (Age) — int(3)

Untitled (class_member)

  • Key (memberNo) — Char(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (classNo) — Char(10) — Foreign key → Untitled.Key — NOT NULL