Suppose I have following schema :
DEPARTMENT ( idDepartment, DepartmentName)
EMPLOYEE (idEmployee, FirstName, LastName, idDepartment, Phone, Email)
How to write a trigger so that a department can only have 1 employee as the department head when updating or adding a new employee table