For some reason, I am just having trouble with the concept of triggers, and advice would be greatly appreciated. Use that the relationship between the following tables is M-M, and use the tables as the basis for answering questions 10B.53 through 10B.55. Also assume code is for Oracle 11g version 2.
DEPARTMENT (DepartmentName(PK), BudgetCode, OfficeNumber, Phone)
EMPLOYEE (EmployeeNumber(PK), FirstName, LastName, Department, Phone, Email)
10B.53 Code an Oracle trigger to enforce the constraint that an employee can never change his or her department.
10B.54 Code an Oracle trigger to allow the deletion of a department if it only has one employee. Assign the last employee to the Human Resources department.
10B.55 Design a system of triggers to enforce the M-M relationship. Use Figure 10B-59 as an example, but assume that departments with only one employee can be deleted.
Assign the last employee in a department to Human Resources.