Exe3

Tables (5)

CLIENT (Untitled2)

  • name (Key) — char(15) — Primary key — NOT NULL
  • ssn (Field) — char(15)
  • age (Field2) — char(3)
  • address (Field3) — char(50)
  • phone (Field4) — char(10)

DEPENDENT (Untitled5)

  • ssn (Key) — char(15) — Primary key — NOT NULL
  • name (Field) — char(15)
  • age (Field2) — char(3)
  • name (Key2) — char(15) — Foreign key → CLIENT.name — NOT NULL

ENROLL (Untitled3)

  • serviceID (Key) — integer — Foreign key → SERVICE.serviceID — NOT NULL
  • name (Key2) — char(15) — Foreign key → CLIENT.name — NOT NULL

ORGANIZATION (Untitled4)

  • orgcode (Key) — integer — Primary key — NOT NULL
  • name (Field) — char(15)

SERVICE (Untitled)

  • serviceID (Key) — integer — Primary key — NOT NULL
  • date (Field) — char(14)
  • description (Field2) — text
  • orgcode (Key2) — integer — Foreign key → ORGANIZATION.orgcode — NOT NULL