How to input, modify, store and query the basic information of library readers? Library management information system 1. Introduction 1. The purpose of writing this document is based on the analysis of the database system and the results of communication with designers and customers (book readers), to conduct a comprehensive and detailed analysis of user needs, to deeply describe the functions, efficiency and interface of the book management system, and to determine the design limitations and definitions of this system. The readers of this database comprehensive design specification are all members of the 45042LWM database system design and implementation team, mainly including system design and document editing personnel, database implementation personnel and system testing personnel. 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 previous 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 efficiency of the library management system through the communication and coordination among team members and the knowledge of database and related teaching materials. The book management system LMSV 1.0 is a set of data management software with perfect 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 function. 1.3 definitions and abbreviations of technical terms used in the definition 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 team of the 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. Design and development of Visual Basic information system. Machinery Industry Press, March 2005. [5] Tamia Liu et al. Visual Basic database development system case 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, so the number and sources of readers are limited to some extent. The corresponding requirements are: 1. It can store a certain amount of book information, and operate and manage the corresponding book information conveniently and effectively, 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 and information, prevent arbitrary deletion, and provide information backup service. 2.2 execution environment PC desktop computer or Intel series or AMD 2500 series or above mobile computer; Memory occupied during execution: ≤ 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 means of protecting information is limited to setting user level and providing data file backup, which is relatively simple and cannot prevent malicious damage, and the security efficiency 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: index created by query operation; 3.3 Database Description The database adopts MicrosoftSQLServer2000 database. The name of the database system is 45042LWM Library 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 enjoy different services and have 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 chart and data dictionary book management system are as follows: (1) borrowing books; (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 library management system; (7) Data recovery of library management system; (8) Administrator password modification and other functions; 4.2. 1 reader borrowing process: (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 description: book borrowing and returning, inquiry and registration related data stream: book borrowing quantity: b. name: date description: data stream related to today's date: year, month and day number: b. data stream terminology description: a. data stream name description: reader ID: the unique identifier used to carry readers. Source of data stream: reader's data stream direction: check the circulation of each data stream: B. Data stream name: book description: record the main relevant information of the book. Where to go: book borrowing check C. Stream name: book borrowing information description: used to transmit reader number and book number. Source: Book borrowing check. Stream destination: book borrowing registration D. Stream name: date description: provide current date information. Stream source: calendar stream destination: book lending check and book lending registration E. Stream name: reader information description: reader information data stream source: reader information data stream destination: book lending check F. Stream name: book information data stream source: library data stream destination: book lending check C. Data file entry description: A. Data file name: reader information table description: storing reader information input data: output data: reader. Information table consists of "reader information" storage mode: key code B. File name: book information table description: book information input data: output data: book information file composition: book information table consists of "book information" storage mode: key code 4.2.2 Reader return process: similar to the above-mentioned 3.4. 1 reader borrowing process, the difference is that the data dictionary is not repeated, and the data flow chart.
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 book check error user information) query information calendar A query result CB
A. book information; B. reader information; C. book access records; D. date;
Keep the library quiet and be the slogan of civilized readers. This is the writing on the wall of Harvard University Library, which will surely alert those who are whispering in the library.
1, take a nap at this moment, you will dream; And study at this moment, and you will realize your dream.
2. My deserted today is the tomorrow that people who died yesterday prayed for.
3. When it is too late, it is the earliest time.
Don't put off today until tomorrow.
The pain of studying is temporary, but the pain of not studying is lifelong.
6. Learning this thing is not a lack of time, but a lack of effort.
7. Happiness does not necessarily rank second, and success must rank second.
8. Learning is not the whole of life. But since we can't conquer a part of life-study, what else can we do?
9. Please enjoy the inevitable pain.
10. Only by working harder earlier than others can we taste the taste of success.
1 1, no one can succeed casually, it comes from thorough self-management and perseverance.
Time is running out.
13, the saliva that flows now will become the tears of tomorrow.
14. Learn like a dog and play like a gentleman.
15, don't go today, run tomorrow.
16, people who invest in the future are loyal to reality.
17, education represents income.
18, I won't come again after a day.
19. Even now, opponents keep turning pages.
20. No hardship, no gain.
The C language programming of designing the whole system into book information input module, book information management module and book information query module can remind us with Baidu.
Have the opportunity to deal with the work you encounter.
Further requirements can also remind us.
ES:\ \ 403 fbbd 22e 82e 57226 a7 E8 aab 14976 1F
PS: Kindly remind: It is a trap to pay the deposit in advance.
ICBC's online banking changed from querying and modifying customer information to querying and modifying basic customer information. Hello, ICBC's online banking upgraded its new version on June 24th 10, and some contents were adjusted.
The library reminds readers to keep quiet and be the advertising language of civilized readers ● Heart-to-heart communication does not need too many words. (Note: Please keep quiet)
How does Xi Jiaotong University Library log in to the reader's borrowing information account and log in with your student number? If you don't have the password, ask in the manual office of the library. There seems to be an initial password, I forgot.
Can adding incense in the library improve readers' energy? A little help. To choose the right essential oil, look at Senfuya Aromatherapy.
Searching for Basic Information of Readers in Computer Department and Foreign Languages Department; Overview of Computer English Content of Yu Fang Publishing House Metallurgical Industry Publishing House; Through the study of computer English, readers should be able to remember, understand and master a certain number of computer vocabulary and basic concepts, as well as common sentence patterns of computer English, so as to lay a good foundation for mastering computer English technical documents, materials and books in the future. Computer English can be used as an English textbook for computer majors or related majors in various training courses in higher vocational colleges, and can also be used by computer enthusiasts and self-taught students. Computer English Course (Third Edition)/Basic Information Publishing House: Introduction to Electronic Industry Publishing House This book aims to enable readers to master computer English terms, cultivate and improve the reading and translation ability of professional English documents, and improve students' oral English ability through classroom English communication. The material of this book is taken from the latest textbooks, monographs, papers and computer network materials in various fields of computer science abroad in recent years. The content is novel, wide-ranging, systematic and readable. In order to facilitate teaching, this book is accompanied by some reference translations and reference materials for drawing materials. ? This book can be used as a professional English textbook for computer majors in colleges and universities, and also as a reference for computer professionals and other interested readers. The details are not very clear, I hope it will help you. You can also install a Google Kingsoft on your computer and sort it according to the special words of your computer.
What can readers look up in the library catalogue? Through the book cataloging system, you can find Chinese and western books, Russian books, Chinese and western periodicals, Japanese books entered into Tibet after 1977, Japanese periodicals entered into Tibet after 1994, multimedia resources, most foreign electronic periodicals, dissertations and Chinese and foreign electronic books, as well as the collections of six professional libraries and some departmental libraries. Please check the ancient books through the ancient books catalogue, and the rest of the libraries
Please refer to the Tibetan literature card catalogue.
The library has 22 readers in the morning and 20 readers in the afternoon. The male readers among these readers are female readers.
There are 35 male readers and 7 female readers.
2. Analysis:
Morning and afternoon ***22+20=42 readers.
It is known that male readers are five times as many as female readers, so it can be assumed that female readers are X and male readers are 5x. It can be concluded that x+5x=42, that is, 6x=42, so x=7, there are 7 female readers, and 5x male readers are 35.