IS 620 Assignment 5

IS 620 Assignment 5

IS 620 Assignment 5

Suppose you have created tables in assignment 1. Please write PL/SQL program for the following problems. You can use the attached SQL statements to create the tables. However, the insert statements just help you test your code. You cannot assume that the database contains these inserted rows (i.e., your code need to work for any rows inserted in these tables and you cannot hardcode anything).
 

Problem 1: Please create a trigger on review table. This trigger will be fired when a new review is inserted, and print out a message saying that user X entered a new review for Product Y with a review score of Z, where X is the name of user, Y is the name of the product, and Z is the score of review. Please test your triggers. [50 points]
 

Problem 2: Please create a trigger on product table. This trigger will be fired when the product’s price decreases by more than 20%. Please print out a message saying that product X’s price has decreased by Y. Where X is name of product and Y is the percentage of decrease. E.g., if the original price is $100 and the new price is $70, Y=30%. Please test your triggers. 

Please submit your SQL statements as a text file or PDF at blackboard under assignment. You do not need to show screen shot.
 

 
Powered by