Create table Product in Oracle. The table must have at least four columns ProductID, ListPrice, StandardCost and ProductDescription. It must also have at least 10 rows.

Your assignment is to create the Product_Price_Check trigger that fires on the update of ListPrice column. The trigger should not allow a new list price be less than StandardCost + 20%. This trigger should allow any price increase.

You have to test your trigger and provide screenshots to prove that it works correctly:

1. • correctly discards changes if price is too low

   • correctly changes the price if price is not low

You have to provide the trigger code, code you used to create the table and insert records. (2 points)

You should have only one trigger that will work for both updates correctly

update Product set ListPrice=42 where ProductID=112;

2 points

and

update Product set ListPrice=61;

6 points (2 points for each test case)

The second update statement should update price only for products with standartcost below $50 (because $50.83 * 1.2 = $61), for all other products the price change should be ignored. In your report show price changes as a result of the trigger. Test your trigger thoroughly. Note: The use of raise application error will prevent the second query from updating allowed prices. Check PL/SQL Trigger Example 1 to see how to prevent price change.

Sample output:

select * from product; set serveroutput on; update product set listprice=99 where productid - 514; Script Output * Query Result x O S Task completed in 0 seconds 1 rows updated. the price can't be below 118.524 the price stays 98.77