ERD Exercise 3

Tables (5)

Client (Untitled)

  • ssn (Key) — CHAR(30) — Primary key — NOT NULL
  • service_code (Key2) — ist(30) — Foreign key → Service.code — NOT NULL
  • name (Field) — CHAR(30)
  • address (Field2) — CHAR(30)
  • number (Field3) — CHAR(30)

Dependant (Untitled2)

  • ssn (Key) — CHAR(30) — Foreign key → Client.ssn — NOT NULL
  • service_code (Key2) — ist(30) — Foreign key → Client.service_code — NOT NULL
  • dependantssn (Field) — CHAR(30)
  • name (Field2) — CHAR(30)
  • age (Field3) — int(10)
  • Field4

Government (Untitled4)

  • service (Key) — CHAR(30) — Primary key — NOT NULL

Service (Untitled3)

  • code (Key) — ist(30) — Primary key — NOT NULL
  • client ssn (Key2) — CHAR(30) — Foreign key → Client.ssn — NOT NULL
  • code (Key22) — ist(30) — Foreign key → Client.service_code — NOT NULL
  • information (Field) — CHAR(80)
  • date (Field2) — date
  • service (Key3) — CHAR(30) — Foreign key → Government.service — NOT NULL

ServiceProductor (Untitled5)

  • id (Key) — CHAR(30) — Primary key — NOT NULL
  • name (Field) — CHAR(30)
  • address (Field2) — CHAR(30)
  • call (Field3) — int(10)
  • code (Key2) — ist(30) — Foreign key → Service.code — NOT NULL
  • ssn (Key22) — CHAR(30) — Foreign key → Service.client ssn — NOT NULL