Library Management System
Library Management System
Library Management System
DEPARTMENT
OF
COMPUTER SCIENCE & ENGINEERING
Project Report
On
LIBRARY MANAGEMENT
SYSTEM
SUBMITTED BY:
JAMILA SULTANA (ID NO- 1302510200574)
AKID HASSAN REFATH (ID NO - 1302510200575)
MAMA CHAWKRABORTY (ID NO 1302510200581).
RIMON MOHAJON (ID NO -1302510200586)
BRISTY MAJUMDAR (ID NO - 1302510200588)
SUPERVISED BY
MOHAMMAD HASAN
COURSE INSTRUCTOR
LECTURER, DEPT.OF CSE
APRIL- 2016
Abstract
Library management system is a project which aims in developing a
computerized system to maintain all the daily work of 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 teachers login
.It also has a facility of admin login through which the admin can monitor the
whole system .It also has facility of an online notice board where teachers
can student can put up information about workshops or seminars being held
in our colleges or nearby colleges and librarian after proper verification from
the concerned institution organizing the seminar can add it to the notice
board . It has also a facility where student after logging in their accounts can
see list of books issued and its issue date and return date and also the
students can request the librarian to add new books by filling the book
request form. The librarian after logging into his account ie admin account
can generate various reports such as student report, issue report, teacher
report and book report .
Overall this project of ours is being developed to help the students as well as
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.
Objectives
Following are the key objectives
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
All the web pages are created using PHP and MYSQL is used as the required
database. UML modeling is used to create the basic design and flow of the
application and once it is done the actual coding is done. Initially all the
required web pages are created along with the database tables. The required
business logic is added to improve the scope of the application and the
database connections are established. Few test cases are created and
manual testing is used in this project. Test cases are created in a manner to
check all the required field level validations and also database validations.
Once the application is created the corresponding test cases are executed
against couple of runs and the bugs are resolved if any identified. Once the
testing is done, the final product is delivered.
CHAPTER 2
SYSTEM ANALYSIS
In this chapter, we will discuss and analyze about the developing process of
Library Management System including software requirement specification
(SRS) and comparison between existing and proposed system . The
functional and non functional requirements are included in SRS part to
provide complete 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 than the existing
one.
file accidentally. Besides some natural disaster like floods or fires may
also damage the files.
Space consuming -mAfter the number of records become large the space
for physical storage of file and records also increases if no computerized
system is implemented.
EFFICIENCY REQUIREMENT When a library management system will be implemented librarian and
user will easily access library as searching and book transaction will be
very faster.
RELIABILITY REQUIREMENT -
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 REQUIREMNTS
In implementing whole system it uses html in front end with php as server
side scripting language which will be used for database connectivity and the
backend ie the database part is developed using mysql.
IMPLEMENTATION REQUIREMNTS
In implementing whole system it uses html in front end with php as server
side scripting language which will be used for database connectivity and the
backend ie the database part is developed using mysql.
SOFTWARE REQUIREMENTS
HARDWARE REQUIREMENTS
Intel core i5 2nd generation is used as a 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 4 gb is used as it will provide fast reading and writing capabilities and will in
turn support in processing
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 MySQL development project has made its source code
available under the terms of the GNU General Public License, as well as
under a variety of proprietary agreements. MySQL was owned and sponsored
by a single for-profit firm, the Swedish company MySQL AB, now owned by
Oracle Corporation .MySQL is a popular choice of database for use in web
applications, 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, Perl/PHP/Python." Free-software-open
source projects 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 databases
include: TYPO3, MODx, Joomla, WordPress, phpBB, 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 TABLES TO MAINTAIN INFORMATION
After entering to the home page of the website, student can choose the
STUDENT LOGIN option where they are asked to enter username & password,
and if he/she is a valid user then a student login page will be displayed.
It is a 2nd level Data Flow Diagram where after entering STUDENT LOGIN
page he/she can select a book issue option where after entering the book
detail, he/she can select the book issue option and if the maximum no of
books issued limit is not crossed then a request will be sent to the librarian
who will approve the book issue.
After the home page login there will be an option of the book search where
after entering book detail like author name, publication, book name etc book
details will be displayed
After the home page login there will be an option of CREATE AN ACCOUNT
where after entering student detail ,if all the fields are filled then a request
will be sent to the librarian who will approve him as a registered member of
the library.
CHAPTER 4
SYSTEM IMPLEMENTATION
REPORT
GENERATIO
N
The following module contains various facilities like student validation, book
addition, and report generation.
Student
Validation
BOOK
ADDITION
else if(mysql_num_rows($user)>0)
{
$_SESSION['user_name']=$user;
$_SESSION['user_login_status']="loged in";
header("Location:user/index.php");
}
else
{
echo "<p style='color: green;'>Incorrect UserId or Password</p>";
}
}
?>
</body>
</html>
SCREENSHOT FOR ADMIN LOGIN
<div class="main">
<div class="header ">
<h1> Library management System</h1>
</div>
<div class="mainmenu">
<ul>
<li><a href="index.php">Home</a> </li>
<li><a href="#">add student</a>
<ul> <li><a href="student.php">Add</a></li></ul>
<ul> <li><a href="#">Update</a></li></ul>
<ul> <li><a href="#">Delete</a></li></ul>
</li>
<li><a href="new_book.php">add book information</a>
</li>
<li><a href="book order list.php">Book order list</a> </li>
<li><a href="?log=out">Logout</a> </li>
</ul>
</head>
<body>
<h1 align="center">Student sign up</h1>
<form action="student.php" method="post" enctype="multipart/form-data"
onsubmit="return validateForm()"name="myForm">
<table align="center" bgcolor="#F0EEEF">
<tr><td width="300px">Student Id:</td><td><input name="id"
type="text"/></td></tr>
<tr><td width="300px">User Name:</td><td><input name="name"
type="text"/></td></tr>
<tr><td width="300px">Address:</td><td><input name="address"
type="text"/></td></tr>
<tr><td width="300px">Email:</td><td><input name="email"
type="text"/></td></tr>
<tr><td width="300px">mobile:</td><td><input name="mobile"
type="text"/></td></tr>
<tr><td width="300px">Password:</td><td><input name="password"
type="password"/></td></tr>
<tr><td width="300px"></td><td><input name="add" type="submit"
value="Submit"/></td></tr>
</table>
</form>
<?php
if(isset($_POST['add']))
{
$id=$_POST['id'];
$name=$_POST['name'];
$address=$_POST['address'];
$email=$_POST['email'];
$contact=$_POST['mobile'];
$password=$_POST['password'];
include("../connection.php");
$sql="insert into student
values('$id','$name','$address','$email','$contact','$password')";
if(mysql_query($sql))
{
echo "Successful";
}
else
{
echo mysql_error();
}
}
else
{
echo "connection error";
}
?>
</body>
</html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-88591" />
<meta name="author" content="pappu" />
<title>student sign up</title>
<link rel="stylesheet" type="text/css" href="style.css"/>
</head>
<body>
<div class="main">
<div class="header ">
<h1> Library management System</h1>
</div>
<div class="mainmenu">
<ul>
<li><a href="index.php">Home</a> </li>
<li><a href="#">add student</a>
<ul> <li><a href="student.php">Add</a></li></ul>
<ul> <li><a href="#">Update</a></li></ul>
<ul> <li><a href="#">Delete</a></li></ul>
</li>
<li><a href="new_book.php">add book information</a>
</li>
<li><a href="book order list.php">Book order list</a> </li>
<li><a href="?log=out">Logout</a> </li>
</ul>
</head>
<body>
<h1 align="center">Student sign up</h1>
<form action="student.php" method="post" enctype="multipart/form-data"
onsubmit="return validateForm()"name="myForm">
<table align="center" bgcolor="#F0EEEF">
<tr><td width="300px">Student Id:</td><td><input name="id"
type="text"/></td></tr>
<tr><td width="300px">User Name:</td><td><input name="name"
type="text"/></td></tr>
<tr><td width="300px">Address:</td><td><input name="address"
type="text"/></td></tr>
<tr><td width="300px">Email:</td><td><input name="email"
type="text"/></td></tr>
<tr><td width="300px">mobile:</td><td><input name="mobile"
type="text"/></td></tr>
?>
</body>
</html>
<body>
<h1 align="center">Student sign up</h1>
<form action="student.php" method="post" enctype="multipart/form-data"
onsubmit="return validateForm()"name="myForm">
<table align="center" bgcolor="#F0EEEF">
<tr><td width="300px">Student Id:</td><td><input name="id"
type="text"/></td></tr>
<tr><td width="300px">User Name:</td><td><input name="name"
type="text"/></td></tr>
<tr><td width="300px">Address:</td><td><input name="address"
type="text"/></td></tr>
<tr><td width="300px">Email:</td><td><input name="email"
type="text"/></td></tr>
<tr><td width="300px">mobile:</td><td><input name="mobile"
type="text"/></td></tr>
<tr><td width="300px">Password:</td><td><input name="password"
type="password"/></td></tr>
<tr><td width="300px"></td><td><input name="add" type="submit"
value="Submit"/></td></tr>
</table>
</form>
<?php
if(isset($_POST['add']))
{
$id=$_POST['id'];
$name=$_POST['name'];
$address=$_POST['address'];
$email=$_POST['email'];
$contact=$_POST['mobile'];
$password=$_POST['password'];
include("../connection.php");
$sql="insert into student
values('$id','$name','$address','$email','$contact','$password')";
if(mysql_query($sql))
{
echo "Successful";
}
else
{
echo mysql_error();
}
}
else
{
echo "connection error";
}
?>
</body>
</html>
CHAPTER 5
SYSTEM TESTING
The aim of the system testing process was to determine all defects in our
project .The program was subjected to a set of test inputs and various
observations were made and based on these observations it will be decided
whether the program behaves as expected or not.
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
environment 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 functions of the module under test with
appropriate parameters
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 and delete buttons if user click
add button data will be added to student database and if he clicks
delete button the student data will 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 .