ERD Exercise 3

Tables (5)

AGENCY (Untitled6)

  • description (Field) — char(40)
  • provider Identi fier (Key2) — char(13) — Foreign key → SERVICEPROVIDER.provider Identi fier — NOT NULL
  • Service Identifier (Key3) — cbar(10) — Foreign key → SERVICE.Service Identifier — NOT NULL

CLIENT (Untitled)

  • SecurityNumber (Key) — char(13) — Primary key — NOT NULL
  • Service Identifier (Key2) — cbar(10) — Foreign key → SERVICE.Service Identifier — NOT NULL
  • name (Field) — char(15)
  • adress (Field2) — char(40)
  • PhoneNumber (Field3) — cbar(12)

DEPENDENT (Untitled3)

  • ssn (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(15)
  • age (Field2) — char(6)
  • SecurityNumber (Key2) — char(13) — Foreign key → CLIENT.SecurityNumber — NOT NULL
  • Service Identifier (Key22) — cbar(10) — Foreign key → CLIENT.Service Identifier — NOT NULL

SERVICE (Untitled4)

  • Service Identifier (Key) — cbar(10) — Primary key — NOT NULL
  • description (Field) — char(40)
  • service Date (Field2) — char(10)
  • SecurityNumber (Key2) — char(13) — Foreign key → CLIENT.SecurityNumber — NOT NULL

SERVICEPROVIDER (Untitled5)

  • provider Identi fier (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(15)
  • address (Field2) — char(40)
  • phone Number (Field3) — char(12)