ABSTRACT

Library management system is a project which aims in developing a conputerized system to

maintain all the daily work of library. This project has many features which are generally not
availiable in normal library . This project has many features which are generally not availiable in
normal livary management systems like facility of user login and a facility of admin login . It also
has a facility of admin login through which the admin can monitor the whole system . It has also a
facility where stuudent after logging in their accounts can see list of books issued and its issue date
andd return date.

Overall this project of ours is being developed to help the students as well ass staff of library to
maintain the library in the best way possible and also reduce the human efforts.
 CHAPTER 1
INTRODUCTION

This chapter gives an overview about the aim, objectives , background and operation environment
of the system

1.1 PROJECT AIMS AND OBJECTIVES

The project aims and objectives that will be achieved after completion of this project are discussed
in this , this subchapter. The aims and objectives are as follows :
 online book issue
 Request column for librarain for providing new books
 Student login page where student can find books issued by him/her and date of return,
 A search colmn to search column to search availability of books
 A teacher login page where teacher can add any events being organized in the college
and important suggestions regarding books.
 Online notice board about the workshop.
1.2 BACKGROUND OF PROJECT :

Library Management system is an appilcation which refers to library systens which are generally
small or medium in size. It is used by librarian to manage the library using a computerized system
where he/she can record various transactions like issue of books, return of books, addition of new
books, addition of new student etc.

Books and student maintenance modules are also included in this system which would keep track of
the students using the library and also a detailed description about the book record or member
record which generally happens when a non computerized system is used.

In addition, report module is also included in Library Management System. If user’s position is
admin, the user is able to generate different kinds of reports like lists of students registered, list of
books, issue and return reports.

All these modules are able to help librarian to manage the library with more convenience and in a
more efficient way as compared to library systems which are not computerized.
1.5 OPERATION ENVIRONMENT :

PROCESSOR INTEL CORE PROCESSOR OR BETTER

PERFORMANCE
OPERATING SYSTEM WINDOWS VISTA, WINDOWS7, UBUNTU

MEMORY 1 GB OR MORE

HARD DISK SPACE MINIMUM 3 GB FOR DATABASE USAGE FOR

FUTURE
DATABASE MY SQL S
 CHAPTER 2
SYSTEM ANALYSIS

In this chapter, we will discuss and analyze about developing process of Library Management
System including sofrware requirement specification (SRS) and comparison between existting and
proposed system . This functional and non functional requirements are included in SRS part to
provide coplete description and overview of system requirement before the developing process is
carried out. Besides that , existing vs proposed provides a view of how the proposed system will be
more efficient then the existing one.

2.1 SOFTWARE REQUIREMENT SPECIFICATION

2.1.1 GENERAL DESCRIPTION

PRODUCT DESCRIPTION :
Libary Management System is a computerized system which helps user (libarian) to
manage the library daily activity in electronic format. It reduces the risk of paper
work such as file lost, file damaged and time consuming. It can help 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 human
environment . Some times 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 accdent like spilling
of water by some member on file accidentally. Besides some natural disaster like floods or
fires may also damage the files.

 Difficult to search record

when there is no computerezed system there is always a difficulty in searching of records if
the records are large in number.

 Space consuming
After the number of records become 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 the to add each record paper will be needed which will
increase the cost for the management of library .
2.1.2 SYSTEM OBJECTIVES

 Improvement in control and perfomance

The system is developed to cope up with the curret issues and problems of 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
library thus reducing the overall cost.

 Save time
livratian is able to search record by using few clicks of mouse and few search keywords thus
saving his valuable time.

 Option of online Notice board

Librarian will be able to provide a detailed description description of workshops going in the
college as well as in nearby colleges

 Lecture Notes
Teacher have a facility to upload lectures notes in a pdf file having size not more than
10 MB.

2.1.3 SYSTEM REQUIREMENT

2.1.3.1 NON FUNCTIONAL REQUIREMENTS

 Product Requirement

EFFICIENCY REQUIREMENT
When a library management system will be implemented libarian and user will easily
acess library as searching and book transaction will be very faster.

RELIABILITY REQUIREMENT
The system should accurately performs member registration , member validation,
report generation , book transaction and search

USABILITY REQUIREMENT
The system is designed for a user friendly environment so that student and staff of
library can perform the various tasks easily and in an effective way.

ORGANIZATIONAL REQUIREMENT
IMPLEMENTATION REQUIREMENT
In implementing whole system it uses html in front end with python as server side
scripting language which will be used for database connectivity and the backend ie the database part
is developed using mysql

DELIVERY REQUIREMENTS
The whole system is expected to be delivered in six months of time a weekly evaluation by
the project guide .
2.1.3.2 FUNCTIONAL REQUIREMENTS

1. NORMAL USER
1.1 USER LOGIN

Description of fearure
This fearure used by the user to login into system. They are required to enter user id and
password before they are allowed to enter the system. The user id and password will verified and if
invalid id is there user is allowed to not enter the system.

Functional Requirements

-user id is provided when they register

-The system must only allow user with valid id and password to enter the system
-The system performs authorization process which decides what user level can acess to .
-The user must be able to logout after they finished using system.

