PROJECT INTRODUCTION

This project of LIBRARY MANAGEMENT of gives us the complete information about the library. We can enter the record of new books and retrieve the details of books available in the library. We can issue the books to the students and maintain their records and can also check how many books are issued and stock available in the library. In this project we can maintain the late fine of students who returns the issued books after the due date. Throughout the project the focus has been on presenting information and comments in an easy and intelligible manner. The project is very useful for those who want to know about Library Management System. The Library Management System is designed & developed for a receipt and issuance of books in the library along with the students details. The books received in the library are entered in Books Entry form and the new student is entered in the student entry form.

INTRODUCTION OF THE ORGANIZATION

Public libraries are in service for more than six decades in Nepal. There are many public/community libraries registered in Nepal. Moreover, those which are functional are either poorly equipped or do not have the resources or the means to cater to the needs of a modern society. Following the definition of UNESCO/IFLA, public libraries are not yet established in Kathmandu. The need for a public library service that not only is well organized and equipped but also is tailored to meet the needs of the Nepali people in the 21st century was discussed among the academicians, educationist, diplomats, politicians, lawyers, industrialists and journalists in June 2003. The meeting decided to form a committee for the establishment of a modern library in Kathmandu. The committee formed the Society for Kathmandu Valley Public Library. This Society was registered with the government on 25 September 2003. The idea for a central public library seems to be gaining unanimous public acceptance. The Society started the public library in a limited way both in respect of housing the readership and providing public services at Bhrikutimandap, Kathmandu from 9 July 2005. The Society is overwhelmed by the ever-increasing public response in its favor. People of every walk have expressed their appreciation and support for the initiatives. Within a very short period of time distinguished personalities such as former prime ministers of Nepal, Speaker of the House of Representatives, senior leaders of various political parties, former ambassadors and academics have visited the library and donated their collections. We are also encouraged by the support we have been receiving from the diplomatic community.

Organization chart

Library Manager

Library Assistant

Library IT Assistant

Junior Office Assistant

Junior Office Assistant(Admin)

Data Entry Operator

Computer Assistant

Fig-1

Problem Analysis/Identification of problem

Tediousness for the librarian to remember the detail information of books stored in the library. Intricateness to remember every act occurred in the library like issue of books, return of books, reservation of books etc. Difficulty for management to take any decisions related to library as up-to-date information is not provided to them. Time consuming.

This kind of problem when arises in a library, there is need of an information system. Therefore, in our project we will try to design a new system that will solve these problems. With the help of new information system it will be easy to track records of books in stock, issued and returned by a simple click. Automatic updates will be possible. Therefore a good library information system will assist the main librarian and the managers to decide on different matters for e.g. they can decide which books are necessary to buy on the basis of demand of books. They can easily know which books are required by the people and hence they can make those books available in near future. It will be more informative for management processes.

DESIGN OF NEW INFORMATION SYSTEM Entity-Relationship Diagram

Total books

Book id
Provide Information Provide Information

member id

Name Age

Library

member

Author Book title

Address

Contact

Book

Book return

issue

Stock Query

Reserved book book Status

Fig 2: E-R Diagram

DATA FLOW DIAGRAM (DFD)

t lis st erer li b em b mmem de try y vi de en ntr rorovi r e PP be er emmb M e M try y en tr k k en oo BBoo

ok ok bo to etsb qus eue eq RR

u Iss eb

Library information system

Librarian

RRtu ee r tunn o r bbok ook

Member

Delete book Delete book

Search book Search book

Delete member Delete member Search member Search member

Fig 3: Data Flow Diagram

INPUT FORM DESIGN 1. Membership Form

Membership Form

Date:Member Id Name Sex Age Postal Address Telephone E-mail Profession

2. Book Entry Form

Book Entry Form

Date:Book Id Book Title Author Publication Edition Category

Price
OK CANCEL

3. Issue Form

Issue Form Issue Id Member Id Book Id Book Title Issue Date

4. Book Return Form

Book Return Form Member Id Book Id Book Title Issue Date Return Date
OK CANCEL

10

Output Form Design

Search By Category Category

Book Id

Title

Author

Publication

Edition

Status

Print

11

Menu Design

Library Information System Member

Book

Search

Create Member

Fig: Member Menu

Search

Edit Details

Fig : Book Menu

Fig: Search Menu

12

TABLE DESIGN Account: Table 1

S.No. 1 2 3 4

Field Name Accno Total_limit Books_left Status

Data Type Number Number Text Text

Issue: Table 2

S.No. 1 2 3 4 5

Data Type Bno Number Id Number Issue_date Date/time Due_date Date/time Copies_available Number

Field Name

User: Table 3

S.No. 1 2 3 4

Field Name Id Roll_no Name Branch

Data Type Number Number Text Text

Book: Table 4

S.No. 1 2 3 4 5 6 7 8 9

Field Name B_no ISBN Subject Name Author Publisher Editor Copies Cost

Data Type Number Number Text Text Text Text Number Number Number

Issue_return : Table 5

S.No. 1 2 3 4 5 6 7

Field Name B_no Id Issue_date Due_date Return_date Fine Copies_available

Data Type Number Number Date/Time Date/Time Date/time Number Number

14

CONCLUSION

Information plays a critical factor for any organization may it be a profit oriented or a service oriented organization. Most of the schools, colleges and many other educational institutions have a library of itself. With the growing popularity of computerized system, among many of them, it may be in use. Though we have designed the library information system keeping in mind the requirements of this organization, it will also prove beneficial also to those organizations who lack a proper information system. During our project we have tried our level best to design an information system that will minimize most of the problems but there is always a way for improvement. In our future if given an opportunity we will surely make it better than now.

During the project we were able to analyze the matter of MIS in more practical manner. We have now become more confident about this subject than before. More than that, it gave us an opportunity to learn about new programs as well. Besides using usual Microsoft Word, Excel, visual basic and all we learned Microsoft office Visio 2003.

15

References:

1. Management Information System(8th Edition), Kenneth C. Laudon & Jane P. Laudon 2. Introduction to Management Information System, Shanker Adhikari 3. http://www.123eng.com/projects/library_management.html

16

17