Trigger to enforce constraint that a department has only one department head

9 Views Asked by At

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

0

There are 0 best solutions below