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