MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table loan_table(
    id int primary key auto_increment,
    book_id int,
    student_id int,
    loan_date date,
    loan_duration int,
    return_date date as (date_add(loan_date, interval loan_duration day)) stored
)
insert into loan_table(book_id, student_id, loan_date, loan_duration)
values(1, 1, '2019-11-02', 3)
select * from loan_table;


id
book_id
student_id
loan_date
loan_duration
return_date


1
1
1
2019-11-02
3
2019-11-05