모델링예제(슬라이드20,21)
테이블 (7)
DEPENTDNET
- Key (dependentID) — char(10) — 기본 키 — NOT NULL
- Field (name) — cahe(30)
- Field (gender) — cahr(1)
- Field (birthDate) — date
- Field (relation) — char(10)
- (employeeSsn) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL
EMPLOYEE
- (ssn) — char(13) — 기본 키 — NOT NULL
- (name) — char(30)
- (address) — char(30)
- (email) — email
- (phone) — char(12)
- (departmentID) — char(10) — 외래 키 → WORKSFOR.departmentID — NOT NULL
- Key (dependentID) — char(10) — 외래 키 → DEPENTDNET.Key — NOT NULL
LOCATION
- Key (locationID) — char(10) — 기본 키 — NOT NULL
- Field (locationName) — char(20)
- Field (description) — longtext
PROJECT
- (projectID) — char(20) — 기본 키 — NOT NULL
- (name) — char(30)
- (description) — longtext
- (departmentID) — char(10) — 외래 키 → WORKSFOR.departmentID — NOT NULL
Untitled (DEPARTMENT_LOCATION)
- (departmentID) — char(10) — 외래 키 → WORKSFOR.departmentID — NOT NULL
- Key (locationID) — char(10) — 외래 키 → LOCATION.Key — NOT NULL
- Field (name) — char(30)
WORKSFOR (DEPARTMENT)
- (departmentID) — char(10) — 기본 키 — NOT NULL
- (name) — char(20)
- (phone) — char(20)
- (Field3) — email
- (Field4) — char(10)
- (startMangeDate) — date
- (location) — char(30)
- (ssn) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL
Works on (WORKSON)
- (ssn) — char(13) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- (projectID) — char(20) — 외래 키 → PROJECT.projectID — NOT NULL
- Field (hour) — float