1. Find the borrowing record of the returned book by the book number or library card number or the borrower's ID number; Fill in the date of book return, calculate the number of days to borrow books and rent. If it is a small library, it is only necessary to establish a book borrowing and returning table: the fields of this table are: book number, borrower number (or library card number), borrowing date, borrowing registration manager number, book returning date, borrowing days, rent or rent receipt number, and book returning registration manager or manager number.

Fill in the first four columns when borrowing books and the last four columns when returning books.

Mainly depends on the size of the library. If the scale is large, there are many people and there are member clubs, you should have the following basic information table: 1, personnel list; 2. Membership list; 3. Book rental charging standard; 4. Book status table On the other hand, the scale is small, and this information should not be stored in a special table.

2. Add a field to the book status table (generally, add a field to all book tables: book current status: byte type, 0: in the library; 1: Borrow) The current status of the book is rewritten as 0; When the status of this book is rewritten, this book can appear in the loanable catalogue.