Ex3

Tables (5)

Untitled (Client)

  • Key (clientSsn) — char(15) — Primary key — NOT NULL
  • Field (clientName) — char(20)
  • Field (clientAddress) — char(20)
  • Field (clientPhone) — char(11)

Untitled (Service)

  • Key (serviceCode) — char(10) — Primary key — NOT NULL
  • Field (description) — text
  • Field (date) — date

Untitled (Client_Service)

  • 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_Provider)

  • Key (proID) — char(10) — Primary key — NOT NULL
  • Field (proName) — char(20)
  • Field (proAddress) — char(30)
  • Field (proPhone) — char(11)

Untitled (Dependent)

  • Key (dependentSsn) — char(15) — Primary key — NOT NULL
  • Field (dependentName) — char(20)
  • Field (dependentAge) — char3)
  • Key (clientSsn) — char(15) — Foreign key → Untitled.Key — NOT NULL