Question: Write a trigger PENALTY_CALCULATION that is executed after updating the borrow table by setting the value of actual_return_date when a borrower comes to the front
Write a trigger PENALTY_CALCULATION that is executed after updating the borrow table by setting the value of actual_return_date when a borrower comes to the front desk of the library to return a book. The penalty must be calculated based on the above-mentioned business rules in Question 3. [Hints: To get the number of days between two dates: date2 and date1, you may use the following query. select ceil(date2-date1) from table1; sysdate will return the current date.]

membe rid Borrow borrow id 1001 1002 1001 M-1 M-2 M-1 book id B-1 B-2 B-2 borrow scheduled r actual_ret penalty date eturn date urn date 01/Nov/19 08/Nov/19 10/Nov/19 100 01/Nov/19 01/Dec/19 10/Nov/19 | 17/Nov/19
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
