Just because someone leaves the company, a product is discontinued, or other situations that may occur we almost never wish to delete the data completely from a database. On the Production.Product table create a trigger such that when someone deletes a product from the product table, the product is not actually deleted. Instead, we wish to set DiscontinuedDate to the current date.

3a) What is the SQL to define this trigger?

3b) Provide example SQL that will cause your trigger to fire.

he general form of a trigger is