Noida Public Library is the biggest library in Noida. A person who is 18 or above can become a member. There is a membership fee of Rs 400 for a year. There is a form to be filled in which person fills personal details. These forms are kept in store for maintaining members’ records and knowing the membership period. Whenever a member wishes to issue a book and there are spare cards, then the book is issued. Otherwise that request is not entertained. Each book is to be returned on the specified due date. If a member fails to return a book on the specified date, a fine of Rs 2 per day after the due return date is charged. If in case a card gets lost then a duplicate card is issued. Accounts are maintained for the membership fees and money collected from the fines. There are two librarians for books return and issue transaction. Approximately 100 members come to library daily to issue and return books. There are 5000 books available out of which 1000 books are for reference and cannot be issued. These records contain details about the publisher, author, subject, language etc. There are suppliers that supply books to the library. There are other problems also that the library staff is facing. Like in case of issue of duplicate cards to a member when member or library staff loses the card. It is very difficult to check the genuinity of the problem. Sometimes the library staff needs to know about the status of a book as to whether it is issued or not. So to perform this kind of search is very difficult in a manual system. Also management requires reports for books issued, books in the library, members, and accounts. Manually producing the reports is a cumbersome job when there are hundreds and thousands of records.
Due to the problems faced by the library staff and its expansion plans, the management is planning to have a system that would first eradicate the needs of cards. A system to automate the functions of