exercise 3
Tables (5)
AGENCY (Untitled3)
- description (Field) — char(40)
- provider identifier (Key) — char(13) — Foreign key → SERVICEPROVIDER.provider identifier — NOT NULL
- service identifier (Key22) — char(10) — Foreign key — NOT NULL
CLIENT (Untitled)
- SecurityNumber (Key) — char(13) — Primary key — NOT NULL
- service identifier (Key2) — char(10) — Foreign key → SERVICE.service identifier — NOT NULL
- name (Field) — char(15)
- address (Field2) — char(40)
- PhoneNumber (Field3) — char(12)
FAMILY (Untitled4)
- FamilyID (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) — char(10) — Foreign key → CLIENT.service identifier — NOT NULL
SERVICE (Untitled5)
- service identifier (Key) — char(10) — Primary key — NOT NULL
- description (Field) — char(40)
- service Data (Field2) — char(10)
- SecurityNumber (Key2) — char(13) — Foreign key → CLIENT.SecurityNumber — NOT NULL
SERVICEPROVIDER (Untitled2)
- provider identifier (Key) — char(13) — Primary key — NOT NULL
- name (Field) — char(15)
- address (Field2) — char(40)
- phone Number (Field3) — char(12)