How to input basic information for library readers, modify, save, and query

How to input, modify, store and query basic information for library readers

Library Management Information System 1. Introduction 1.1 Purpose of writing The purpose of writing this document is to conduct a comprehensive and detailed analysis of user needs based on the results of database system analysis and communication with designers and customers (book readers), and to describe in depth the functions and functions of the "Library Management System" Performance and interface, identifying the design constraints of the system and other effectiveness requirements when defining it. The readers of this database comprehensive design operation specification are the members of the 45042LWM database system design and implementation team, which mainly include system design and file editors, database implementation personnel and system testers. The copyright belongs to 45042LWM database system design and implementation team. It is owned by the development team and external distribution is strictly prohibited. 1.2 Project background With the increasing amount of social information, books, one of the main media for information storage, are much larger in number and scale than ever before. Both individuals and library management departments need to use convenient and effective ways to manage themselves. books. Today, as computers become increasingly popular, it would be much more convenient for individuals to use an effective library management system to manage their own books. For the library management department, the previous single manual search can no longer meet people's requirements. In order to facilitate the management of library materials, effective library management systems and software are needed. For this reason, the 45042LWM database system design and development team passed the discussion among team members. Through communication and coordination, combined with the database knowledge and related teaching materials learned, the functions and effectiveness of the "Library Management System" were realized. The library management system LMSV1.0 is a set of data management software with relatively complete functions, which has the advantages of convenient, efficient and rapid data operation. The system software is developed using powerful database software development tools. It has good portability and can be used on operating systems such as DOS and WINDOWS series with a wide range of applications. In addition, LMSV1.0 can ensure data security through access permission control and data backup functions. 1.3 The definitions and abbreviations of specialized terms used in the definition document are briefly as follows: LMS: Library Management System, library management system; this system: also refers to Library Management System, library management system; 45042LWM: is the library management database system design and Development team name. 1.4 References [1] Zheng Renjie, Yin Renkun, Tao Yonglei. "Practical Software Engineering" (2nd ed.). Beijing: Tsinghua University Press, 1997. [2] Wang Shan, Sa Shixuan. "Introduction to Database Systems". Higher Education Press, 2006. [3] Zhang Lihong, Zheng Liqiang, etc. "Mastering SQL Made Easy". Electronic Industry Press, 2000. [4] Huang Ming, Liang Xu. "Visual Basic Information System Design and Development Examples". Machinery Industry Press, March 2005. [5] Liu Tao et al. "Visual Basic Database Development System Example Navigation". People's Posts and Telecommunications Press, January 2005. 2. Task Overview 2.1 Objectives The "Library Management System" is aimed at users of single small and medium-sized libraries or individuals. The types and quantities of books collected are small, and the number and sources of readers are subject to certain restrictions. The corresponding requirements are: 1. It can store a certain amount of book information and perform corresponding book data operations and management conveniently and effectively. This mainly includes: 1) Entry, deletion and modification of book information. 2) Multi-keyword search query for book information. 3) Lending, returning and data statistics of books. 2. It can store and manage corresponding information for a certain number of readers, including: 1) Registration, deletion and modification of reader information. 2) Statistics and query of reader information. 3． Able to provide list display output for required statistical results. 4. It can provide a certain security mechanism, provide authorized access to data and information, prevent arbitrary deletion and modification, and provide information backup services.

