Solutions:
Check these solutions from our community and artificial intelligence:
The trigger above is a good solution that solves the problem. It is efficient because it only updates the department table when the employee table is updated.