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.

Related
Recommended