create a trigger named trg_late_return that will write the correct

Project Description:

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.
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 4
1 Current viewersl
13 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.3
    309 Jobs 189 Reviews
    $0 in 0 Day
  • 4.9
    95 Jobs 45 Reviews
    $0 in 0 Day
  • 4.5
    355 Jobs 236 Reviews
    $60 in 0 Day