2024_04_ERD Exercise 3

Tables (5)

Untitled (SERVICE)

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

Untitled (SERVER)

  • Key (serverID) — char(30) — Primary key — NOT NULL
  • Field (Name) — char(30)
  • Field (address) — char(30)
  • Field (phone) — char(11)
  • Field (email) — email

Untitled (CUSTOMAR)

  • Key2 (RegID) — char(13) — Primary key — NOT NULL
  • Field2 (Name) — char(20) — Primary key
  • Field (address) — char(30)
  • Field (phone) — char(20)
  • Field2 (email) — email
  • Key (serviceCode) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (DEPENPENT FAMILY)

  • Key (familyRegId) — char(13) — Primary key — NOT NULL
  • Field (Name) — char(30)
  • Field (birth) — date
  • Key2 (RegID) — char(13) — Foreign key → Untitled.Key2 — NOT NULL
  • Field2 (Name2) — char(20) — Foreign key → Untitled.Field2

Untitled (SERVICE_INFORMATION)

  • Key (serviceCode) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (serverID) — char(30) — Foreign key → Untitled.Key — NOT NULL