2.2 Execution environment Intel series or AMD 2500 or above series PC desktop computer or mobile computer, etc.; memory occupied during execution: ≤5MB; required hard disk space: ≤20MB; operating system platform: Chinese Windows 2000/XP or more High version; database development and implementation tool: SQLServer2000 Personal Edition. 2.3 Conditions and Limitations We believe that a more complete library management system should provide more convenient and powerful information query functions, such as corresponding network operations and services. Due to limited development time and knowledge and skills, this system This feature is not provided. The means of protecting information are limited to setting user levels and providing backup of data files. They are relatively simple and cannot prevent malicious damage. The security performance needs to be further improved. Security is also an issue that cannot be ignored when 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 name; book author; publisher name; publication date; book page number; book classification; book status; Reader: reader number; reader name; Reader's gender; category number; reader's workplace; reader's phone number; reader's email address; registration date; reader's password; borrowing information: borrowing number; reader number; reader's name; book number; book title; loan date; return date; User: user name; user password; user type (permission level); reader category information: category number; category name; borrowing period; validity period; book category information: category number; category name; keywords ; 3.2 Dynamic data input data: query method, query keyword; New book items and reader items; Corresponding record changes of book items and reader items; Backup data backup files required for data recovery; Borrowed and returned book serial numbers, reader borrowing cards Number; Password required for restricted operations; Output data: A subset of database records determined by query keywords; Statistical results; Information entry and deletion results (success or failure); Book borrowing and return operation results and can display whether Return; Data backup file output by data backup; Internal data: Index created by query operation; 3.3 Database description The database uses MicrosoftSQLServer2000 database. The name of the database system is 45042LWM book management database system. 4. User Needs Analysis The focus of demand analysis is to investigate, collect and analyze users' information requirements, processing requirements, security and integrity requirements in data management. 4.1 Extracting user semantics This system focuses on the user's perspective, mainly involving various 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 operations such as book borrowing, returning, and querying. System user management includes system user categories and user data management. Reader data management includes reader category management and the entry, modification, and deletion of personal data. As one of the main media for information storage, books are much larger in number and scale than ever before. Both individuals and library management departments need to use convenient and effective ways to manage their books. We mainly start from the analysis of the needs of different users. The analysis and design combined with reference materials come to the conclusion that the library management system should have the following functions: the needs of book borrowers are to query the books stored in the library; library staff are responsible for borrowing books from borrowers. Operate according to the book return request and form a book borrowing or returning report for the borrower to review and confirm; the functions of library managers are the most complex, including the management and maintenance of staff, book borrowers, and books, as well as the review of system status, Maintenance etc. Book borrowers can directly check the status of library books. If book borrowers log in to the system based on their library card number and password, they can also inquire about their borrowing status and maintain some personal information. Under normal circumstances, book borrowers should only inquire and maintain their own book borrowing status and personal information. Library staff have the authority to modify the borrowing and returning records of book borrowers. Library managers have the highest requirements for data security and confidentiality.

The librarians designed by the 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 , giving it the highest permission. When the administrator deletes a certain basic information record of a book borrower, the administrator should implement cascade deletion of the borrowing record of the book borrower. At the same time, different readers can not only browse books, but also have different loan periods. This is the difference between so-called senior readers and ordinary readers. 4.2 Data flow diagram and data dictionary The overall functions of the book management system are as follows: (1) Lending of books; (2) Return of books; (3) Book information query; (4) Adding and deleting books; (5) Book management The administrator (system administrator) can query statistical books and reader information; (6) Library management system data backup; (7) Library management system data recovery; (8) Librarian 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. Description of data source point: a. Name: Brief description of readers: Borrowing, returning, inquiry and registration Relevant data flow: Number of borrowed books: b. Name: Brief description of date : Data flow related to the date of the day: Number of years, months and days: B. Data flow noun description: a. Data flow name: Reader ID Description: Used to carry the reader's unique identification ID Data flow source: Reader Data flow destination: Borrowing books Check each data volume Circulation volume: b. Data flow name: Book description: Record the main relevant information of the book Data flow source: Reader data flow destination: Borrowing books for inspection c. Data flow name: Book borrowing information Description: Used to transmit reader number and book number Data flow source: Borrowing book inspection Data flow destination: Book borrowing registration d. Data flow name: Date Description: Provides current date information Data flow source: Calendar Data flow destination: Book borrowing inspection, book borrowing registration e. Data flow name: Reader information Description: Used to record the reader information registered in the database Data flow source: Reader database Data flow destination: Borrowing book inspection f. Data flow name: Book information Description: Used to record the book information registered in the database Data flow source: Library library Data flow destination: Book borrowing inspection C. Data file entry description: a. Data file name: Reader information table Brief description: Store reader information Input data: Output data: Reader information Data file composition: Reader information table consists of "reader information" Storage method: Key code b. Data file name: Book information table Brief description: Store book information Input data: Output data: Book information Data file composition: Book information table consists of "book information" Storage method: Key code 4.2.2 Reader return process: and above 3.4 .1 The process of borrowing books by readers is similar. The difference is that one is for readers to borrow books, and this is the process of returning books. The data dictionary will not go into details here. The data flow diagram is as follows: Book readers return books, check return books, check return books, check errors, return books Information book access record calendar return book return information

4.2.3 Reader query book process: (1) Data flow diagram: D Reader query permission inspection data query book access record reader library library verification error user information ) Query information calendar A Query results CB

A. Book information; B. Reader information; C. Book access records; D. Date; The library keeps quiet and is a civilized reader’s slogan

