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)