The library management system is a project which aims at developing a computerized system to maintain all the daily work of the library. This project has many features which are generally not available in normal library management systems like facility of user login and a facility of teacher login. Through admin login, admin can monitor the whole system. In student login, after logging into their accounts they can see a list of books issued and its issue date and return date and also the students can reserve the books. This paper briefly discusses about automating the Library Management System, and application of Barcode technology in the library of the department of Electronics and Communication, Vidyavardhaka College of Engineering.
Overall, this project of ours is being developed to help the students as well as staff of the library to maintain the library in the best way possible and also reduce the humanitarian efforts. KeywordsLibrary Management System, Admin, Users, Barcode, Database Introduction The library plays a critical role in our society. It is an important component of any educational institution, which is the hub of the teaching, and learning activities where students, researchers and teachers can explore the vast resources of information. The biggest characteristics of the department library are a highly professional book collection that provides a convenient conditions for teachers and students to access information. But with largely increasing number of the librarys books, the traditional manual operation management is very low efficiency.
Therefore, it is necessary for teachers and students of the university to use the modern library management technique. In most of the libraries, working is still done manually. It is inherited the problems associated with Books issue, reissue, return all this activity are done by librarian and it also increases the labor cost. . So instead of doing this manually, we are creating the system named as Library Automation System.
The advancement and proliferation of computer and communication technologies and cost reduction coupled with the affordable relational database management systems (RDBMS) for data management, have resulted in the development of library management systems (LMS) more appropriately. In our project we are going to design a computerized system to maintain the everyday work of the library. In this system user can get all information on the books, they can check the availability, reserve and renew the books through the internet. They will also get to know return date of the book through Email alerts. Library Management System Use Case The most important part of the analysis phase is the establishment of the use case diagram, which includes two entities, Librarian and users. This describes the role of each entity.
Figure 1Library Management System Use Case According to the above analysis, figure1 shows the system overall use case diagram. The system administrator can manage the information of books and users, generate reports and can Charge fine in case of late return. As well as, the users can inquiry, reserve, borrow and return the books. SYSTEM ANALYSIS The Library Management System is a computerized system which helps users to manage the library daily activity in electronic format.
It reduces the risk of paperwork such as file list, file damaged and time consuming. It can help the user to manage the transaction or record more effectively and time-saving. Problem Statement The problem occurred before having computerized system includes File lost When computerized system is not implemented file is always lost because of the human environment. Sometimes due to some human error, there may be a loss of records.
File damage When a computerized system is not there file is always lost due to some accident like the spilling of water by some member to file accidentally. Besides some natural disaster like floods or fires may also damage the files. Difficult to search record When there is no computerized system, there is always a difficulty in searching of records if the records are large in number. Space consuming After the number of records becomes large the space for physical storage of file and records also increases if no computerized system is implemented.
Cost consuming As there is no computerized system, to add each record paper will be needed which will increase the cost of the management of the library. System Objectives Improvement in control and performance The system is developed to cope up with the current issues and problems of the library. The system can add user, validate user and is also bug free. Save cost After computerized system is implemented less human force will be required to maintain the library thus reducing the overall cost.
Save time Librarian is able to search record by using few clicks of the mouse and few search keywords, thus saving his valuable time. Usage of Barcode technology for borrowing and returning of books Inventory management Report generation Software and Hardware Requirements Software Requirements Operating system Windows 8 is used as the operating system as it is stable and supports more features and is more user friendly . Database MS-SQL 2017 Database Server Community Ed is used as database as it easy to maintain and retrieve records by simple queries which are in English language which are easy to understand and easy to write. Development tools and Programming language Visual Studio 2017 Community Edition used at the back end where c is used to write the whole code and develop web pages. MS Internet Information Service for hosting website Hardware Requirements Barcode reader Barcode printer PC running Windows XP or above OS Existing vs Proposed System Table1 Comparison of Existing and Proposed System Advantages of Using Barcode Technology Application of bar code technology is made in the libraries with a view to automate the data entry process of the circulatory system. The use of barcode technology increases efficiency and eliminates human errors as in case of manual data entry.
It Increases the speed of operation. Figure 2 Typical Barcode and Handheld Reader Increased accuracy of data input. It Improves efficiency of the staff and quality of services Real time data collection Highest degree of reliability Saves the time of borrower Perfect entry and retrieval of data Labor savings by avoiding manual system Improves information availability and data integrity. Database Figure 3 Database Management System A database is an organized collection of data.
It is the collection of schemas, tables, queries, reports, views, and other objects. The data are organized to model aspects of reality in a way that supports processes requiring information DBMS is computer software application that interacts with end-users, other applications and database itself to capture and analyse the data. Admin Module Admin is the default user. By setting up the connection string and entering the email id and password, Library management console will open with the dashboard which shows the details of books, volumes, books lent and due/overdue books.
He/she is given with various functionalities like to add/modify the details of users and books, transactions and reports can be generated. User Module User will get into the Library User Portal by entering the username and password, where they can Search, Reserve and Renew the books. Working Figure 4 Working of Automated Library System When a library member wants to issue any book from library, all that is required by a member is to scan the ID cards having barcode. Once this card is scanned with the help of barcode scanners, the circulation counter assistant will come to know about credentials of the borrower. Having satisfied with the identity of borrower, barcode pasted on the document will be scanned in order to complete the issue process.
It is also worthy pointing out here that at the time of return, all that needed is to submit the issued document at the circulation counter. Once the barcode label pasted on the document is scanned, all the information about the borrower, issue date, due date etc. will be highlighted on the screen of computer. In this way, barcode technology has played an important role in elimination of long queues in libraries at the circulation counter. Login Process Figure 5 Admin Login Unit The librarian has the special privilege of having a unique master password for controlling the LMS system.
The login dialogue box appears where he enters username and the corresponding password and enables the system for further usage. Librarian Interface Figure 6 Dashboard Figure 7 Book Transaction Unit The database control is given to the librarian so that he/she can access it. Even then, we have created an option of viewing the transactions that have taken place. The search is made easy by giving him/her to search history according to the userid or bookid. Hence manual errors are removed and transactions have been more automated than before. Various actions of the UI like add, delete, issue re-issue and search by name, email-id have been displayed.
User Interface Figure 8 User Login Unit Figure 9 Library User Self Help Portal The library website is developed, where each member of the library can access his/her account. They can view personal transaction details, the book availability, they can also reserve and renew it. This reduces time taken for transactions and standing in long queue as data is automatically uploaded. As internet is widely available, this can be reached to a large amount of users, irrespective of variation in devices. Now a day Library Automation has become the buzz word in the library profession and has become a bare necessity for any libraries.
An automated library can provide a computerized version of library management system which will benefit the students as well as the staff, which a manual library cant do and saves the time and reduces labor resource. Barcode Technology used here to improve accuracy and eliminates the typing errors. The record keeping activities and various report generation become very easy with an automated library system. But the success of any library automation program depends upon its proper planning and execution.
