assignment7

assignment7 - employee changes his or her manager, and...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
IS 620 Assignment 7 Due 4/7 Suppose you have created tables in assignment 1 (listed in textbook page 116 Figure 3.12, and also listed below). Employee(employee_name, street, city) Works(employee_name, company_name, salary) Company(company_name, city) Manages(employee_name, manager_name) Problem 1: Please create a trigger on manages table. This trigger will be fired when an
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: employee changes his or her manager, and print out a message saying the employee has changed manager. Please print out the employee name, old manager name, and new manager name. [100 points] Please submit print-out of code....
View Full Document

Ask a homework question - tutors are online