Based on the systematic analysis of the library management information system, this paper gives a detailed business description and data flow chart, and designs the system. To reiterate, this system is specially used to manage the school library.

I. Module design

(a), the book archiving module:

This module corresponds to the business process of book archiving, and the book information to be input has been reflected in the first part of the homework, so I won't repeat it here. After the information is input, it is classified and processed to form a book archive database, which can be used for user query, module call and data statistics.

(ii) Member registration module

Corresponding to the membership registration process, members' basic information and membership rights form a member file database, which can be used for user query, module call and data statistics.

(3), loan processing module

This module corresponds to the book lending process. This process can include the following five businesses: inquiry, reservation, borrowing, book return and renewal.

It can be divided into the following five modules.

1, loan processing module.

Corresponding to the book borrowing business, this business is handled outside the book, and the staff scans the bar code of the library card to check the user's borrowing authority. When users have arrears records, they are required to pay a fine before borrowing books; After confirming that the user can borrow books without arrears records, scan the book bar code to go through the borrowing procedures. After the borrowing is completed, the computer system will update and store the user's borrowing information and book borrowing information for future query.

2. Book return processing module

Corresponding to the book return processing flow, when the book is lent out and the user returns the book, the staff scans the book bar code to return the book. After completion, the computer system updates and stores the user's borrowing information and book borrowing information for reference. When the book is lost, ask the reader for compensation.

3. Query processing module

The corresponding query processing flow is carried out in the client server and operated by the readers themselves. After the reader inputs certain query information, the client server submits it to the server, searches for a match in the database, and outputs the query result. Can be called circularly.

4. Appointment processing module

The corresponding reservation processing flow is executed in the client server and operated by the reader.

5. Update the processing module

The corresponding update processing flow is executed on the client server and operated by the reader.

Second, code design.

Coding used in this system: the library card number is the student number, and each library card has a corresponding unique bar code; The call numbers are arranged according to China Library Classification, and each book has its own unique bar code.

Thirdly, the design of input, output and man-machine dialogue.

1, input design:

In the process of filing books, all kinds of book information are input by the staff, and then input into the computer through the keyboard for storage. In the process of keyboard input, the computer checks data type, format and logic, and immediately prompts errors.

In the process of membership registration, the membership information is first filled in by the member himself, and then input into the computer by the staff for storage. In the process of keyboard input, the computer simultaneously checks data type, format, logic and instant error prompt.

In the process of book borrowing and returning, the barcode of the book and the barcode of the library card are scanned and input by the barcode recognition machine at the book borrowing place, and the card number and call number of the book can also be input through the keyboard;

In the process of booking, inquiring and renewing books, the call number and book card number are input through the keyboard at the user server.

2. Output design:

Various information is output on the display terminal in tabular form.

3. Man-machine dialogue design

Book filing and member registration information input are carried out by filling in the form, and error prompts and warnings are given when filling in the form.

The interface for operators to borrow and return books is mainly menu-based interface.

The user interface for inquiry, reservation and renewal is a combination of question and answer and menu.

Fourthly, database design.

The database design list of the library management information system is shown in the following figure.

Serial Number Module Name Database Name Usage Data Source Data Destination

1 Book Archiving Library Book Information Keyboard Input Query and Statistics

2 member registered member files store member information, keyboard input, query and statistics.

3 borrowing processing user borrowing

File storage user borrowing information reservation, borrowing, book return, renewal of the query generated in the process,

censorate

4 lending processing books lending

This query is generated in the process of booking, lending, returning and renewing the books stored in the archives.

test

Verb (abbreviation of verb) power network design

The computer network system adopts the open user computer/server architecture to realize the library information management system. Specially designed as a computer network system, the data is processed by the server and the results are displayed by the client.

1, the server runs UNIX operating system and supports multi-user systems.

2. The client runs Windows2000.

3.TCP/IP network protocol connects users and servers.

Six, safety design

System security is ensured by setting hierarchical user permissions, and users with different permissions can call different resources.