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

Write a trigger PENALTY_CALCULATION that is executed after updating the borrow table

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!