ERD 연습문제 3
테이블 (5)
Customer
- Key (cSsn) — char(30) — 기본 키 — NOT NULL
- Field (cName) — char(5)
- Field (cAddress) — char(20)
- Field (cPhone) — char(15)
Untitled (Family)
- Key (fSsn) — char(30) — 기본 키 — NOT NULL
- Field (fName) — char(5)
- Field (fAddress) — char(20)
- Field (fPhone) — char(15)
- Field (fAge) — integer(3)
- Key (cSsn) — char(30) — 외래 키 → Customer.Key — NOT NULL
Untitled (Service)
- Key (sCode) — char(20) — 기본 키 — NOT NULL
- Field (sDescription) — text
- Field (sName) — char(30)
Untitled (ServiceProvider)
- Key (spNo) — char(30) — 기본 키 — NOT NULL
- Field (spName) — char(5)
- Field (spAddress) — char(20)
- Field (spPhone) — char(15)
- Key (sCode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Customer_Service)
- Key (cSsn) — char(30) — 외래 키 → Customer.Key — NOT NULL
- Key (sCode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (servicedate) — date
- Key (spNo) — char(30) — 외래 키 → Untitled.Key — NOT NULL