social services organization
Tables (4)
client (CLIENT)
- security number — char(20) — Primary key — NOT NULL
- name — char(20)
- address — varchar(200)
- phone number — char(11)
dependent (DEPENDENT)
- ssn — char(20) — Primary key — NOT NULL
- name — char(20)
- age — int
- security number — char(20) — Foreign key → client.security number — NOT NULL
service (SERVICE)
- service_no — char(20) — Primary key — NOT NULL
- service_name — char(20)
- service_description — varchar(200)
- service_date — date
- provider_no — char(20) — Foreign key → service providers.provider_no — NOT NULL
- ssn — char(20) — Foreign key → dependent.ssn — NOT NULL
service providers (SERVICE PROVIDER)
- provider_no — char(20) — Primary key — NOT NULL
- provider_name — char(20)
- provider_address — varchar(200)
- provider_phone — char(11)