A Project Report on LIBRARY MANAGEMANT

Submitted in Partial fulfillment of the requirements for qualifying BCA Final Year.

SUBMITTED BY: NARAYAN LIMBU ENROLMENT NO : 0800410333 CENTER CODE :2506

Under the Guidance of

DATE OF SUBMISSION:

CERTIFICATE
This is to certify that the Project / Dissertation entitled, LIBRARY MANAGEMANT is a bonafide work done by NARAYAN LIMBU in partial fulfilnlment of Bachelor of Computer Application (BCA) examination and has been carried out under my

supervision and guidance. This report or a similar report on the topic has not been submitted for any other examination and does not form a part of any other course undergone by the candidate.

Signature of Project Guide

..

STUDENT DECLARATION

hereby

declare

that

the in

project partial of

entitled

LIBRARY of the

MANAGEMANT
requirements for

submitted the

fulfillment of

degree

Bachelor

Computer

Application(BCA) to KRISHNA KANTA HANDIQUE STATE OPEN UNIVERSITY is my original work and not submitted for the award of any other degree, diploma, or any other similar title or prizes.

Place: TEZPUR Dated:

NARAYAN LIMBU

BDPS computer education university center & Indian Technical Institute TEZPUR

ACKNOWLEDGEMENT

Doing this project has been the process of constant learning and exploring new thoughts and ideas. And it is only right that I take this opportunity to express our heartfelt thanks to our motivation behind it. I express my deep gratitude to our project guide , IT. Faculty of Krishna kanta handique state open University Learning Centre Tezpur, whose patient

hearing and immense knowledge helped us a lot. His expert advice timely suggestion and valuable guidance saw me the way of making this project. I express my heartfelt thank to --------------, Centre Directors Star Technology Sikkim University Learning Centre Tezpur, who sat with me and finalized the report work and took great interest in my project work. Necessary matters of this project.

Last but not the least I also like to thank my friends, who with their assistance and co-operation helped me in the successful completion of this project.

Place: Tezpur Date: / / 2011 NARAYAN LIMBU

CONTENTS

 Abstract  INTRODUCTION  REQUIREMENT ANALYSIS

o Functional Requirement o Non Function Requirement

 FEASIBILITY STUDY
o Technical o Economical o Operational

 System Analysis o Existing System o New System  FUTURE SCOPE  Software Requirement Specification  DESIGN GOALS AND CONSTRAINTS
y y y y y y

Performance Availability Reliability Scalability Security Interoperability

 Database Design  Data Dictionary

 Data Flow Diagram

 SYSTEM DESIGN
y y y y y y y

Introduction Input design Output design Form design Database design Logical design Physical design

 Coding
 TESTING & IMPLEMENTATION
SYSTEM PLANNING (PERT CHART)

 USER /OPERATIONAL MANUAL y Security aspect y Access right back up control  Conclusion

ABSTRACT

The project entitled LIBRARY MANAGEMANT aims to model the working of an Library Management System for academic project purpose. The project has been developed and tested on the VB.NET platform, uses visual basic as programming languages and SQL 7.0 as back end. This Project is built to model the Addressing library management system as closely as possible

Introduction

Decision making is a fundamental part of the research process. Decisions regarding that what you want to do, how you want to do, what tools and techniques must be used for the successful completion of the project. In fact it is the researchers efficiency as a decision maker that makes project fruitful for those who concern to the area of study.

Basically when we are playing with computer in every part of life, I used it in my project not for the ease of my but for the ease of result explanation to those who will read this project. I had toiled to achieve the goals desired. Being a neophyte in this highly competitive world of business, I had come across several difficulties to make the objectives a reality. I am presenting this hand carved efforts in black and white. If anywhere something is found not in tandem to the theme then you are welcome with your valuable suggestions.

PROJECT

PROFILE

Project Title Organizations

: LIBRARY MANAGEMANT :

Hardware Operating System DBMS Documentation tool Project Guide

