I need to create Master Library

I have two tables one is book master contains id,name,author name, Isbn no, price, copies and other is Subscriber master contains id,subscriber name, and address.

Now I need to show Transaction details like checkin, checkout details of bookId, subscriber Id, Transaction date, date to be trurned.


How can I do this anyone, please help me how to do the transaction table to show the nentioned details...


Thanks in advance.