Design theme: 2. Design of book information management system.

Development and Design of Library Management Information System

The application program takes the common library as the development object and the language as the development platform, which can complete the basic work of the library management system. Its main tasks are reader registration, book information registration, data maintenance, book borrowing and returning, information inquiry and computer management of report output.

Keywords: library, management information system, development and design

In normal operation, the library always has to face a lot of reader information, book information and the information of borrowing and returning books generated by their interaction. Therefore, it is necessary to manage reader resources, book resources, book borrowing information and book return information, and to know the information changes in each link in time, which is conducive to improving management efficiency.

At present, there are many popular book management software on the market. For the book management of enterprises and institutions, there is no need for a large database system. Only a convenient and functional system is needed to meet the daily management needs of the library. My goal is to develop a practical, user-friendly and simple library management system software.

This application program is developed for ordinary libraries and can complete the basic work of library management system. Its main tasks are the computer management of reader registration, book information registration, data maintenance and record input, record modification, record deletion, book borrowing, book return, information query and report output.

First, the system requirements analysis

1, system target design.

Through the library management information system, the information management of the library is systematized, standardized and automated, so as to improve the management efficiency.

2. Develop the design concept.

The development and design idea of this system.

The system should meet the requirements of library information management, daily management needs of the library, and achieve intuitive, convenient, practical and safe requirements in the operation process. The system adopts modular programming method, which is convenient for various combinations and modifications of system functions, and also convenient for technical maintenance personnel who are not involved in the development to supplement and maintain.

The system should have the function of database maintenance, and add, delete, modify and query data in time according to the needs of users.

3, system function analysis

Input and modification of book information, including general number, classification number, unit price, title, author and publishing unit.

Book information query, including by number, title and author, should choose a way to display the total number, classification number, unit price, title, author and publishing unit of the detailed information of the retrieved books.

Input and modification of reader information, including library card number, name, gender, professional title, unit and address.

The query of reader information includes query by library card number and query by reader name. Select one of these methods to display the details of the inquired reader, such as name, gender, library card number, unit, professional title, address, etc.

The input of borrowing information includes library card number, universal number, borrowing date and current system date, and the expiration date is within a smart day. Return the book, delete the borrowing record of the reader's borrowing information from the borrowing database table.

Report output, including three reports of books, readers and borrowing, can complete the functions of previewing and printing out all books, readers and borrowing records.

Second, the overall structure design of the system

(1) system function module diagram

(2) Database design

Database requirement analysis

On the basis of careful analysis and investigation of library management information requirements, the data flow processed by this system is as shown in the figure.

According to the requirements of general library management information system, the following data items and data structures are designed by analyzing the content and data flow of book management process.

Book information includes general number, classification number, unit price, title, author, publishing unit and other data items.

Reader information, including library card number, name, gender, professional title, unit, address and other data items.

Borrowing information, including library card number, universal number, borrowing date, expiration date and other data items.

(2) Conceptual structure design of database

According to the above design, entities are book entities and reading.

Entity, borrowing entity.

(3) Design of logical structure of database

Design of various tables in the database of library management information system

The results are shown in the following table. Each table is represented in the database.

Data table of.

book list

Column name data type length

Total number of characters in category 6

Classification Number Character Type 6

Unit Price Number Type 6 (including 2 decimal places)

Title character type 40

Author Character Type 40

Publishing Unit Character Type 40

(4) The realization of database structure

There are two ways to realize the logical structure of the database, one is to use the project manager directly, and the other is to use the tools in its database system. In the development, I adopted the first method to realize the database structure. First create the project, then create the database of the project, and finally establish the data table.