exercise 3
Tables (5)
customer (Untitled)
- ssn (Key) — char(13) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(30)
- phone (Field3) — char(11)
day (Untitled5)
- day (Key) — Primary key — NOT NULL
- ssn (Key2) — char(13) — Foreign key → customer.ssn — NOT NULL
- code (Key3) — char(10) — Foreign key → service.code — NOT NULL
dependent (Untitled2)
- ssn (Key) — char(13) — Primary key — NOT NULL
- name (Field) — char(10)
- birthdate (Field2) — char(8)
- code (Key2) — char(10) — Foreign key → service.code — NOT NULL
service (Untitled4)
- code (Key) — char(10) — Primary key — NOT NULL
- description (Field) — char(100)
service provider (Untitled3)
- uni no (Key) — char(20) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(30)
- phone (Field3) — char(11)
- Field4
- ssn (Key2) — char(13) — Foreign key → customer.ssn — NOT NULL