Trigger in MySQL for movie rentals? [closed]

2

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.

    
asked by anonymous 30.11.2015 / 18:55

0 answers