Project

Tables (3)

Department

  • dept_code — VARCHAR(20) — Primary key
  • dept_name — VARCHAR(50)

Employee

  • emp_id — VARCHAR(20) — Primary key
  • emp_name — VARCHAR(50)

EmployeeDepartment

  • emp_id — VARCHAR(20) — Primary key
  • dept_code — VARCHAR(20) — Primary key
  • emp_id (emp_id2) — VARCHAR(20) — Foreign key → Employee.emp_id
  • dept_code (dept_code2) — VARCHAR(20) — Foreign key → Department.dept_code