exercise3

Tables (5)

DEPENDENT (SERVICE)

  • dependentssn (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(10)
  • age (Field2) — int(2)
  • clientssn (Key2) — char(10) — Foreign key → FEMALE_CLIENT.clientssn — NOT NULL

FEMALE_CLIENT (PROVIDER)

  • clientssn (Key) — char(10) — Primary key — NOT NULL
  • name (Field3) — char(10)
  • address (Field) — char(30)
  • phone (Field2) — char(10)
  • serviceDate (Field4) — char(10)

ORANIZATION (SERVICEGROUP)

  • clientssn (Key2) — char(10) — Foreign key → FEMALE_CLIENT.clientssn — NOT NULL
  • dependentssn (Key) — char(10) — Foreign key → DEPENDENT.dependentssn — NOT NULL

PROVIDER (CLIENT)

  • providerSsn (Key) — char(10) — Primary key — NOT NULL
  • clientssn (Key3) — char(10) — Foreign key → FEMALE_CLIENT.clientssn — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(30)
  • phone (Field3) — char(10)

SERVICE (DEPENDENT)

  • serviceCode (Key) — char(10) — Primary key — NOT NULL
  • providerSsn (Key3) — char(10) — Foreign key → PROVIDER.providerSsn — NOT NULL
  • clientssn (Key32) — char(10) — Foreign key → PROVIDER.clientssn — NOT NULL
  • description (Field) — text
  • clientssn (Key2) — char(10) — Foreign key → FEMALE_CLIENT.clientssn — NOT NULL