- The university has a small library that provides all teachers and students with learning and reading space. In recent years, with the continuous expansion of the source of transformed students, the size of the library has also increased, and the number of books has also increased accordingly. Various information related to the borrowing of books has doubled.
Faced with such a huge amount of information, it is hard for library managers to support it. As a result, school leaders have decided to set up a set of reasonable and practical book borrowing management software to manage the school’s book borrowing information in a unified and centralized manner.
The lives of people have experienced dramatic change with the popularization of computers and the advancement of information technology. All kinds of computer software have gradually penetrated every corner of society, greatly improving people’s quality of life and improving people’s work efficiency. Book lending in colleges and universities is a very important way for students to acquire knowledge. It is very important to make it easier for students to borrow books and to restore the burden on library management staff to effectively complete book lending management.
- Project Objectives:
Various operations, such as borrowing and querying, can be completed conveniently, quickly and effectively through the development of a library management system. The validity of the input data is high, and the query speed is fast (no more than 5 seconds) to ensure the correct and timely updating of the information and to reduce the cost of access to information, advanced technology and high reliability.
The objective of this project is to facilitate the operation of librarians, reduce the workload of librarians and make it possible for them to manage books in the library more effectively, and to construct information on traditional book management.
The staff of the circulation department of the library is the service object of this system. The user interface is user-friendly, and the system can be used without special computer training.
Build a unified, stable and scalable platform for the information system. Produce timely and transparent project information through the project management platform;
Reduce operational risks. Refine project cost accounting, reduce procurement costs, and perform the analysis function of related procurement processes.
- Project Initialization
The library is an important part of higher learning institutions and an important place for teachers and students to acquire knowledge. Because the library is primarily engaged in the storage and circulation of a large number of books and materials. Computers have, therefore, been widely used in the management of libraries.
There are currently many teachers in this unit, and the use of science and technology books is increasing. The purpose of this system is to ensure the day-to-day management of teacher borrowing of science and technology books, which can be completed quickly, and the purpose of information database management. To meet the needs of the department’s small library business development, solve problems. After investigation and comparison, the school decided to use its strength to build a library management system for the school. Not only can the new system make use of current software development technology and campus network construction results, but it can also facilitate readers’ queries and borrowing operations and solve problems in circulation.
Moreover, it can combine the characteristics of the limited capital investment of the unit and the high demand for books to strengthen the management of the various business links in book management. Therefore, the traditional steps of acceptance, cataloguing, storage, circulation and management are taken when the system is implemented. The aim is to prove that our school can build a borrowing system suitable for administrators and students at a lower cost, saving a lot of time for students and librarians, and borrowing science and technology from students and teachers daily.
- The non-functional analysis of the library management system is as follows:
- Performance requirements:
Data accuracy: Ensure that the rate of retrieval and accuracy of the query is 100 per cent. All records containing the query keyword in the corresponding domain can be found, and all records that do not contain the query keyword in the corresponding domain cannot be found.
System response time: the system response time should be within 1-2 seconds for most operations.
Adaptability: to meet the requirements of the operating environment to allow safe conversion between operating systems and independent operation with other application software.
- Operation requirements:
User interface: The system adopts dialogue box mode and multi-function window operation.
Software interface: running on Windows operating system
Troubleshooting: There is no error during normal use, and appropriate correction prompts are given for user input errors. In the case of unrecoverable system errors, ensure that the database is intact.
- Test environment
You need to install the testing tools and operating conditions when testing the college book recommendation system. Including two aspects, the server side and the client side of the College Book Recommendation System.
To ensure the stability and reliability of the operation of the system, the system needs to be tested at the final stage of the development of software engineering. Potential system problems can be identified through the test, and these problems can be reported to the development department. The system can be started after the BUG has been fixed.
There are also many test methods, the most common of which are the function test and performance test. There are also many test tools available on the market. It is generally necessary to write test cases and use case documents for effective testing before using the test tool.
If no problems are identified during the test, this is not a waste of time. The thoroughness of the development can be seen through the test cases, and it is also necessary to provide users with full development documentation.
- Test process
The following sets out some functional test cases for the college book borrowing recommendation system. Users log in to the College Book Recommendation Borrowing System and can log in only after entering the valid information.
The test process is shown in table 5.1:
Table 5.1 Test results of the login function:
| Work preparation | Expected result | Test steps | Test conclusion |
| Username input：。。 Password input： | can not log in | Enter。。in the user name and password text box, click login, and prompt failure. | |
| Enter 。。 in the user name and password text box, click login, and prompt failure. | |||
| login successful | Enter 。。 in the user name and password text box, click login, and prompt success. |
The administrator enters the category information, saves the category information in the database, and then modifies the category in the list of categories. The database records are also modified successfully. The process of the category management test is shown in 5.2:
Table 5.2 Category management test results
| Work preparation | Expected result | Test steps | Test conclusion |
| Basic information of the category, such as category name, remarks and other information. | Category submitted to the database. | Enter the basic information of the category entry interface, click Add, and it will prompt success. Open the database and check the category information table to see if any data has been entered. | |
| In the category management link, click category management. | Show all categories | Enter the query criteria and check that the list has all the category information that meets the criteria. | |
| In the category list, click Edit | Successfully modified | On the modification page, enter the basic information of the category, click modify, and prompt success. Open the database and check the category information table to see if the data has been modified successfully. | |
| In the category list, click Delete | successfully deleted | On the delete page, click OK to delete, indicating success. Open the database and check the category information table to see if the data has been deleted successfully. |
The administrator enters the book information, saves the book information in the database, and then modifies the book in the book list, and the records in the database are also modified successfully. The book management test process is shown in 5.3:
Table 5.3 Book management test results
| Work preparation | Expected result | Test steps | Test conclusion |
| Submit the book to the database | Submit the book to the database | Enter the basic information of the book on the book-entry interface, click Add, and it will lead to success. Open the database and check the information table of the book to see if any data has been entered. | |
| In the library management link, click Book Management. | Show all books | Enter the query conditions and check whether the list has all the book information that meets the conditions. | |
| In the book list, click Edit | Successfully modified | On the modification page, enter the basic information of the book, click modify, and prompt success. Open the database and check the book information table to see if the data has been modified successfully. | |
| In the book list, click Delete | successfully deleted | On the delete page, click OK to delete, indicating success. Open the database and check the book information table to see if the data is successfully deleted. |
The administrator enters the borrowing information, saves the borrowing information in the database, and then modifies the borrowing information in the borrowing list. The database records are also modified successfully. The borrowing management test process is shown in 5.4:
Table 5.4 Test Results of Borrowing Management
| Work preparation | Expected result | Test steps | Test conclusion |
| Basic information of borrowing, such as borrowing books, readers, quantity, date, remarks and other information. | Submit the loan application to the database | On the borrowing entry interface, enter the basic borrowing information, and click Add to prompt success. Open the database and check the borrowing information table to see if there is any entered data. | |
| In the borrowing management link, click Borrowing Management. | Show all borrowing applications. | Enter the query conditions and check whether the list has all the qualified borrowing information. | |
| In the borrowing list, click Edit | Successfully modified | On the modification page, enter the basic borrowing information, click modify, and it will prompt success. Open the database and check the borrowing information table to see if the data has been modified successfully. | |
| In the borrowing list, click Delete | successfully deleted | On the delete page, click OK to delete, indicating success. Open the database and check the borrowing information table to see if the data is successfully deleted. |
- Test summary
This chapter is divided into three summaries, first introduces the test environment, then performs the performance test and describes the test function. Testing, discovering and correcting problems is an important process. You can use the testing tool to perform system testing and functional testing in the testing process.
During the testing process, the bugs encountered need to be modified in time, and a test document is created to explain the conditions of the testing and modification process. Software testing includes testing the black box and testing the white box. Different test methods have different testing purposes. The test objectives are completed by detailed testing of the college book borrowing recommendation system.