Create table Department Department: deptID(PK), deptName, chairID

Insert 4 values into Department table

Each department has exactly one chair

Check what happens with department chair when you delete employee from the Employee table. Do you see a problem?

Write a trigger to fix this problem. You have to raise application error when someone tries to delete employee who is listed as a department chair in the department table. It can be achieved several different ways, but for this exercise, you will use a trigger.

Create at least four test cases to test the solution.

Steps:

1. Write SQL code to create table

2. Write SQL code to insert values in table.

3. Write Trigger code

4. Create Test cases and check trigger execution results.

Create at least four test cases to test the solution.

Please use Adventure works database or create a new database