Library management system

ABSTARCT :

With the advancement of technology, it is imperative to exalt all the systems into a user-friendly manner. The Library Management system (LMS) acts as a tool to transform traditional libraries into digital libraries. In traditional libraries, the students/user has to search for books which are hassle process and there is no proper maintenance of database about issues/fines. The overall progress of work is slow and it is impossible to generate a fast report. The librarians have to work allotted for arranging, sorting books in the book sells. At the same time, they have to check and monitor the lend/borrow book details with its fine. It is a tedious process to work simultaneously in different sectors. LMS will assist the librarians to work easily. The LMS supports the librarians to encounter all the issues concurrently. The users need not stand in a queue for a long period to return/borrow a book from the library. The single PC contains all the data’s in it. The librarians have to assess the system and provide an entry in it. Through LMS the librarian can find the book in the bookshelves. The LMS is designed with the basic features such as librarian can add/view/update/delete books and students' details in it. Once he/she ingress into the system they can modify any data’s in the database. The complete model is developed in Dot net technology, the C# language is used to build the front end application whereas the SQL server is exploiting as database. The authorized person can only access the LMS system, they have to log in with their user id and password. As aforementioned that the LMS is designed in a user-friendly manner, so the admin can smoothly activate the system without expert advice. Every data is storing and retrieving from the SQL database so it is highly secure. Thus our system contributes its new approach towards the digital library setup.

EXISTING SYSTEM :

? Early days Libraries are managed manually. It required lot of time to record or to retrieve the details. The employees who have to record the details must perform their job very carefully. Even a small mistake would create a lot of problems. Security of information is very less. Report generations of all the information is very tough task. ? Maintenance of Library catalogue and arrangement of the books to the catalogue is very complex task. In addition to its maintenance of member details, issue dates and return dates etc. manually is a complex task. ? All the operations must be performed in perfect manner for the maintenance of the library with out any degradation which may finally result in the failure of the entire system.

DISADVANTAGE :

? It has more additional features such as librarian can maintain library records, student’s history of penalties and issues. ? It always tracks the count of the book in the library and issued book details. ? The Admin can add students/Book details, issues the book, return the book, view/update the book, and view/update the student details. ? Based on the scheme of DBMS, the system can assign a view mode for each user like some people can see only some data and authorized one can see all the data existing in the database. It offers both logical and physical data independence.

PROPOSED SYSTEM :

• The students will register them through Online • Individually each member will have his account through which he can access the information he needs. • Book details like authors, number of copies totally maintained by library, present available number of books, reference books, non-reference books etc. all this information can be made handy. • Regarding the members designation, number of books was issued. • Issue dates and returns of each member is maintained separately and fine charged if there is any delay in returning the book. • Administrator can add, update the books. • Time consuming is low, gives accurate results, reliability can be improved with the help of security.

ADVANTAGE :

? Numerous tedious processes reduce the efficiency of the library. For example, it always needs manual support to do any activities in the traditional library. ? This system will support the librarians to work very fast and efficient. ? The LMS reduces labor work and makes the system efficient. ? We planned to enhance the LMS by integrating the LMS with Local area Network (LAN) which increases the efficiency of the system. ? SQL is also known as Standard Query Language which is used as a medium for communicating with the database. SQL statements are utilized to execute the queries against the database and retrieve data from the database.