Call Now: (+61) 416-195-006
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%]
Want to contact us directly? No Problem. We are always here for you