ERD Exercise

Tables (11)

Untitled (SPORTS)

  • Key (sportId) — Int(10) — Primary key — NOT NULL
  • Field (SportName) — char(20)

Untitled (ClASS)

  • Key (ClassId) — Int(10) — Primary key — NOT NULL
  • Key (sportId) — Int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (Reqlv) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (Time) — Char(10) — NOT NULL
  • Field (CurentEnroll) — int(10)
  • Field (LimitEnroll) — int(10)

Untitled (REGISTRATION)

  • Key (registId) — int(10) — Primary key — NOT NULL
  • Key (memID) — Int(15) — Foreign key → Untitled.Key — NOT NULL
  • Key (ClassId) — Int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (sportId) — Int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (Reqlv) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (MEMBER)

  • Key (memID) — Int(15) — Primary key — NOT NULL
  • Field (name) — Char(20)
  • Field2 (address) — char(20)
  • Field3 (age) — int(3)

Untitled (MEMBERLEVEL)

  • Key (memLv) — Primary key — NOT NULL
  • Key (sportId) — Int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (memID) — Int(15) — Foreign key → Untitled.Key — NOT NULL

Untitled (LEVEL)

  • Key (lvId) — char(10) — Primary key — NOT NULL
  • Field (lvName) — char(10)

Untitled (CLIENT)

  • Key (clientId) — char(10) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (adress) — char(20)
  • Field (phone) — char(13)

Untitled (DEPENDENT)

  • Key (depId) — char(10) — Primary key — NOT NULL
  • Key (clientId) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — char(10)
  • Field (age) — int
  • Field2 (registrationNumber) — int(13)

Untitled (PROVIDER)

  • Key (providerId) — char(10) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (adress) — char(20)
  • Field (phone) — char(13)

Untitled (RECORD)

  • Key (offerTimes) — int(10) — Primary key — NOT NULL
  • Key (clientId) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (providerId) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (startDate)

Untitled (SERVICE)

  • Key (servId) — char(10) — Primary key — NOT NULL
  • Key (providerId) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field