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