Do you have a library card or a library card? If you do, it will be much easier.

1. Make a book file first (title, publisher, price, quantity, publication date).

2. Library card information (ID number, name, gender, address, contact number, ID number)

3. Book borrowing (date, serial number, borrowing ID, borrowing information)

4. Book return (date, serial number, book borrowing ID, returned book information)

5. Statistical query table (the borrowing rate of books during the query period, and the ranking of the borrowing quantity of book ID in the same period).