ERD_Exercise 3

Tables (5)

Untitled (client)

  • Key (ssn) — Char(10) — Primary key — NOT NULL
  • Field (name) — Char(10)
  • Field (address) — Char(30)
  • Field (phone) — Char(11)

Untitled (depundent)

  • Key (ssn(dependent's)) — Char(10) — Primary key — NOT NULL
  • Key (ssn) — Char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — Char(10)
  • Field (age) — Char(3)

Untitled (service_provider)

  • Key (providerNo) — Char(10) — Primary key — NOT NULL
  • Field (name) — Char(10)
  • Field (address) — Char(30)
  • Field (phone) — Char(11)
  • Field (type) — Char(4)

Untitled (service)

  • Key (code) — Char(10) — Primary key — NOT NULL
  • Field (description) — text

Untitled (work_on)

  • Key (code) — Char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (ssn) — Char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (providerNo) — Char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (serviceDate) — Date