Download Solution: Click to Download Solution
Solution File Name: Task3_12AAA.doc
Unzip Password: prestobear.com
a. A Trigger which automatically stores in a separate table called ‘ExcellentSale’ the Sales Agent name, car model and manufacturer name, each time the agreed price of a SalesTransaction is more than 20% of the car’s asking price.
b. A Trigger that is activated when a new UserAccount is accidentally associated with a non-VIP Customer.