ex.3

Tables (4)

Locserv. (Untitled2)

  • Family (Key) — char(4) — Primary key — NOT NULL
  • Family2 (Key2) — char(4) — Primary key — NOT NULL
  • SSN (Key3) — char(13) — Primary key — NOT NULL

Staterepr. (Untitled3)

  • SSN (Key) — char(13) — Primary key — NOT NULL
  • jobtraining (Field) — char(20)
  • serv.exp (Field2) — char(50)
  • SSN (Key2) — char(13) — Foreign key → customer.SSN — NOT NULL
  • Family (Key3) — char(4) — Foreign key → Locserv..Family — NOT NULL
  • Family2 (Key22) — char(4) — Foreign key → Locserv..Family2 — NOT NULL
  • SSN (Key32) — char(13) — Foreign key → Locserv..SSN — NOT NULL

customer (Untitled)

  • SSN (Key) — char(13) — Primary key — NOT NULL
  • Name (Field) — char(4)
  • age (Field2) — int(3)
  • Family2 (Field3) — char(4)
  • Family (Field4) — char(4)
  • Family (Key2) — char(4) — Foreign key → Locserv..Family — NOT NULL
  • Family2 (Key22) — char(4) — Foreign key → Locserv..Family2 — NOT NULL
  • SSN (Key3) — char(13) — Foreign key → Locserv..SSN — NOT NULL

priv.serv. (Untitled4)

  • SSN (Key) — char(13) — Primary key — NOT NULL
  • jobtraining (Field) — char(20)
  • serv.exp (Field2) — char(50)
  • SSN (Key2) — char(13) — Foreign key → customer.SSN — NOT NULL
  • Family (Key3) — char(4) — Foreign key → Locserv..Family — NOT NULL
  • Family2 (Key22) — char(4) — Foreign key → Locserv..Family2 — NOT NULL
  • SSN (Key32) — char(13) — Foreign key → Locserv..SSN — NOT NULL