Create table with constraint based on another column
I would do this using a trigger on your rental table. Trigger before insert - set the return_date column value to be the rent_date value in the data being saved, plus look up the value of movie.rent_period based on the movie_id value being saved.