Book information management system is a common system in schools, from book registration to inquiry and browsing, from reader management to book management.

Lending has formed a set of automatic management mode. This paper takes the school library as an example. The system mainly includes three aspects: book management and book borrowing.

Reading and information inquiry. The design of this paper is to develop a complete library information management system from these three aspects.

Keywords: information management system; VB； ACCESS2003 readers; Loan 1. introduce

Today's era is a rapidly developing information age. It is inseparable from all walks of life.

Information processing, which is the environment where computers are widely used in information management systems.

The biggest advantage of a computer is that it can manage information. Use calculation

Computer information control not only improves work efficiency, but also greatly improves its security.

Integrity.

A modern library always faces a large number of readers in its normal operation.

Information, book information and borrowing information generated by their interaction, as well as letters.

Rest. Faced with thousands of books in the library, complicated reader information, frequent

The traditional direct way to replace the information of books borrowed and returned not only manages loopholes, but also causes

Loss.

Therefore, it is very important to have an intelligent, systematic and informative book management system.

Important. Make full use of the functions of the computer to realize the functions of readers, books,

Automatic control, such as lending management, will greatly weaken the work of the library. convenient

Friendly graphical interface, simple operation and perfect database management will make

The library system is applied to modern book management to the maximum extent.

Generally speaking, there is a lack of systematic and standardized information management means. Although there are some pictures

The library has a computer, but it is not used for information management and does not play a role.

The problem of idle resources is more prominent, which is the basis of the development of management information system.

environment

Second, the book management system design

(A) the overall planning of the book management system

This paper summarizes the necessary conditions for establishing the computer system of library and information.

It is just four words, namely "hard, soft, library and human". "hard" refers to the computer host and other external

Peripheral equipment; "Software" refers to computer system software and application software, including operating system.

Software for realizing library automation, database management software and application software; "Library"

Refers to documents and databases; "People" include leaders, senior system analysts and system analysts.

And designers, programmers, operators and users.

Therefore, the book management system can realize the function according to the user's authority.

It is divided into two parts: external students' access to the database and internal managers.

Librarians' management and maintenance of books and archives. However, both parts call the same number.

According to the database, only internal managers can realize all management functions, while external students

When accessing the database, some functions are blocked and can only be viewed. System function diagram

As shown in 1.

(2) Application requirement analysis

1. requirement description analysis

The book management system needs to meet three requirements.

They are book borrowers, librarians and librarians. draw

The demand of book borrowers is to inquire about the collection of books, personal borrowing and

Modification of personal information; Library staff's borrowing and returning books.

It is required to operate books, and at the same time form a report on borrowing or returning books for borrowers to consult.

Recognition; The functions of librarians are the most complicated, including managing staff and books.

Manage and maintain the borrower and ledger, and view and maintain the system status.

Return the book report as soon as possible.

In fact, requirement analysis is one of the most difficult tasks in database development. because

Because, first, the system itself is variable, and the needs of users must be constantly adjusted to make it

Adapt to this change. Second, it is difficult for users to clearly explain the function of a certain part of the work.

Manage the process. Therefore, designers must realize that in the whole requirements analysis and system.

In the process of system design, the importance of user participation is investigated through various methods.

Analysis.

2. Steps of demand analysis

Demand analysis can be roughly divided into three steps, namely, demand information collection and analysis.

After analysis and review, here is a brief introduction of the first two steps.

(1) demand information collection

The collection of demand information is also called systematic investigation. In order to fully understand users

Be fully prepared before investigating the possible needs.

To understand the purpose, content and method of the survey.

(2) Analysis and arrangement of demand information

In order to convert collected information such as documents, charts, bills and notes into

For the formal information that can be used in the next stage of design work, the demand information must be analyzed.

Finish the work.

Third, the application program design of the book management system

(A) the realization of the user login form

This form is suitable for three different users (ordinary users, employees and managers)

Members) provide options to enter different modules to meet the needs of different users. Zaideng

Login interface, click OK to enter the authentication window, which determines the user's identity.

Enter as to determine the user's rights. My database has established two functions.

Account number: administrator, password:111,Zhang San, password: 198352. Choose the body

After entering, it will enter the operation interface of the system.

(B) the realization of the form of borrowing

The main function of the borrowing list is to facilitate readers to borrow books, which are divided into books and letters.

Information and reader information can be operated according to reader number and reader name. borrow books

Add and query book borrowing information in management. Such as adding borrowing information, figure

Book information management. You can choose the title, number, book category, author and publishing house.

After clicking OK, the corresponding information of the book will be displayed. If this is the book you need,

Just click to borrow this book.

(C) the realization of the form of book return

The main function of the borrowing form is to facilitate readers to return books and read them as needed.

Return the book according to the reader's information, or according to the reader's information,

Select the reader number and the reader name respectively for query. You can also follow the letter.

Information, respectively, choose the book number and title for query.

(D) the realization of the query form

1. Query borrowing information

Query can query borrowed books and books that have not been borrowed, which can be based on the reader's name.

Query, the query results will be displayed. The borrowing information window is shown in Figure 2.

Mouth. 2. Query reader information

The query can be based on the reader name, reader number and reader type.

For the required query, please refer to the reader information in Figure 3.

Fourth, summary.

This design is a library management system based on libraries, users and administrators.

Based on the actual situation, it is the development of database system. Make them effective.

Database design, transforming the design into actual databases, and comparing these databases with

It has complete functions and efficient applications.

Therefore, combined with the requirements of open library, I analyzed the database management system.

VB application program design and VB database technology have been deeply studied and applied.

Use, mainly to complete the demand analysis, functional module division and numbering of the book management system.

According to the analysis of database mode, the database structure and application program are designed. Systematic transportation

The results show that the book management system designed in this paper can meet the needs of borrowers and libraries.

The needs of librarians.

References:

Li Guangming. Visual Basic 6.0 programming example [M]. Beijing: Metallurgical Industry Press,

2004.

[2] Liu Bingwen. Proficient in getting started with VISUAL BASIC 6.0 and improving it [M]. Beijing: People's Posts and Telecommunications

Press, 2003.

[3] Microsoft. Visual Basic 6.0 Chinese control encyclopedia [M]. Beijing: Electronic industry.

Press, 2002.

[4] Jin W. Modern Database System [M]. new york: American Computer Society Press, 1995.