Book storage, book deletion and book change = > book file table

User registration and user login = > reader list

Book borrowing and returning = > book borrowing list, book returning list

Main fields of each table:

Book file table:

Book number, title, category, author, publisher, price, page number, bookshelf and book barcode. ...

Reader list:

Reader number, name, type, occupation, e-mail, telephone number, ID number, valid ID, library card barcode, ...

Book borrowing form:

Number, reader number, book number, borrowing time, return time, whether it has been returned, and operator ...

Book return form:

Number, reader number, book number, return time, operator ...

If it is only a basic function, the above fields should be enough. If you need more advanced functions, please add them yourself. Finally, when creating a database and programming, we should pay attention to the set association relationship between tables ~