ERD Exercise 3
Tables (5)
AGENCY (Untitled6)
- description (Field) — char(40)
- provider Identi fier (Key2) — char(13) — Foreign key → SERVICEPROVIDER.provider Identi fier — NOT NULL
- Service Identifier (Key3) — cbar(10) — Foreign key → SERVICE.Service Identifier — NOT NULL
CLIENT (Untitled)
- SecurityNumber (Key) — char(13) — Primary key — NOT NULL
- Service Identifier (Key2) — cbar(10) — Foreign key → SERVICE.Service Identifier — NOT NULL
- name (Field) — char(15)
- adress (Field2) — char(40)
- PhoneNumber (Field3) — cbar(12)
DEPENDENT (Untitled3)
- ssn (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) — cbar(10) — Foreign key → CLIENT.Service Identifier — NOT NULL
SERVICE (Untitled4)
- Service Identifier (Key) — cbar(10) — Primary key — NOT NULL
- description (Field) — char(40)
- service Date (Field2) — char(10)
- SecurityNumber (Key2) — char(13) — Foreign key → CLIENT.SecurityNumber — NOT NULL
SERVICEPROVIDER (Untitled5)
- provider Identi fier (Key) — char(13) — Primary key — NOT NULL
- name (Field) — char(15)
- address (Field2) — char(40)
- phone Number (Field3) — char(12)