These are the words on the walls of the Harvard University library, which will definitely alert those who whisper in the library

1. At this moment If you take a nap, you will dream; if you study now, you will realize your dream.

2. My wasted today is exactly the tomorrow that those who died yesterday prayed for.

3. The time when you think it is too late is precisely the earliest time.

4. Don’t put off today’s things until tomorrow.

5. The pain of learning is temporary, and the pain of not learning is lifelong.

6. Learning this is not a matter of lack of time, but a lack of effort.

7. Happiness may not be ranked, but success must be.

8. Learning is not everything in life. But since you can't conquer even one part of life - learning, what else can you do?

9. Please enjoy the unavoidable pain.

10. Only by working earlier and more diligently than others can you taste success.

11. No one can succeed casually. It comes from thorough self-management and perseverance.

12. Time is passing.

13. The drool now will become the tears tomorrow.

14. Learn like a dog and play like a gentleman.

15. If you don’t walk today, you will run tomorrow.

16. Those who invest in the future are those who are loyal to reality.

17. Educational level represents income.

18. Once a day is over, it will never come again.

19. Even now, the opponent keeps turning the pages.

20. Without hardship, there is nothing gained. Design the entire system into C language programming of library information input module, library information management module, and library information query module

You can use Baiduhi to remind us

Yes Opportunities can handle the work you encounter

Further requirements can also remind us

ES:\\403FBBD22E82E57226A7E8AAB149761F

PS: Kind reminder: Pay first Deposit is a trap. ICBC online banking query and modification of customer information has become query and modification of customer basic information

Hello, ICBC online banking upgraded to a new version on October 24, and some contents have been adjusted. The library's slogan reminds readers to keep quiet and be civilized readers

●Communication between the souls does not require too many words. (Note: Please keep quiet) How to log in to the reader's borrowing information account in Xi'an Jiaotong University Library?

Log in with your student ID. If there is no password set, go to the library staff and ask. It seems that there is I also forgot the initial password. Can scenting your library boost reader energy?

There is a little help. To choose the right essential oil, take a look at Senfuya Aromatherapy to search for basic information for readers of the Department of Computer Science and Foreign Languages.

Author of "Computer Professional English" Yu Fang Publishing House and Metallurgical Industry Press Computer Professional English Content Summary Through the study of "Computer Professional English", readers should be able to remember, understand and master a certain amount of computer professional vocabulary and basic concepts, as well as common computer English sentence patterns, for the future Be able to proficiently read computer English technical literature, materials and books to lay a good foundation. "English for Computer Majors" can be used as an English teaching material for computer majors in higher vocational colleges or related majors in various training classes. It can also be used by computer enthusiasts and self-study personnel. English Course for Computer Professionals (3rd Edition)/Basic Information on Professional English Textbooks for Colleges and Universities? Publisher: Electronic Industry Press. Content Introduction This book aims to enable readers to master computer professional English terminology, and to train and improve readers in reading and translating professional English literature. ability, and improve students' English speaking ability through classroom English communication. The material of this book is taken from the latest textbooks, monographs, papers and computer network information in various fields of computer science abroad in recent years. It has novel content, wide coverage, strong systematicness and good readability. In order to facilitate teaching, this book is accompanied by some reference translations and references used to draw materials. ?This book can be used as a professional English textbook for computer majors in colleges and universities, and can also be used as a learning reference for computer professionals and other interested readers. The details are not very clear, I hope it helps. You can also install Google Kingsoft PowerWord on your computer, which contains computer-specific keywords. What content can readers search in the library catalog?

Through the library catalog system, you can query Chinese and Spanish books, Russian books, Chinese and Spanish periodicals, and Japanese books collected after 1977 in the school library. And Japanese journals, multimedia resources, most foreign electronic journals, theses and Chinese and foreign electronic books collected after 1994, as well as the collections of 6 professional libraries and some departmental libraries. For ancient books, please search through the catalog of ancient books in the collection. For other collections, please search through the card catalog. There were 22 readers in the library in the morning and 20 readers in the afternoon. Among these readers, 5 male readers were female readers.

1. Answer:

There were 35 male readers. , there are 7 female readers.

2. Analysis:

***22+20=42 readers in the morning and afternoon.

It is known that male readers are 5 times more than female readers, then we can assume that there are x number of female readers and 5x number of male readers. It can be concluded that x+5x=42, that is, 6x=42, then x=7, 7 female readers, and 5x male readers are 35.