The schema only allows one employee per department, so there is no need to look up the employee table.