easy · ~8 min
Operations needs an eligibility roster matching employees in employees to the tasks in tasks that they are qualified to pick up.
employees
tasks
(employee, task)
department
skill_level >= min_skill_level
name
task_name
skill_level
min_skill_level
Input contract: emp_id is unique and non-null in employees; task_id is unique and non-null in tasks; all columns are non-null. Multiple employees and multiple tasks can share the same department, and skill_level and min_skill_level are positive integers.
emp_id
task_id