Project Report

A Project Report Submitted

In Fulfillment of the Requirement
For

O-Level
Under The Guidance of Submitted By

Ranjeet Kumar Yadav Name- Parul Mishra

Head & Asst. Professor Roll No. - 1552013
Deptt. Of Computer Science
Sunrise Institute of Engineering

1
 Proforma of the Project Completion Certificate

This is to certify that the Project work done at Library Management System BY

Mr./Ms. Parul Mishra (NIELIT Registration No.: 1552013) in partial fulfillment of

NIELIT ‘O’ Level Examination has been found satisfactory. This report has not been

submitted for any other examination and does not form part of any other course undergone

by the candidate

It is further certifies that he/she has appeared in all the four modules of NIELIT ‘O’ Level

Examination.

(Institute PROV No./

FULL No.) PARUL MISHRA

(or)

Head of the Organization/Division:

Name of the Organization:

Address:

(or)

Name of the Guide/Supervisor: RANJEET KUMAR YADAV

Qualification MCA

(Self attested copy of the qualification of the guide/Supervisor to be attached)

2
 ABSTRACT

Library is place where all kind of books are available. Intranet Library Management system
is a web based application. This system contains list of all the books and can be accessed by remote
users concurrently from any where in the campus. But for that users must be registered user. This system
is three tier architecture.

Client sends requests, on receiving the request the server processes it and extracts the data
from database and sends the result back to the client. This system provides separate interface and login
for librarian, students and faculties. Librarian can modify database.

Users can search for books and renewal books online. They can recommend for new books
by just sending messages to the librarian from any where in the college. They can view the issue and
return dates of any book and due they have to pay. This system generates reports that can be used in
analyzing the library performance. Thus the management can take appropriate steps to improve the
facilities.

3
Sr. No. CONTENTS Page No.

1. Introduction 6

2. Analysis 7

2.1 System Analysis

2.2 System Specifications

3. Design Approach 8-10

3.1 Introduction To Design

3.2 UML Diagrams
3.3 Data Flow Diagrams
3.4 ER-Diagrams

4. Project Modules 11-12

5. Implementation 13-16

5.1 Concepts and Techniques

5.2 Testing
5.3 Test Case

6. Output Screens 17-18

7. Conclusion 19

8. Future Enhancements 20

4
5
INTRODUCTION:

Library Management System consists of list of records about the management

of the details of the students and the issues going on and also about some books and all.
This is a web-based application. The project has three modules namely- User, Registration,
Librarian. According to the Modules the Distributor and Sub Distributors can manage and
do their activities in easy manner.

As the modern organizations are automated and computers are working as per the
instructions, it becomes essential for the coordination of human beings, commodity and
computers in a modern organization. This information helps the distributors to purchase or
sale the products very efficiently.

The administrators and all the others can communicate with the system through
this project, thus facilitating effective implementation and monitoring of various activities
of the distributor of a supermarket.

6
RULES FOR DFD:

 Fix the scope of the system by means of context diagrams.

 Organize the DFD so that the main sequence of the actions
 Reads left to right and top to bottom.
 Identify all inputs and outputs.
 Identify and label each process internal to the system with Rounded circles.
 A process is required for all the data transformation and Transfers. Therefore,
never connect a data store to a data Source or the destinations or another data
store with just a Data flow arrow.
 Do not indicate hardware and ignore control information.
 Make sure the names of the processes accurately convey everything the process
is done.
 There must not be unnamed process.
 Indicate external sources and destinations of the data, with Squares.
 Number each occurrence of repeated external entities.
 Identify all data flows for each process step, except simple Record retrievals.
 Label data flow on each arrow.
 Use details flow on each arrow.
 Use the details flow arrow to indicate data movements.

7
0 level DFD

8
1 level DFD

9
E-R Diagrams:

10
DATABASE TABLES:

11
Book Return:-

12
13
Login Page

14
CODING

15
Sql Connection:-
<?php
$con=mysql_connect("localhost","root","");
if(!$con)
{
die(mysql_error());
}
mysql_select_db("library");
Login Code:-
<?php
session_start();
include("[Link]");
if(isset($_POST["submit"]))
{
if($_POST[usrtype] == "Student")
{
$result=mysql_query("select * from student where regno='$_POST[name]'and
password='$_POST[pw]'");
if(mysql_num_rows($result) == 1)
{
$row=mysql_fetch_array($result);
$_SESSION["sid"]=$_POST["name"];
$_SESSION["usrtype"]="Student";
$_SESSION['name']=$row[name];
$_SESSION[img]=$row[imag];
header("Location: [Link]");
}

16
}
else if($_POST[usrtype] == "Staff")
{
$result=mysql_query("select * from staff where login_id='$_POST[name]'and
password='$_POST[pw]'");
if(mysql_num_rows($result) == 1)
{
$row=mysql_fetch_array($result);
$_SESSION["sid"]=$_POST["name"];
$_SESSION["usrtype"]="Staff";
$_SESSION['name']=$row[name];
header("Location: [Link]");
}
}

else
echo "Invalid username or password";

}
include("[Link]");
?>

<html>
<head>
<title>Login</title>
</head>
<body>
<div id="templatemo_content_container">
<div id="templatemo_content">
<div id="templatemo_content_left">
<div class="templatemo_post">
<div class="post_title">
17
 LOGIN

CONCLUSION:

The package was designed in such a way that future modifications can be
done easily. The following conclusions can be deduced from the development
of the project.

 Library Management System of the entire system improves the efficiency.

 It provides a friendly graphical user interface which proves to be better
when compared to the existing system.
 It gives appropriate access to the authorized users depending on their
permissions.
18
 It effectively overcomes the delay in communications.
 Updating of information becomes so easier.
 System security, data security and reliability are the striking features.
 The System has adequate scope for modification in future if it is necessary.

19
20
FUTURE ENHANCEMENTS:

This application avoids the manual work and the problems concern with it.
It is an easy way to obtain the information regarding the various products information that
are present in the Library of a particular college.
Well I and my team members have worked hard in order to
present an improved website better than the existing one’s regarding the information about
the various activities. Still ,we found out that the project can be done in a better way.
Primarily, when we request information about a particular product it just shows the
company, product id, product name and no. of quantities available. So, after getting the
information we can get access to the product company website just by a click on the product
name .
The next enhancement that we can add the searching option. We
can directly search to the particular product company from this site .These are the two
enhancements that we could think of at present.

21
22