ERD_Exercise 3
Tables (5)
Untitled (client)
- Key (ssn) — Char(10) — Primary key — NOT NULL
- Field (name) — Char(10)
- Field (address) — Char(30)
- Field (phone) — Char(11)
Untitled (depundent)
- Key (ssn(dependent's)) — Char(10) — Primary key — NOT NULL
- Key (ssn) — Char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — Char(10)
- Field (age) — Char(3)
Untitled (service_provider)
- Key (providerNo) — Char(10) — Primary key — NOT NULL
- Field (name) — Char(10)
- Field (address) — Char(30)
- Field (phone) — Char(11)
- Field (type) — Char(4)
Untitled (service)
- Key (code) — Char(10) — Primary key — NOT NULL
- Field (description) — text
Untitled (work_on)
- Key (code) — Char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (ssn) — Char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (providerNo) — Char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (serviceDate) — Date