work3
Tables (5)
Untitled (CLIENT)
- Key (ClientSsn) — char(15) — Primary key — NOT NULL
- Field (ClientName) — char(20)
- Field (ClientAddress) — char(30)
- Field (Clientphonenunber) — char(11)
Untitled (Dependent)
- Key (DependentSSn) — char(5) — Primary key — NOT NULL
- Field (DependentName) — char(20)
- Field (DependentAge) — char(3)
- Key (ClientSsn) — char(15) — Foreign key → Untitled.Key — NOT NULL
Untitled (Service-Maching)
- 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)
- Key (Servicecode) — char(10) — Primary key — NOT NULL
- Field (descrption) — text
Untitled (SERVICE-PROVIDER)
- Key (proID) — char(10) — Primary key — NOT NULL
- Field (proName) — char(20)
- Field2 (proaddress) — char(30)
- Field (prophonenumber) — char(11)