ERD exercise 3
Tables (6)
Untitled (CUSTOMER)
- Key (cusName) — char(20) — Primary key — NOT NULL
- Field (cusAddress) — char(70)
- Field (cusSsn) — char(14)
- Field (cusPhoneNumber) — char(13)
Untitled (FAMILY_DEPENDENT)
- Key (depName) — char(30) — Primary key — NOT NULL
- Key (cusName) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (age) — int
- Field (depSsn) — char(14)
Untitled (SERVICE_PROVIDER)
- Key (proID) — char(15) — Primary key — NOT NULL
- Field (proName) — char(20)
- Field (proAddress) — char(70)
- Field (proPhoneNumber) — char(13)
Untitled (SERVICE)
- Key (ServiceCode) — char(20) — Primary key — NOT NULL
- Field (description) — text
- Field (date) — date
Untitled (CUSTOMER_SERVICE)
- Key (ServiceCode) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (serDate) — date
- Key (cusName) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (PROVIDED_SERVICE)
- Key (ServiceCode) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (proID) — char(15) — Foreign key → Untitled.Key — NOT NULL