: Pentium4, 512 MB RAM : Windows Xp Professional : Sql 7.0 : Microsoft word : (Lecturer of BDPS COMPUTER EDUCATION ,Tezpur

Requirement Analysis

Revision History
Date 16/Oct/2006 01/Dec/2006 03/Dec/2006 Version 1.0 1.1 1.2 Description Software Requirements Specification Document Initial Release. Software Requirements Specification Document Release 1.1. Software Requirements Specification Document Final Release. Author Author Author Author

Software Requirements Specification

Introduction
Borrowing books, returning books or viewing the available books at the Library of the local University is currently done manually where in the student has to go to the Library and check the available books at the Library. Students check the list of books available and borrow the books if the book is a borrow book otherwise it is of waste for the student to come to the library to come to check for the books if the student doesnt get the book. Then the librarian checks the student id and allows the member to check out the book and the librarian then updates the member database and also the books database. This takes at least one to two hours if the member is available at the near by place otherwise it may take more time. We have decided to investigate the use of an Online Library Management System. This system would be used by members who may be students or professors of that University to check the availability of the books and borrow the books, and by the librarian to update the databases. The purpose of this document is to analyze and elaborate on the high-level needs and features of the Online Library System. It focuses on the capabilities and facilities provided by a Library. The details of what all are the needs of the Online Library System and if it fulfils these needs are detailed in the use-case and supplementary specifications.

Purpose
The purpose of Software Requirements Specification (SRS) document is to describe the external behavior of the Online Library System. Requirements Specification defines and describes the operations, interfaces, performance, and quality assurance requirements of the Online Library System. The document also describes the nonfunctional requirements such as the user interfaces. It also describes the design constraints that are to be considered when the system is to be designed, and other factors necessary to provide a complete and comprehensive description of the requirements for the software. The Software Requirements Specification (SRS) captures the complete software requirements for the system, or a portion of the system. Requirements described in this document are derived from the Vision Document prepared for the Online Library System.

Scope
The Software Requirements Specification captures all the requirements in a single document. The Online Library System that is to be developed provides the members of the Library and employees of the library with books information, online blocking of books and many other facilities. The Online Library System is supposed to have the following features. y y y The product provides the members with online blocking of books capabilities and the Online Library System is up and running all day. The system provides logon facility to the users. The system provides the members with the option to check their account and/or change their options like password of the account whenever needed all through the day during the library hours. The system allows the members to block the books 24 hours a day and all the through the semester. The system lets the library staff to check which all members have blocked the books and whether they can borrow any more books or not. The system allows the Librarian to create the books catalog, add/delete books and maintain the books catalog. The system updates the billing system as and when the member borrows or returns a book. The book catalog is automated and the decision of offering the book based on the category of the book is automatically decided. We also have an order department, which manages to add or remove a book from the Library.

y y y y y y

The features that are described in this document are used in the future phases of the software development cycle. The features described here meet the needs of all the users. The success criteria for the system is based in the level up to which the features described in this document are implemented in the system.

Definitions, Acronyms and Abbreviations

y y y UHCL University of Houston-Clearlake. Provided wherever necessary in the document. PIN Personal Identification Number

References
The SRS document uses the following documents as references: 1.4.1 UHCL Information Security Requirements: To provide security to the system based on the current security system currently used by UHCL. 1.4.2 The Billing System: To provide the interface between the system being developed and the billing system currently in use by UHCL to update the member account due as and when they borrow and return the books.

Overview
The SRS will provide a detailed description of the Online Library System. This document will provide the outline of the requirements, overview of the characteristics and constraints of the system. 1.5.1 Section 2: This section of the SRS will provide the general factors that affect the product and its requirements. It provides the background for those requirements. The items such as product perspective, product function, user characteristics, constraints, assumptions and dependencies and requirements subsets are described in this section. 1.5.2 Section 3: This section of SRS contains all the software requirements mentioned in section 2 in detail sufficient enough to enable designers to design the system to satisfy the requirements and testers to test if the system satisfies those requirements.

Overall Description
y Product Perspective The Online Library System is a package to be used by Libraries to improve the efficiency of Librarians, Library employees and Users. The Online Library System to be developed benefits greatly the members and the Librarian of University of Houston-Clearlake. The system provides books catalog and information to members and helps them decide on the books to borrow from the library. The Librarian can keep the books catalog updated all the time so that the members (students and the professors) get the updated information all the time. The complete overview of the system is as shown in the overview diagram below: The product to be developed has interactions with the users: Librarian, Members who are the students and professors of the UHCL. The product has to interact with other systems like: Internet, Billing System and the UHCL Information Security System.

Librarian

Billing System

The Proposed Library Management System

UHCL Information Security System

Users

Internet

Overview of the proposed system

y Product Functions
The Online Library System provides online real time information about the books available in the Library and the user information. The Product functions are more or less the same as described in the product perspective. The functions of the system include the system providing different type of services based on the type of users [Member/Librarian]. y y y y y y y The member should be provided with the updated information about the books catalog. Provisions for the members to borrow the books they want, if all the other required rules hold good. The member is given a provision to check his account information and change the account information any time in the given valid period. The members are provided with the books available roster and allowed to choose the books, which they want to use in the coming up days. The librarian can get the information about the members who have borrowed or returned the books. The librarian is provided with interfaces to add/delete the books available in the book catalog. The members when complete the book borrowing or returning process, the due to be paid by the member must be calculated and the information about the member and the due amount is sent to the university billing system. The system uses the University information security requirements to provide the login facility to the users.

User characteristics
The users of the system are members, librarian of the university and the administrators who maintain the system. The members and the librarian are assumed to have basic knowledge of the computers and Internet browsing. The administrators of the system to have more knowledge of the internals of the system and is able to rectify the small problems that may arise due to disk crashes, power failures and

other catastrophes to maintain the system. The proper user interface, users manual, online help and the guide to install and maintain the system must be sufficient to educate the users on how to use the system without any problems.

Constraints
y y y y y y The information of all the users must be stored in a database that is accessible by the Online Library System. The university information security system must be compatible with the Internet applications. The Online Library System is connected to the university computer and is running all 24 hours a day. The users access the Online Library System from any computer that has Internet browsing capabilities and an Internet connection. The billing system is connected to the Online Library System and the database used by the billing system must be compatible with the interface of the Online Library System. The users must have their correct usernames and passwords to enter into the Online Library System.

Assumptions and dependencies

y y y y The users have sufficient knowledge of computers. The University computer should have Internet connection and Internet server capabilities. The users know the English language, as the user interface will be provided in English The product can access the university student database

Specific Requirements
This section describes in detail all the functional requirements.

Functionality
Logon Capabilities
The system shall provide the users with logon capabilities.

Mobile Devices
The Online Library System is also supported on mobile devices such as cell phones.

Alerts
The system can alert the Librarian or the administrator in case of any problems.

Usability
y y y The system shall allow the users to access the system from the Internet using HTML or its derivative technologies. The system uses a web browser as an interface. Since all users are familiar with the general usage of browsers, no specific training is required. The system is user friendly and self-explanatory.

Reliability
The system has to be very reliable due to the importance of data and the damages incorrect or incomplete data can do.

Availability
The system is available 100% for the user and is used 24 hrs a day and 365 days a year. The system shall be operational 24 hours a day and 7 days a week.

Mean Time Between Failures (MTBF)

The system will be developed in such a way that it may fail once in a year.

Mean Time to Repair (MTTR)

Even if the system fails, the system will be recovered back up within an hour or less.

Accuracy
The accuracy of the system is limited by the accuracy of the speed at which the employees of the library and users of the library use the system.

Maximum Bugs or Defect Rate

Not specified.

Access Reliability
The system shall provide 100% access reliability.

Performance
Response Time
The Splash Page or Information page should be able to be downloaded within a minute using a 56K modem. The information is refreshed every two minutes. The access time for a mobile device should be less than a minute. The system shall respond to the member in not less than two seconds from the time of the request submittal. The system shall be allowed to take more time when doing large processing jobs.

Administrator/Librarian Response
The system shall take as less time as possible to provide service to the administrator or the librarian.

Throughput
The number of transactions is directly dependent on the number of users, the users may be the Librarian, employees of the Library and also the people who use the Library for checking-out books, returning books and checking online library account.

Capacity
The system is capable of handling 250 users at a time.

Resource Utilization
The resources are modified according the user requirements and also according to the books requested by the users.

Supportability
The system designers shall take in to considerations the following supportability and technical limitations.

Internet Protocols
The system shall be comply with the TCP/IP protocol standards and shall be designed accordingly.

Information Security Requirement

The system shall support the UHCL information security requirements and use the same standard as the UHCL information security requirements.

Billing System Data Compatibility

The member balance amount that will be calculated and sent to the billing system shall be compatible with the data types and design constraints of the billing system.

Maintenance
The maintenance of the system shall be done as per the maintenance contract.

Standards
The coding standards and naming conventions will be as per the American standards.

Design Constraints
Software Language Used
The languages that shall be used for coding the Online Library System are Active Server Pages (ASP), Java Servlets, Java Server Pages (JSP), HTML, JavaScript, and VBScript. For working on the coding phase of the Online Library System, the Internet Information Services (IIS) Server needs to be installed.

Development Tools
Will make use of the available Java Development Tool kits for working with Java Beans and Java Server Pages. Also will make use of the online references available for developing programs in ASP, HTML and the two scripting languages, JavaScript and VBScript.

Class Libraries
Will make use of the existing Java libraries available for JSP and Servlets. Also we need to develop some new libraries for the web-based application. Also will develop new programs using ASP and scripting languages.

On-line User Documentation and Help System Requirements

Online help is provided for each of the feature available with the Online Library System. All the applications provide an on-line help system to assist the user. The nature of these systems is unique to application development as they combine aspects of programming (hyperlinks, etc) with aspects of technical writing (organization, presentation). Online help is provided for each and every feature provided by the system. The User Manual describes the use of the system to Librarian and Employees. It describes the use of the system on mobile systems. The user manual should be available as a hard copy and also as online help. An installation document will be provided that includes the installation instructions and configuration guidelines, which is important to a full solution offering. Also, a Read Me file is typically included as a standard component. The Read Me includes a Whats New With This Release section, and a discussion of compatibility issues with earlier releases. Most users also appreciate documentation defining any known bugs and workarounds in the Read Me file. Since the installation of Online Library System is a complex process, our experts will do it. So an installation Guide will not be provided to the user.

Purchased Components
The System Administrator will need to purchase the license for IIS Server. Mostly it is available with Windows Environment. So the system need not purchase any licensing products.

Interfaces
User Interfaces
Will make use of the existing Web Browsers such as Microsoft Internet Explorer or Netscape. The userinterface of the system shall be designed as shown in the user-interface prototypes. Logon Screen Prototype:

Home Page Of UHCL Library Prototype:

Member Registration Screen:

Member Information once Logged in:

Main Search Page of Library Catalog:

Hardware Interfaces
The existing Local Area Network (LAN) will be used for collecting data from the users and also for updating the Library Catalogue.

Software Interfaces
A firewall will be used with the server to prevent unauthorized access to the system.

Communications Interfaces
The Online Library System will be connected to the World Wide Web.

Licensing Requirements
The usage is restricted to only University of Houston-Clearlake Library who is purchasing the Online Library System from Library InfoSys and signs the maintenance contract.

Legal, Copyright, and Other Notices

Online Library System is a trademark of Library InfoSys and cannot be used without its consent.

Applicable Standards
The ISO/IEC 6592 guidelines for the documentation of computer based application systems will be followed.

Supporting Information
The use-case storyboards or the user-interface prototypes are not available. The appendices are not to be considered as part of the requirements.