I need a little help because the teacher said that it is not to use FUNCTIONS
and PROCEDURES
, ONLY TRIGGER
. Follow the picture of what he's asking for. I really can not do it. For me it had to exist before a% w_% where it checks if the ID of the inserted movie is in the rental table and check the return date from that. If it is greater than FUNCTION
you can rent, otherwise the 0000-00-00
returns message warning that the movie is rented.