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)