Problem
Write stored procedure that implements the processing when a DVD is returned in the mail from a customer and the next DVD is sent out. This processing should include recording that the DVD has been returned and should also determine the number of additional DVDs that should be mailed to the customer.
It needs to account for the following:
• Update all the DVD quantities accordingly both on rental and return.
• Customer returns a DVD or notes the DVD is lost in which case they are charged against their account.