1.2 REGISTER NEW USER

Description of feature
This feature can be performed by all users to register new user to create account

Functional requirements
-System must be able to verify information
-System must be able to delete information if information is wrong

Admin Features

 Admin Dashboard
 Admin can add/update/delete category
 admin can add/update/delete author
 Admin can add/update/delete books
 Admin can issue a new book to student and also update the details when student return book
 Admin can search student by using their student ID
 Admin can also view student details
 Admin can change own password

Student -
 Student can register uourself and after registration they will get studentid
 After login student can viwe own dashboard
 Student can update own profile
 Student can view issued book and book return date-time
 Student can also change own password.
 Student cal also recover own password.
2.1.4 SOFTWARE AND HARDWARE REQUIREMENTS
This section describes the software and hardware requirements of the system.

2.1.4.1 SOFTWARE REQUIREMENTS

 Operating system – Windows 7 is used as the operating system as it is stable and supports
more features and is more is more user friendly
 Database MYSQL-MYSQL 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 Programing language – HTML is used to write the whole code and
debelop webpages with css , java script for styling work and python for sever side scripting.

2.1.4.2 HARDWARE REQUIREMENTS

 Intel core i5 2nd generation is used as processor because. It is fast than other processors an
provide reliable and stable and we can run our pc for longtime. By using this processor we
can keep on developing our project without any worries.
 Ram 1 gb is used as it will provide fast reading and writing capabilities and will in turn
support in processing.
2.2 EXISTING VS PROPOSED SYSTEM

i. Existing system does not have any facility of teachers login or student login where as
proposed system will have a fecility of student login as well as teacher’s login.

ii. Existing system does not have a facility of online reservation of books where as proposed
system has facility of online reservation of books

iii. Existing system does not have any facility of online notice board where description of
workshops happening in our college as well as nearby colleges is being provided.

iv. Existing system does not has any option of lectures notes uploaded by teachers where as
proposed system will have this facility.

v. Existing system does not have any facility to generate student reports as well book issue
reports where as proposed system provides librarian with a tool to generate reports.

vi. Existing system does not has any facility for book request and sugeestions where as in
proposed system after logging in to their accounts student can request books as well as
provide suggestions to improve library.
2.3 SOFTWARE TOOLS USED

The whole project is divided in two parats the front end and the back end .

2.3.1 Front end

The front end is designed using of html , css, Javascript

HTML – HTML ( Hyper Text Markup Language ) is the main markup language for creating
web pages and other information that can ve displayed in a web browser. HTML is writtern in the
form of HTML elements consisting of tags enclosed in angle brackets (like <html>) , within the
web page content . HTML tags most commanoly come in pairs like < h1> and </h1> and , although
some tags represent empty elements and so are unpaired , for example <img>. The first tag in a pair
is the start tag , and the second tag is the end tag ( they are also called opening tags and closing
tags) . In between these tags web designers can add text , further tags, comments and other types of
text-based content. The purpose of a web browser is to read HTML documents and compose them
into visible or audible web pages. The browser does not display the HTML tags , but uses the tags
to interpret the content of the page. HTML allows images and objects to be embedded and can be
used to create interactive forms. It provides a means to create structured documents by denothing
structural semantics for text such as headings , paragraphs, lists ,links ,quotes and other item. It can
embed scripts written in languages such as JavaScript which affect the behavior of HTML web
pages.

2.3.2 BACK END – The back end is designed using used to design the mysql which is databases
MYSQL – MYSQL ( “My S-Q-L”, officially, but also called “My Sequel” ) is (as of july 2013 ) the
world’s second most widely used open – source relational database management system
( RDBMS ). It is named after co-founder michael widenius daughter , My. The SQL phrase stands
for Structured Query Language. The My SQL development project has , made its source code
available under the terms of the GNU General Pubilc License, as well as under a variety of of
proprietary agreements. MySQL was owned and sponsored by a single for-profit firm , the Swedish
company MySQL AB, now owned by Oracal corporation . MySQL is a popular choice of database
for use in web application, and is a central component of the widely used LAMP open source web
application software stack (and other ‘AMP’stacks). LAMP is an acronym for “ Linux ,Apache,
MySQL, /Python. “Free-sofrware – open source project that require a full-featured database
management system often use MySQL. For commercial use, several paid editions are available, and
offer additional functionality. Applications which use MySQL database include : TYPO3, Joomla,
Wordpress,pythonBB, MyBB, Drupal and other software. MySQL is also used in many high-
profile, large-scale websites, including wikipedia, Google (though not for searches), Facebook,
Twitter, Flickr, and YouTube
 CHAPTER 3
SYSTEM DESIGN
3.1 TABLE DESIGN

VARIOUS TABELS TO MAINTAIN INFORAMTION

 Admin table

admin

Column Type Null Default Links to

Id (Primary) Int (11) No
Full name varchar(100) Yes NULL

Admin email varchar(120) Yes NULL

User Name varchar(100) No

Password varchar(100) No

Updation Date Timestamp No 0000-00-00 00:00:00

Indexes

