ERD EXERCISE 3
Tables (7)
Untitled (CLIENT)
- Key (clientld) — int(5) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (address) — chat(100)
- Field (phone) — int(11)
- Field (emaill) — char(100)
- Field (ssn) — char(13)
Untitled (DEPENDANT)
- Key (dependantld) — int(5) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (phone) — int(11)
- Key (clientld) — int(5) — Foreign key → Untitled.Key — NOT NULL
- Field (ssn) — char(13)
Untitled (SERVICEPROVIDER)
- Key (providerld) — int(100) — Primary key — NOT NULL
- Field (name) — char(100)
- Field (address) — char(100)
- Field (phone) — int(12)
- Field (grade) — float(3)
- Field (memo) — LONGTEXT
- Field (type) — char(4)
Untitled (ENROLL)
- Key (sereld) — integer — Primary key — NOT NULL
- Field (grade) — char(2)
- Field (review) — LONGTEXT
- Key (clientld) — int(5) — Foreign key → Untitled.Key — NOT NULL
- Key (classld) — int(100) — Foreign key → Untitled.Key — NOT NULL
- Field (date) — date
Untitled (SERVICE)
- Key (classld) — int(100) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (level) — char(2)
- Field (year) — int(4)
- Field (month) — int(2)
- Field (lecturer) — char(10)
- Key (providerld) — int(100) — Foreign key → Untitled.Key — NOT NULL
- Key (subjectld) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (lecturerld) — int(100) — Foreign key → Untitled.Key — NOT NULL
- Field (fee) — integer
Untitled (SUBJECT)
- Key (subjectld) — int(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (memo) — LONGTEXT
Untitled (LECTURER)
- Key (lecturerld) — int(100) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (phone) — char(20)
- Field (email) — char(30)
- Field (description) — text