크로우풋
테이블 (5)
department (부서)
- PK (dept_name) — 기본 키 — NOT NULL
- (dept_phone)
employee (직원)
- PK (emp_id) — 외래 키 → department.PK — NOT NULL
- (emp_name)
- FK (dept_name) — NOT NULL
manager (관리자)
- PK (manager_name) — 기본 키 — NOT NULL
- (manager_phone)
project (프로젝트)
- PK (project_id) — 외래 키 → manager.PK — NOT NULL
- (project_name)
- FK (manager_name) — NOT NULL
work (근무기록)
- PK,FK (emp_id) — 외래 키 → employee.PK — NOT NULL
- PK,FK (project_id) — 외래 키 → project.PK — NOT NULL
- (hours)