The PRODUCTS table has three columns, (PID, Description, Price).
Suppose we are going to have a sale and plan to mark down all products we sell by 30%. We could accomplish this by writing: UPDATE PRODUCTS SET Price = Price * 0.70;
However, product 'P003' never goes on sale and must remain at its current price.
Which of the 9 trigger types could you use to ensure that the price of product 'P003' does not change? Describe the logic a trigger solution would need to implement.