create a trigger named trg_late_return that will write the correct
create a trigger named trg_late_return that will write the correct value to detail_dayslate in the detailrental table whenever a video is returned. the trigger should execute as a before trigger when the detail_returndate or detail_duedate attributes are updated. the trigger should satisfy the following conditions.a. if the return date is null, then the days late should also be null.b. if the return date is not null, then the days late should determine if the video is returned late.c. if the return date is noon of the day after the due date or earlier, then the video is not considered late, and the days late should have a value of zero (0).d. if the return date is past noon of the day after the due date, then the video is considered late so the number of days late must be calculated and stored.
Price Type: Negotiable
Total Proposals: 4
1 Current viewersl
13 Total views
Proposals Reputation Price offered