Library management information system 1. Introduction 1. 1 The purpose of writing this document is to make a comprehensive and detailed analysis of users' needs based on the analysis of the database system and the results of communication with designers and customers (book readers), describe the functions, performance and interfaces of the book management system in depth, and determine the design limitations and other effective requirements of the system when defining. The readers of this statement of work for comprehensive database design are all members of the 45042LWM database system design and implementation team, mainly including system design and document editors, database implementers and system testers. Copyright belongs to the design and development team of 45042LWM database system, and dissemination is strictly prohibited. 1.2 project background With the increasing amount of social information, books, as one of the main media of information storage, are much larger in quantity and scale than ever before, and both individuals and library management departments need to manage their books in a convenient and effective way. With the increasing popularity of computers today, it will be more convenient to manage personal books with an effective book management system. For the library management department, the single manual retrieval can no longer meet people's requirements. In order to facilitate the management of books and materials, an effective book management system and software are needed. Therefore, the design and development team of 45042LWM database system realized the function and performance of the book management system through communication and coordination among team members, combined with database knowledge and related teaching materials. The book management system LMSV 1.0 is a set of data management software with complete functions, which has the advantages of convenient, efficient and fast data operation. The system software is developed by powerful database software development tools, which has good portability, can be used in DOS, WINDOWS series and other operating systems, and has a wide range of applications. In addition, LMSV 1.0 can ensure data security through access control and data backup functions. 1.3 definitions and abbreviations of technical terms used in the document are as follows: LMS: library management system; System: also refers to library management system and book management system; 45042LWM: It is the name of the design and development group of library management database system. 1.4 References [1], Yin Renkun, Tao. Practical software engineering (second edition). Beijing: Tsinghua University Publishing House, 1997. [2] Susan Wang and Sassoon. Introduction to database system. Higher Education Press, 2006. [3], Zheng, etc. Master SQL easily. Electronic Industry Press, 2000. [4] Huang Ming and Xu Liang. Examples of information system design and development. Machinery Industry Press, March 2005. [5] Tamia Liu et al. Visual Basic database development system example navigation. People's Posts and Telecommunications Press in June 2005 5438+ 10. 2. Task Overview 2. 1 The users of the target book management system are single small and medium-sized libraries or individuals, and the types and quantities of books are small, and the number and sources of readers are also limited. The corresponding requirements are: 1. It can store a certain amount of book information, and conveniently and effectively operate and manage the corresponding book data, mainly including: 1) entry, deletion and modification of book information. 2) Multi-keyword retrieval and query of book information. 3) Lending, returning and data statistics of books. 2. Be able to store and manage a certain amount of reader information, including: 1) registration, deletion and modification of reader information. 2) Statistics and inquiry of reader information. 3. Be able to provide list display output for the required statistical results. 4. It can provide a certain security mechanism, provide authorized access to data information, prevent arbitrary deletion and modification, and provide information backup service. 2.2 running environment PC desktop or portable computer such as Intel series or AMD 2500 series or above; Memory occupied at runtime: ≤ 5 MB; Hard disk space required: ≤ 20mB; Operating system platform: Chinese Windows2000/XP or above; Database development and implementation tool: SQLServer2000 Personal Edition. 2.3 Conditions and limitations We believe that a relatively perfect book management system should provide more convenient and powerful information query functions, such as corresponding network operations and services. Due to the limited development time and knowledge and skills, this system does not provide this function. The protection of information is limited to setting user level and providing data file backup, which is relatively simple, unable to prevent malicious damage, and the security performance needs to be further improved. Security is also a problem that can't be ignored in developing database systems in the future. 3. Data Description 3. 1 Static data The static data of the book management system includes: book information: book number; Book title; Book author; Name of publishing house; Date of publication; Page number of the book; Book classification; Book status; Reader: reader number; Reader's name; Gender of readers; Type number; Reader work unit; The phone number of the reader; E-mail address of the reader; Date of registration; Reader password; Borrowing information: borrowing number; Reader number; Reader's name; Book number; Book title; Lending date; Date of book return; User: user name; User password; User type (permission level); Reader category information: category number; Name of species; Time limit for borrowing books; Validity period; Book category information: category number; Category name; Keywords; 3.2 Dynamic data input data: query methods and query keywords; New book project and reader project; Changes in the corresponding records of book projects and reader projects; Backup data backup files required for data recovery; The serial number of the borrowed and returned books and the reader's borrowing card number; Passwords required for restricted operations; Output data: a subset of database records determined by query keywords; Statistical results; Results of information entry and deletion (success or failure); Book borrowing and returning operation results and can display whether to return; Data backup file output by data backup; Internal data: an index established through query operation; 3.3 Database Description The database adopts MicrosoftSQLServer2000 database. The name of the database system is 45042LWM book management database system. 4. User demand analysis The focus of demand analysis is to investigate, collect and analyze users' information needs, processing needs, security and integrity needs in data management. 4. 1 extract user semantics This system is centered on the user's point of view, and mainly involves data management such as book information, system user information, reader information, and book borrowing. Different users have different services and different roles. From the perspective of system management, books can be divided into three categories: book information management, system user management and reader data management. Book information management includes books borrowing and returning, inquiry and other operations, system user management includes system user categories and user data management, and reader data management includes reader category management and personal data entry, modification and deletion. As one of the main media of information storage, the number and scale of books are much larger than ever before, so both individuals and library management departments need to manage their books conveniently and effectively. We mainly analyze the needs of different users, and draw the conclusion that the book management system should mainly have the following functions: the demand of book borrowers is to query the books stored in the library; Library staff operate the borrowing and returning requirements of book borrowers, and form a borrowing or returning report for borrowers to check and confirm; The functions of librarians are the most complicated, including the management and maintenance of staff, book borrowers and books, as well as the inspection and maintenance of system status. Borrowers can go directly to the library to look up books. If they log in to the system according to their library card number and password, they can also check their borrowing situation and maintain some personal information. In general, book borrowers should only inquire and maintain their own borrowing situation and personal information. Library staff have the right to modify the borrowing and returning records of book borrowers. Librarians have the highest requirements for data security and confidentiality. Librarians designed by 45042LWM database system design and development team can browse, query, add, delete, modify and count the basic information of books; Browse, query, count, add, delete and modify the basic information of book borrowers, and give them the highest authority. When the administrator deletes the basic information records of book borrowers, it is necessary to delete the borrowing records of book borrowers in cascade. At the same time, different readers can not only browse books, but also have different borrowing periods, which is the difference between the so-called experiential readers and ordinary readers. 4.2 The overall functions of the data flow diagram and data dictionary book management system are as follows: (1) book lending; (2) the return of books; (3) book information inquiry; (4) Addition and deletion of books; (5) Librarians (system administrators) query statistical books and reader information; (6) Data backup of the book management system; (7) Data recovery of library management system; (8) Administrator password modification and other functions; 4.2. 1 The process of readers borrowing books: (1) Data flow diagram: a. Book information; B. reader information; C. book access records; D. date; (2) data dictionary: a. data source description: a. name: reader's brief description: borrowing and returning books, inquiring and registering related data streams: borrowing quantity: b. name: date brief description: date related data streams: year, month and day: b. data stream noun description: a. data stream name: reader's ID description: data stream source for carrying readers' unique identification: reader's data stream destination: pass. Data stream destination: borrowing check C. Data stream name: borrowing information description: used for transmitting reader number and book number Data stream source: borrowing check Data stream destination: borrowing registration D. Data stream name: date description: providing current date information Data stream source: calendar data stream destination: borrowing check, Book lending registration E. Data stream name: reader information description: data stream source: reader information data stream destination: book lending inspection F. Data stream name: book information description: book information data stream source: library data stream destination: book lending inspection C. Data file entry description: A. Data file name: reader information table description: reader information input data: output data: reader information data file composition:. User information table consists of "reader information" storage mode: key code B. Data file name: book information table description: book information input data: output data: book information data file composition: book information table consists of "book information" storage mode: key code 4.2.2 Reader return process: similar to the above 3.4. 1 reader lending process, except that the data dictionary will not be described in detail.
4.2.3 Reader's book query process: (1) Data flow diagram: D Reader's query authority check data query book access record reader's library book check error user information) query information calendar A query result CB
A. book information; B. reader information; C. book access records; D. date;