DBMS

10B.

68 Code an Oracle trigger to enforce the constraint that an employee can never change

his or her department.

10B.

69 Code an Oracle trigger to allow the deletion of a department if it has only one employee.

Assign the last employee to the Human Resources department.

10B.

70 Design a system of triggers to enforce the M-M relationship. Use Figure 10B-91 as

an example, but assume that departments with only one employee can be deleted.

Assign the last employee in a department to Human Resources.