exercise 3

Tables (5)

AGENCY (Untitled3)

  • description (Field) — char(40)
  • provider identifier (Key) — char(13) — Foreign key → SERVICEPROVIDER.provider identifier — NOT NULL
  • service identifier (Key22) — char(10) — Foreign key — NOT NULL

CLIENT (Untitled)

  • SecurityNumber (Key) — char(13) — Primary key — NOT NULL
  • service identifier (Key2) — char(10) — Foreign key → SERVICE.service identifier — NOT NULL
  • name (Field) — char(15)
  • address (Field2) — char(40)
  • PhoneNumber (Field3) — char(12)

FAMILY (Untitled4)

  • FamilyID (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) — char(10) — Foreign key → CLIENT.service identifier — NOT NULL

SERVICE (Untitled5)

  • service identifier (Key) — char(10) — Primary key — NOT NULL
  • description (Field) — char(40)
  • service Data (Field2) — char(10)
  • SecurityNumber (Key2) — char(13) — Foreign key → CLIENT.SecurityNumber — NOT NULL

SERVICEPROVIDER (Untitled2)

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