Library management system design report

1. Title

Library management system

2. Introduction to the topic

If the library management needs manual management, it will cost a lot of human and material resources . In order to improve the efficiency of Library Management , Now establish a library management system .

The system is developed for students and librarians , It is used for the management of library books borrowing and returning . Take the account number and password as the basis for login . Students finish checking library book information 、 Check your borrowing information 、 The function of borrowing and returning books . The librarian completes the functions of modifying book information and deleting student users . The main functions are as follows ：

1. User login management （ check ）
2. Students visit the library
3. Librarians manage students and users
4. New user registration

3. Demand analysis

3.1 Investigate user needs

The needs of customers are embodied in the provision of various information , preservation , Update and query . This requires that the structure of the database can fully meet the input and output of all kinds of information . Library management system is based on student borrowers , The book , The administrator is a system that meets the contact of the three , Student borrowers can easily query in this system , Borrow books , Book information should be kept in the database of the system , Administrators should facilitate the management of students and Library Information . We are now investigating all aspects , Requirements are as follows ：

Borrower ：

In the library , Facing Ponto's books , Unable to find the books you need as soon as possible , Nor can we know more about the information of library books , The system should be able to meet the borrower's various query functions for books . The library has certain restrictions on the borrowing of books ： You can borrow up to several books at the same time , Borrowing time of a Book , Term of loan , Return time , More time , The borrower forgot when he borrowed a Book , Want to know when to return , There are a few days left to borrow , And you can still borrow a few books . therefore , The library management system should be able to meet these conditions , Borrowers register their own accounts , In this account , Borrowers can query their specific borrowing information .

Administrators ：

Manage the library , Mainly for borrowers , Management of books .

** Management of books ：** It should include information about books that can be queried （ Including the types of books , total , The specific books contained in each book , Information about a Book , Number ）, Check the borrowing of books （ Including information about books borrowed , Borrower's information ）, When books change , It should also have the authority to modify book information .

** Management of borrowers ：** First , It should be able to meet the query of borrower's borrowing information , Including books borrowed by borrowers , Borrowing time , Time of return, etc ; secondly , When the borrower does not return the book, it is , You should be able to query the personal information of borrowing this , Including name, , Age , College major, etc .

3.2 Description of the basic information of the database

Library management system database Library_Management It consists of four entities ： Borrower entity , Book entity , Administrator entity , Book category entity composition , A total of six tables are as follows ：

1. The book list ： It mainly includes the information of books , Including books id, Title , The types of books , author , Press. , Number .
2. Book borrowing form ： It mainly includes the borrowing information of books , Including all borrowed books , The book information , Borrower information , Borrowing time , The remaining quantity .
3. Borrower information sheet ： Including the names of the books borrowed by the borrowers , Books id, Borrower's name , Student number , grade , College major .
4. List of book types ： Including the type of books , Number of species , The book information contained in each category .
5. Administrators ： Include administrator information , full name , account number id, Staff number .
6. Book return form ： It mainly includes the return information of books , Including all returned books , Return time , Returnee information .

3.3 System function design and division

** User registration ：** Mainly for borrowers and users , Borrower users need to register their account number first , Fill in your personal information , Facilitate later management and information retrieval . After registering your account , Users can log in to their own account to borrow .

** The borrower logs in to borrow ：** After the borrower logs into his account , You can query , You can query your borrowing information , Book information ; You can borrow and return books . When users borrow books , The system first searches the book table to confirm whether there is the book , If there is such a Book , Then the loan is successful , meanwhile , The book list subtracts the number of books by one , Add this borrowing information to the borrowing return form .

** Administrator background management ：** Administrators can log in to their own account , Query information , Delete , change . Query the borrowing and return information of books in the borrowing and return table of books , Query borrower information , Search for book information , When adding books , Book information can be added , In case of unexpected circumstances, the book information can be deleted , Delete the borrowing information in the borrowing return table , Delete the borrower, i.e. user information .

3.4 The data dictionary

name	describe	data type	Data length
Sid	Student ID	Characters(256)	256
Aid	Administrators ID	Characters(256)	256
Sname	The student's name	Characters(256)	256
Ssex	Student gender	Characters(256)	256
Sage	Student age	Int
Smajor	Student major	Characters(256)	256
Sgrade	Student grade	Characters(256)	256
Spassword	Student code	Characters(256)	256
Bid	The book ID	Characters(256)	256
Bname	The name of the book	Characters(256)	256
Bpress	Book publishers	Characters(256)	256
Bclassify	Book category	Characters(256)	256
Bquantity	Number of books	Int
Bauthor	Book author	Characters(256)	256
Aname	Administrator name	Characters(256)	256
Aage	Administrator age	Int
Awork	Administrator work	Characters(256)	256
Atel	Administrator phone	Characters(256)	256
Apassword	Administrator password	Characters(256)	256
Bdate	borrow / Return date	Date
Bkname	Book category	Characters(256)	256
Bkkind	Book category book	Int

4. Conceptual model design

5. Logical structure design

6. Database physical design

7. Database implementation

7.1 Each table shows

The book list

Student list

List of book types

Administrator table

Borrowing form and return form are initially empty

7.2 Inquire about

7.3 to update

Students borrow books

After the change, a record is added to the borrowing form

The administrator changes the number of books

Before change

After change

7.4 Delete

Administrators delete students

8. Design summary

The design of this database costs us a lot of time and energy . From the initial search for topics to demand analysis, and then to the later series of design and database implementation and improvement, we need the full cooperation of two people . Although we have done well in the beginning, this homework is certainly not easy to prepare , But I still didn't expect to encounter so many difficulties . for example , The opinions of the two people are not unified during the demand analysis ; Database code implementation does not know how to connect to the database and many other problems . But we finally overcame many difficulties and completed the design and implementation of the database under the condition of cooperation . As for the division of tasks between us —— There is a common participation in every basic step . It is worth mentioning that the database VC For the first time, we adopt the engineering design method in the code part of the access （ In the past, the design program was directly placed under one source file ）. The use of engineering design is more convenient for our division of labor and cooperation, and also makes the project structure and logic clearer .

For the database we designed this time , At the beginning of the design, we had a detailed discussion , Carefully analyze the requirements and draw the functional blueprint before writing the program , This allows us to design the database and write the program more clearly, saving a lot of time . This point can be used for reference in future courses —— First of all, you should know your purpose , That's how it works . At the same time, we deeply understand “1+1>2” The meaning of , Every idea may have limitations , At this time, we need to communicate with others in order to achieve better results .

Although we have spent a lot of effort on this library management system , But because of our limited ability and the rush of time , Therefore, it still has many deficiencies , For example, in dealing with the many to many relationship between books and students, the attribute of connection should be added to enhance the usability of the system ; In programming, we should consider the actual user experience GUI Interface and so on .

All in all , Completing the design of this database makes us learn a lot , At the same time, it also makes us realize our shortcomings and the way forward . In the future, we must correct our attitude towards learning computers and study hard , Strive to make a contribution to China's computer industry .

9. Part of the core code shows

The main function

Login check

Inquire about

to update

Delete