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)