Suppose we are going to have a sale and plan to mark down


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.

Request for Solution File

Ask an Expert for Answer!!
Computer Engineering: Suppose we are going to have a sale and plan to mark down
Reference No:- TGS02899716

Expected delivery within 24 Hours