CSE2/4DBF Assignment 2 Task 3

Task 3 [15 marks]

Provide the implementation of the following trigger. For submission, please include both the PL/SQL code and an insert statement to demonstrate the trigger functionality.
a. A Trigger which automatically stores in a separate table called ‘Excellent Sale’ the Sales Agent name, car model and manufacturer name, each time the agreed price of a Sales Transaction is more than 20% above the car’s asking price. (Note: You need to create the ‘Excellent Sale’ table before implementing this trigger. To create the primary key, use a sequence that starts at 1 and increments by 1).                 [15 marks – 15%]