Get documents about "COSC 5050 - Distributed Database Applications
Document Sample
2/1/2013 1
Name: ___________________________________
COSC 5050 - Distributed Database Applications
Week 6 Homework
Given the following database table
Employee Table
emp_id lname fname … … other data … salary
23348 Miller Gary … … … … … 30000
38904 Frank Tom … … … … … 15000
41889 Hall Nan … … … … … 21000
45600 Dahl Cory … … … … … 34000
59921 Yount Vic … … … … … 40000
1. Create a PL/SQL update trigger on the employee table that caps the salary increment by
10%.
2/1/2013 2
2. What are the eventual update values for employee.salary for the following PL/SQL
commands?
update employee
set salary = 35000
where emp_id = 23348;
update employee
set salary = 33000
where emp_id = 59921;
2/1/2013 3
3. Create an audit table and implement the audit_deletion trigger logic on slide 20 to record
DML delete action into the audit table (such as action performed, table name, user, and
date).
2/1/2013 4
4. Turn in your project database script files in digital format. The script files should perform
clean creating objects, inserting sample data, and dropping objects.
File Name Actions
For creating objects:
For inserting data:
For dropping objects:
Remaining issues:
