Current location - Training Enrollment Network - Books and materials - Data dictionary query of book management system
Data dictionary query of book management system
Book management system is a typical information management system. Book management is cumbersome, frequently borrowed and contains a lot of information and data, so a perfect book management system is needed to effectively manage these data. The main task of this system is to manage books, readers, borrowing information and queries in a unified way to meet the needs of various users. Its development mainly includes the establishment and maintenance of background database and the development of front-end application programs. For the former, it requires the consistency and integrity of data, while for the latter, it requires the integrity and ease of use of the application. Based on the above considerations, this system mainly uses Visual Basic as the front-end application development tool, Access as the background database, makes full use of the advantages of Visual Basic and Access, and uses WINDOWS_XP as the system platform to make the system more perfect. The book management system is a typical information management system. The book management is complicated and frequently borrowed, which contains a lot of information. Therefore, we need a perfect book management system to realize these data and manage them effectively. The main task of the system is to manage the book management, readers' borrowing information and inquiry in a unified way to meet the needs of various users. The development includes two keys, the establishment and maintenance of background database and the development of front-end application programs. For the former, it requires data integrity and consistency, while for the latter, it requires the application to be fully functional and friendly. Based on the above considerations, the system uses Visual basic as the application development tool of outlook and Access database as the background, which makes full use of the advantages of Access and Visual basic. Use Windows XP as a platform; This makes the system more perfect. Key words: foreword reader system management of book catalogue. 1, introduction. 2 (1) Current situation of book management. 2) The development background and significance of book management. 2. System planning. 3. System tasks. 3. System objectives. 3. System planning. 3. Feasibility study. 4 1. Technical feasibility. 4 2. Economic feasibility. System analysis. 5 (1) system requirements analysis. 5 (2) Organization chart. 6 (3) Business flow chart. 6 (4) Data flow chart. 7 (5) Data dictionary. 4. System design. 13 (1) system function module diagram. 13 (2) database design. 14 1.E-R diagram. 14 2. Database table. 16 3. Create the relationship between tables.500000000606 5438+08 V. System implementation.22 (1) Login interface.22 (2) System main interface.22 (3) Add reader interface.23 (4) Reader management interface.23 (4) 25 (1) system test. 25 (2) System maintenance. 27 VII. Design Summary. There are 29 references. Appendix: List of partial procedures. 3 1 Preface The library management system is the most common system since we came into contact with it. Now is the information society. The effective management of library information resources has become the key for people to obtain information, and will also be the focus of library information construction. Books are indispensable spiritual food for human beings, and they are also the witness of society entering civilization. In the future, the requirements for information management of books will be higher. The purpose of book management system is to apply information technology to manage books, reduce a lot of data redundancy and the tedious workload of traditional management, and realize systematic and scientific book management. The main sub-modules of the system include book management, reader management, lending management and so on. , can realize the daily book management business, and finally achieve the purpose of improving work efficiency. I. Introduction (I) Current situation of book management At present, the information management system in society is developing rapidly, and more and more enterprises and institutions have introduced information management software to manage their growing information. Major universities have also adopted the library management system to manage books, and achieved great results. The book management information system is not only improved and strengthened in function, but also developed in order to make the book management more standardized, programmed and scientific. As a part of computer application, using computer to manage book information has incomparable advantages over manual management. The development of library management system is a commonplace problem. Because of its openness and maturity, it is regarded as an example of database development. With the development of database technology, network technology and scientific management methods, computers have been widely used in management, and management information systems have gradually matured, which has brought a new revolution to management. In view of the sharp increase in the number of books in schools and the explosive increase in the amount of book information, the functional requirements of the book management system are getting higher and higher, and the book management system has also developed greatly on this basis, but each system strives to be concise, complete and easy to operate. (II) Development Background and Significance of Book Management Today, with the rapid development of computer and network technology, computer applications are becoming more and more popular all over the world, and the society is rapidly moving towards an information society, and the role of information systems is becoming more and more important. At present, the book management and borrowing management of libraries in small and medium-sized cities in China are still based on paper media. This mechanism can no longer adapt to the development of the times, because it wastes a lot of manpower and material resources. In the information age, this traditional management method will inevitably be replaced by computer-based information management. Therefore, it is very necessary to develop a new library management system according to the actual situation of the library at present. Informatization of book management is the inevitable trend of information development. Through the research on the management system model, this paper puts forward a set of methods to construct the module of library information management system. Based on the knowledge learned from database and information system analysis, combined with other common knowledge of library management business, the relevant data model is established and designed and developed by using object-oriented development tools. Establishing an effective library information management system can reduce the workload, make the management scientific and standardized, and improve the quality and efficiency of library management. II. System Planning (I) System Task System Planning According to the current situation of the library management system in each school, the tasks of this research and development are determined. At present, the school's library management system has been unable to adapt to the increasing number of readers and the sharp increase in book information. Especially since the enrollment expansion of colleges and universities, libraries have also increased the number of books purchased, and the categories of books have become more and more detailed. At present, the staff in colleges and universities are mostly elderly people, which requires a set of fully functional and easy-to-use library management system. In fact, the business of book management is similar. The objects of management are readers and books, but if it is aimed at large libraries, other aspects should be considered, such as what kind of books to purchase and how much to purchase each time. Some kind of book. Considering the time, this system is developed on the internal management process of colleges and universities, and there is no information such as designing external suppliers. It is preliminarily planned that the system should complete the following tasks: 1. Friendly interface and simple operation: the interface design of the system should be concise and clear, using standard WINDOWS programming technology, using visual means such as drop-down menu and three-dimensional pop-up window, and each process should have corresponding function prompts. 2. Rich query function: the query function of the system should be convenient and flexible. For example, books can be queried by various keywords such as bibliographic number, name, publisher and author. 3. Flexible and diverse report functions: the system should have rich report printing functions, provide reports of relevant books, readers and borrowing information, and realize the function of combining, summarizing and outputting data items to facilitate printing. (II) System Objectives At present, the number of books and readers has increased, resulting in more borrowing information, and the original management mode can no longer meet the needs of the current work. At the same time, it is out of date.