3. 1 development and design ideas

Try to adopt the existing software and hardware environment and advanced management system development scheme of the school, make full use of the existing resources of the school, and improve the application effect of the system development level. According to the regulations of book management, the daily management and use of books by managers and students are satisfied. The system adopts top-down menu design method, which is convenient for various combinations and modifications of system functions and for technical maintenance personnel to supplement and maintain. The system should have the function of database maintenance, and add, query, modify and count data in time according to the needs of users. The system maintains a database, which saves the information of books and readers and the information of book circulation, which is convenient for administrators to manage the relevant data of books and readers, and can also query and count the data at any time as needed and output it in the required format and manner.

3.2 Selection of development, operation environment and platform mode

Development tools

Chinese version of Visual FoxPro6.0. Visual FoxPro is a desktop database system developed by Microsoft, which is considered as one of the most widely used microcomputer database management systems in today's society. It is an important front-end development tool of C/S (client/server) structure for computer specialty. Although this database system is relatively small, it is powerful and efficient, and can meet the needs of system application. Therefore, this system adopts Microsoft Visual FoxPro6.0 as the database system.

Runtime environment

Windows9x, Windows NT, Windows XP or Windows2000 operating system.

Platform mode

The mode adopted by the system is single-machine database mode. The reason is that considering the cost, the functions that the system needs to realize are data addition, modification, query and statistics, so the cost is reduced; Secondly, the security of the system can be improved by adopting the single-machine database mode; Finally, considering the specific functions, the service object of this system is educational institutions, and its main function is to collect and archive data, so there is no need to adopt complicated modes to realize this system.

3.3 System Function Analysis

3.3. 1 task analysis This system is mainly used for the library management of school teachers and students. The main task is to improve the management of school book entry, borrowing and reader information by establishing a book management system. Through the query, you can immediately locate the corresponding information of readers, and you can query, add and modify books. Readers can borrow books by appointment. This system is designed to solve these problems. 3.3.2 Functional Analysis Through the establishment of a book management system, the daily management of the library, such as book management, reader management and book borrowing management, is managed by computers in a unified way, thus improving work efficiency and management level. These management include:

1. Management of basic information of books, including addition, modification, inquiry and reservation management;

2. Management of readers' basic information, including addition, modification and query management;

3. Book lending management, including adding, querying and statistical management;

4, system management, mainly to increase users, maintain user information and exit the system. 3.3.3 Functional Requirements When designing a system, it is necessary to find out what functions it can realize, and then analyze what elements are needed according to the specific functions to be realized, and then make corresponding interfaces after understanding these contents. Through the above functional analysis, the system should complete the following functional requirements.

1, administrators and student users have different permissions after logging in. Administrators have full permissions to manage and query, while student users only have query permissions.

2. Book management function, used to input and modify book records.

3. Book loan function, which is used to manage loan book information and make statistics on loan records.

4. The reader service function is used to input and modify readers' records and information.

5. The book service function is mainly used for book inquiry and loan return.

6. System management is mainly used for user registration and password modification. 3.4 System function module design According to the system function analysis, five main management modules are planned and designed: book management module, book lending module, reader information module, book service module and system management module. As shown in Figure 3- 1:

Figure 3- 1 Schematic diagram of main module 3.4. 1 Library management module This module is mainly used to input and modify basic information of books. Book input is used to input the book information for the first time, quickly locate the book after entering the book title, and then display the book information to be modified, and display the previous page and the next page information. The function of this module is shown in Figure 3-2.

Figure 3-2 Schematic Diagram of Library Management Module

3.4.2 Book lending management module This module can input reader information and book information to be borrowed, and can add, re-fill and locate the previous article and the next article; Display the borrowing records, including the basic information of the borrower and the basic information of the borrowed books; Borrowing query and statistics can conveniently count and analyze the borrowing situation of books within a certain time range, and can be queried according to different conditions. The function of this module is shown in Figure 3-3.

3-3 Schematic Diagram of Book Lending Management Module

3.4.3 Reader Management Module This module can register the readers who log in for the first time, number the readers and input the basic information of the readers; When modifying the reader information, quickly locate the reader number, modify it after finding the reader information, and the previous item and the next item will be displayed. The function of this module is shown in Figure 3-4.

Figure 3-4 Schematic Diagram of Reader Management Module

3.4.4 Reader service module This module can facilitate readers to borrow, consult and reserve books. When querying, they can query according to different query methods, and display whether the book can be borrowed after finding the book they need, that is, the current state of the book. If yes, please enter the number of days to borrow. When returning the book, you can also quickly locate it by number. After displaying the information such as the book number, the administrator can return the book after operation. The function of this module is shown in Figure 3-5.

Figure 3-5 Schematic Diagram of Reader Service Module

3.4.5 System Management Module This module mainly realizes the function of managing user registration. After the administrator registers the account, he can log in to the system by entering the correct password information, and the administrator can maintain the system. You can also change the password. The function of this module is shown in Figure 3-6.

Figure 3-6 System Management Schematic Diagram

3.5 Database design

3.5. 1 database requirements analysis

In order to meet the needs of ordinary users, the following data flow chart is drawn for the system. As shown in Figure 3-7:

3.5.2 Database logical design According to the requirements of system functional design and the division of functional modules, the database table structure is designed as follows:

Table 3- 1: Book Entry Information Table

Table 3-2: Book Borrowing Information Table

Table 3-3 Reader Information Table

Table 3-4: Borrowing Information Table

Table 3-5: System User Information Table