CSE2/4DBF Assignment 2 Task 3

Get Expert's Help on Assessment

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%]

 

Expert's Answer

Ask a New Question
*
*
*
*
*

Plagiarism Checker

Submit your documents and get Plagiarism report
Check Plagiarism

Chat with our Experts

Want to contact us directly? No Problem. We are always here for you

TOP

Connect on WHATSAPP: +61-416-195006, Uninterrupted Access 24x7, 100% Confidential

X