Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer

Exercise 27

If you have not already installed MySQL 5.6 (or do not otherwise have it available to you), you need to install a version of it at this point. Write SQL statements to accomplish the following tasks, and save your work as *.sql scripts, as appropriate. Run your *.sql scripts in MySQL by using the MySQL Workbench.
In the Chapter 7 Review Questions, we introduced the Wedgewood Pacific Corporation (WPC) and developed the WPC database. Two of the tables that are used in the WPC database are:
DEPARTMENT (DepartmentName, BudgetCode, OfficeNumber, Phone)
EMPLOYEE (EmployeeNumber, FirstName, LastName, Department, Phone, Email)
Assume that the relationship between these tables is M-M, and use them as the basis for your answers to Review Questions .
NOTE: To run these project questions in an actual database, create a copy of the WPC database named WPC-CH10C-PQ with ONLY these two tables. This is necessary to simplify the foreign key constraints that we'll have to deal with- recall that EMPLOYEE and DEPARTMENT are also linked to PROJECT and ASSIGNMENT.
This will be simple for your students if they created SQL scripts as suggested in the text. If not, they will have to step through the entire database recreation-which should be a good lesson in WHY they should create, use and save SQL scripts!
-If possible, code a MySQL trigger to enforce the constraint that an employee can never change his or her department. If it is not possible to use a MySQL trigger, explain why and code a stored procedure in its place.