Ex3
Tables (5)
Untitled (Client)
- Key (clientSsn) — char(15) — Primary key — NOT NULL
- Field (clientName) — char(20)
- Field (clientAddress) — char(20)
- Field (clientPhone) — char(11)
Untitled (Service)
- Key (serviceCode) — char(10) — Primary key — NOT NULL
- Field (description) — text
- Field (date) — date
Untitled (Client_Service)
- Key (clientSsn) — char(15) — Foreign key → Untitled.Key — NOT NULL
- Key (serviceCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (proID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Service_Provider)
- Key (proID) — char(10) — Primary key — NOT NULL
- Field (proName) — char(20)
- Field (proAddress) — char(30)
- Field (proPhone) — char(11)
Untitled (Dependent)
- Key (dependentSsn) — char(15) — Primary key — NOT NULL
- Field (dependentName) — char(20)
- Field (dependentAge) — char3)
- Key (clientSsn) — char(15) — Foreign key → Untitled.Key — NOT NULL