크로우풋

테이블 (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)