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