Hand in a listing of your programs and scripts showing them working. You should demonstrate that the programs had their intended effect by querying (before and after) some relation of your PDA that was changed by the program. These queries may be included in the file that holds your PL/SQL programs for convenience.
Hand in listings of your code and scripts showing them called at least once each. Also, show in the script the results of queries that demonstrate the functions have had their intended effect.
Here is an example trigger:
CREATE TABLE T1( a INTEGER, b CHAR(10) ); CREATE TABLE T2( c CHAR(10), d INTEGER ); CREATE OR REPLACE TRIGGER Trig AFTER INSERT ON T1 FOR EACH ROW WHEN(new.a <= 10) BEGIN INSERT INTO T2 VALUES(:new.b, :new.a); END Trig; . run;It says: ``whenever there is an insertion into relation T1 with a first component equal to or less than 10, also insert this tuple, reversed, into relation T2.
Hand in your code and a script showing the triggers declared. Also, the script should show, for each trigger, the effect of two database modifications. One modification should trigger the trigger, and the other not. Show in the script queries that demonstrate that the trigger has an effect in the first case and not in the second.