I. Introduction to the system
With the rapid development of computer technology, using computers to obtain and process information is a major feature of information management today. With the rapid development of computer hardware, information management software-database system software is also developing rapidly. Library is an important part of colleges and universities and an important place for teachers and students to acquire knowledge. Because libraries are mainly engaged in the storage and circulation of a large number of books and materials. Therefore, the application of computer in library book management has a long history. This system is a book management system developed in combination with the actual situation. The main task of system development is to solve the problems in book circulation in view of the shortcomings of the original system in timeliness, data correctness and operation convenience. Realize the systematization, standardization and automation of book information management, and maximize the office efficiency of operators.
Second, the system requirements analysis and overall design
2. 1 system function requirements
Bar code management of 1. information.
2. In order to effectively input data in batches, the system should check the validity of the input data and perform basic operations, such as adding, deleting and modifying data.
3. Realize the dynamic query of data, with fast query speed, and print out the data in a unified form.
4. The system should provide corresponding code maintenance function.
5. The system should have the function of backup and recovery of important data in the database.
6. The system should adopt the way of anonymous login of users to protect the important and sensitive data of the system database.
2.2 overall system design
This database management system mainly consists of six modules: book retrieval, book management, data maintenance, book statistics, printout and system maintenance, as shown in figure 1. The functions of each module are as follows:
1, the main control module The main control module is used to control each branch module, and it is the general console to realize the functions of each module.
2. The book retrieval module is one of the important modules of the book management system, and it is the way for readers to query books quickly. The function of this module is to query books by title, ISBN, author, publishing house and book classification.
3. The library management module is the operation module of the librarian, and readers have no right to enter. This module consists of the following sub-modules: reader number and name inquiry, book borrowing registration, book return registration and book renewal registration. In the "book lending registration", the administrator registers the book lending, and the stock of the book in the library decreases, while the stock of the book returned in the library increases. Calculate a fine for readers who fail to return the book after the specified date. Book management is equivalent to the daily management of librarians, that is, the registration of book borrowing, returning and renewing.
Figure 1 Function Module Diagram of Library Management System
4. The data maintenance module is controlled by the librarian. It consists of programs such as adding, modifying and deleting readers, adding, modifying and deleting books, browsing and modifying readers and browsing and modifying books. When designing the software, the uniqueness of reader number, book title and book number is considered. Therefore, when modifying readers or books, once the reader number and name are registered, the reader record or book record cannot be modified. When deleting readers or books, as long as the readers have not returned the borrowed books or the original inventory quantity of books does not match the existing inventory, they cannot be deleted.
5. The data statistics module includes reader statistics, book statistics, classification statistics of borrowed books and reader statistics of unexpired books.
6. The printout module includes reader information, printed borrowed books, readers who have not returned books due, and printed book introduction cards. This module is controlled by the librarian.
7. The system maintenance module includes data backup, data recovery, password modification and database indexing, which is controlled by the administrator. Data backup is mainly to back up readers' library, lending library, library and index library, mainly to prevent unexpected events, such as sudden power failure, virus or hard disk damage. Data recovery is the reverse operation of data backup. Password modification mainly considers data security. The librarian can change the password at any time to prevent others from entering the data index of the library management system. If the database and index library can't be synchronized during the operation, the librarian can use this function normally.
8. Exit the system. The exit system module consists of help and exit.
Third, the steps and methods of system design
Development tools
Platform: Visual C++ 6.0
Language: C++ language compatible with C.
3. 1 database design
3.2 Design and implementation of functional modules
3.3 Design and Creation of Menu
3.4 Writing of main program
3.5 compilation and operation of the system
3.6 system description