Exam-JBGW08-023
Tables (4)
Department
- department_id — VARCHAR(255) — Primary key — NOT NULL
- department_name — VARCHAR(255)
DepartmentEmployee
- department_id — VARCHAR(255) — Foreign key → Department.department_id — NOT NULL
- employee_id — VARCHAR(255) — Foreign key → Employee.employee_id — NOT NULL
DepartmentEmployee_Pk
- employee_id — VARCHAR(255) — Foreign key → Employee.employee_id — NOT NULL
- department_id — VARCHAR(255) — Foreign key → Department.department_id — NOT NULL
Employee
- employee_id — VARCHAR(255) — Primary key — NOT NULL
- employee_name — VARCHAR(255)