Keyname Type Umique Packed Column cardinaliity collation Null comment

PRIMARY BTREE Yes No Id 1 A No

Table tblauthors track the details of authors

Tblauthors

Column Type Null Default Links to

Id primary Int (11) No
Author Name Varchar (159) Yes NULL
Creation Date Time stamp Yes CURRENT TIMESTAMP
Updation Date Time stamp Yes NULL

Indexs

Keyname Type Unique Packed Column Cardinality Collation Null comment

PRIMARY BTREE Yes No Id 6 A No
  Table Tblcategory Track Record of Category

tblcategory

Column Type Null Default Links to

Id (Primary) Int (11) No
Category Name Varchar (150) Yes NULL
Status Int (1) Yes NULL
Creation Date Timestamp Yes CURRENT TIMESTAMP
Updation Date Timestamp No

Indexs

Keyname Type Uaique Packed Column Cardinality Collation Null Comment

PRIMARY BTREE Yes No Id 4 4 No

 Table tbalbooks for books records

tblbooks

Column Type Null Default Links to

Id (Primary) Int (11) No

BookName Varchar (255) Yes Null

Cat id Int (11) Yes Null tblcateorgy>id
Authord Int (11) Yes Null Tblauthors>id
ISBN Number Int (11) Yes Null
Book Price Int (11) Yes Null
Reg Date Time stamp Yes CURRENT TIMESTAMP
Updation Date Time stamp Yes NULL

Indexes

keyname Type Unique Packed Column Cardinality Collation Null Comment

PRIMARY BTREE YES No Id 4 A No
  Table tblstudents for students record and student login details

tblstudents
Column Type Null Default Links to
Id (Primary Int (11) No
Student Id varchar(100) Yes NULL
FullName varchar(200) Yes NULL
Email Id varchar(120) Yes NULL
Mobile Number char(11) Yes NULL
Password varchar(120) Yes NULL
Status int(1) Yes NULL
RegDate timestamp Yes CURRENT
TIMESTAMP
UpdationDate timestamp Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collatiion Null comment

PRIMAR BTREE Yes No Id 7 A No
Y
Student BTREE Yes No Student 7 A Yes

Table tblissuedbook details for maintain issued book and returned book record
3.2 DATA FLOW DIAGRAMS
 CHAPTER 4
SYSTEM IMPLEMENTATION

4.1.1 Screenshot for homepage

USER SIGUP
Admin dashboard
 CHAPTER 5
SYSTEM TESTING

The aim of the system testing process was to detrmine all defects in our project. The program was
subjected to a set of test inputs and various observations were made based on these observations it
will be decided whether the program behves as expected or not. Our project went through two
levels of testing

1. Unit testing
2. integration testing

UNIT TESTING

Unit testing is undertaken when a module has been created and succesfully reviewed. In order to
test a single module we need to provide a complete enviroment ie, besides the module we would
require .

 The procedures belonging to other modules that the module under test calls
 Non local data structures that module accesses
 A procedure to call the function of the module under test with approprite parameters.

1. Test for the admin module

 Testing admin login form – This form is used for log in of administarator of
the system. In this we enter the username and password if both are correct
administration page will open other wise if any of data is wrong it will gett redirected
back to the login page and again ask for username and password.

 Student account addition – In this section the admin can verify student details
from student academinc info and then only add student details to main library database it
contains add delete buttons if user click add button data will be added to student database
and if he clicks delete button the student data willll be deleted
 Book Addition – Admin can enter details of book and can add the details to
the main book table also he can view the books requests.

2. Test for Student login module

 Test for Studet login Form – This form is used for log in of Student. In this
we enter the libraryid, username and password if all these are correct student login
page will open other wise if any of data is wrong it will get redirected back to the
login page and again ask for libraryid, username and password.
 Test for account creation – This form is used for new account creation when
student does not fill the form completely it again to fill the whole form when he fill
the form completely it asks again to fill the whole form when he fill the forrm fully
it gets redirected to page which show waiting for conformation message as his data
will be only added by administrator after verification.
3. Test for teacher login module -
 Test for Student login form – This form is used for logg in of teacher. In this we
enter the username and password if all these are correct teacher login page will
open other wise if any of data is wrong it will get redirected back to the login page
and again ask for username and password.
 INREGRATION TESTING

In this type of testing we test various integration of the project module by providing the input .The
primary objective is to ttest the module interfaces in order to ensure that no errors are occurring
when one module invokes the module .
 CHAPTER 6

CONCLUSION & FUTURE SCOPE

This website provides a computerized version of library management system which will
benefit the student as well as the staff of the library.

It makes entire process online wherer student can search books, staff can generate reports and
do book transactions. It also has a faccility for student login where student can login and can
see status’s login where teachers can add lectues notes and also give necessary suggestion to
library and also add info about workshops or events happening in our college or nearby
college in the online notice board.

There is a future scope of this facility that many more features such as online lectures video
tutorials can be added by teachers as online assignments submission facility , a feature of
group chat where students can discuss various of engineering can be added to this project thus
making it more interactive more usert frienndly and project which fulfills each users need in
the best way possible.