prompt 식별관계테스트

테이블 (6)

Dept

  • Dept_id — 기본 키 — NOT NULL
  • Dept_name

Emp_Proj

  • Emp_Proj_id — 기본 키 — NOT NULL
  • Role_id — 외래 키 → Role.Role_id — NOT NULL
  • part_start_date
  • part_end_date
  • Employee_number — 외래 키 → Employee.Employee_number — NOT NULL
  • Project_id — 외래 키 → Project.Project_id — NOT NULL

Employee

  • Employee_number — 기본 키 — NOT NULL
  • emp_name
  • emp_resident_number
  • emp_final_edu
  • skill
  • career
  • emp_ID
  • emp_PW

Manager

  • Manager_id — 기본 키 — NOT NULL
  • Employee_number — 외래 키 → Employee.Employee_number — NOT NULL
  • manager_position

Project

  • Project_id — 기본 키 — NOT NULL
  • project_name
  • start_date
  • end_date
  • budget
  • project_organization

Role

  • Role_id — 기본 키 — NOT NULL
  • Role_name