Project report
on
E-Library Management System
Team Members: Guided By:
[Link] kant Verma
# Sanubiya khan
CSE Professor
(130430103012)
# Akshita Mittal
(130430103007)
ACKNOWLEDGEMENT
The satisfaction that accompanies that the successful completion of any
task would be incomplete without the mention of people whose cease
cooperation made it possible, whose constant guidance and
encouragement crown all efforts with success.
We are grateful to our project guide Mr. Kamal Kant for the guidance,
inspiration and constructive suggestions that helps us in the prepration
of this project.
We also thank our college for this project and opportunity.
Sanubiya khan
Akshita Mittal
CERTIFICATE
This is to certify that this report of E-Library Management
System embodies the original work done by Sanubiya Khan
and Akshita Mittal during this project submission as a partial
fulfillment of the requirement for the system design project of
bachelor of computer application IV semester, of the Quantum
school of Technology, Roorkee.
Sir Satender
(Head of department)
QUANTUM SCHOOL OF TECHNOLOGY
Table of Contents
1. Synopsis
2. Feasibility Study
3. Data Tables
4. Data Flow Diagrams
5. Entity Relationship Diagrams
6. Screen shots of form
7. Future Scope
8. Conclusion
9. Bibliography
E-Library Management System
SYNOPSIS
E-Library Management
System
INTRODUCTION-->>>
A. Purpose
The purpose of this application are as follows:
# The software is for automation of library.
# It has database which is constantly managed and update.
# It keeps track of books issued, returned, edited and added to the
library.
# You can lock your book according to your preferences.
# It provide library information to students and faculties
at home.
Technology used
Front End: HTML, CSS, BOOTSTRAP
Back End: HeidiSQL
Server : Apache Tomcat
Software used: NetBeans IDE 8.1, HeidiSQL, Dreamweaver CS6
Server site technology: Servlet, JSP
Modules used
ADMIN: Admin have following permissions
1# Add new book and its corresponding details
2# Delete existing book
3# Edit existing book
4# Search existing
FACULTY: Faculty have following permissions-
1# Search book
2# Lock book for next 12 hours
3# check fine duty and issued books
STUDENT : Faculty have following permissions-
1# Search book
2# Lock book for next 12 hours
3# check fine duty and issued books
SCOPE
THE DIFFERENT AREAS WHERE WE CAN USE THIS APPLICATION
ARE :
# Any education institute can make use of it for providing
information about requirements of books at present in library on which
block & shell.
# It can be used in offices and modifications can be easily done
according to requirements.
PROJECT SCOPE
THE DIFFERENT SCOPE OF ONLINE LIBRARY MANAGEMENT
SYSTEM INCLUDES ARE :
# Authenticate users at their login time.
# Provide the list of books that are not issued to other user.
# Facility to lock the available books for next 12 hours.
# Facility to cancel the lock for a book made earlier.
# A status page for all users to view books borrowed by them,
their individual due dates and their individual penalties if any.
# An interface to view and edit the own profile.
# Provide method for adjusting account settings such as password.
# Providing interface to add or delete books to admin and staff.
FEASIBILITY STUDY
In feasibility study phase we had undergone through various
steps which are describe as under:
# Identify the origin of the information at different level.
# Identify the expansion of user from computerized system.
# Analyze the draw back of existing system (SOFTWARE)
system and published on web.
THE PROPSED SYSTEM HAS
FOLLOWING ADVANTAGES
# Easy to handle and feasible
# Fast retrieve to database
# Easy access to all information
# Virtual environment look and feel
# Rapid transaction
# Cost reduction
DATA FLOW DIAGRAMS
0 LEVEL (MENUS)
1 LEVEL (INPUT DETAILS)
2 LEVEL (OUTPUT DETAILS)
Whole system DFD
LEVEL 0 DIAGRAM
DISPLAYING
BE A MEBER BOOK
DETAILS
SEARCHING DISPLAYING
BOOK STUDENT
DETAILS
E-LIBRARY
ENTRYING MANAGEME
DISPLAING
BOOK NT SYSTEM
TRANSACTIO
DETAILS N DETAILS
UPDATE
STORE LOCK
BOOK
IFORMATION
DETAILS
AUTHENTICA
TE EVERY STORING
USER STU & BOOK
LEVEL1 DFD DIAGRAM
(STORING)
ADMIN
DETAILS
FACULTY
DETAILS
STUDENT
TAKING DETAILS
DATAB INPUT
ASE DETAILS
UPDATION
DETAILS
TRANSACTION
DETAILS
LEVEL 1 TRANSACTION
DETAILS(STORING)
BOOK-ID
Q-ID
TAKING ISSUE-DATE
DETAILS OF
DATAILS IN TRANSACTI--
DATABASE ONS
RETURN-DATE
PANALTY
AUTHOR
LEVEL1 DFD DIAGRAM
(DISPLAYING)
ADMIN
DETAILS
FACULTY
DETAILS
STUDENT
TAKING DETAILS
DATAB INPUT
ASE DETAILS
UPDATION
DETAILS
TRANSACTION
DETAILS
LEVEL 1 TRANSACTION
DETAILS(DISPLAYING)
BOOK-ID
Q-ID
TAKING ISSUE-DATE
DETAILS OF
DATAILS IN TRANSACTI--
DATABASE ONS
RETURN-DATE
PANALTY
AUTHOR
DFD OF WHOLE SYSTEM
PROCESSING
STUDENT ADMIN FACULTY
Request for create
member
Member details SIGNUP
MEMBER
REQUEST
DATABASE
Authenticate member
Add new book
PANNEL
Request for book lock
edit book
Book search Search book
STUDENT & Edit profile Delete book
ADMIN
FACULTY Book issued details Book transaction
Get details with penalty
DIFFERENT DATA TABLES
USED IN PROJECT
ADMIN_SIGNUP TABLE
[Link] NAME DATAYPE LENGTH COMMENT
1. FIRST_NAME VARCHAR 50
2. LAST_NAME VARCHAR 50
3. Q_ID INT 20
4. MOBILE_NO VARCHAR 15
5. EMAIL VARCHAR 50
6. PASSWORD VARCHAR 50
7. SEQUIRITY_Q VARCHAR 50
8. SEQURITY_A VARCHAR 50
Signup Table Student
[Link] COLOUM NAME DATA TYPE LENGTH DESCRIPTION
1. FIRST_NAME VARCHAR 50
2. LAST_NAME VARCHAR 50
3. Q-ID INT 20
4. ROLL_ NO INT 20
5. COURSE VARCHAR 50
6. BRANCH VARCHAR 50
7. SEMESTER INT 20
8. SECTION INT 20
9. MOBILE_NO VARCHAR 50
10. EMAIL VARCHAR 50
11. PASSWORD VARCHAR 50
12. SECURITY_Q VARCHAR 50
13. SECURITY_A VARCHAR 50
Faculty_signup table
[Link] NAME DATATYPE LENGTH COMMENT
1. FIRST_NAME VARCHAR 50
2. LAST_NAME VARCHAR 50
3. Q_ID INT 20
4. DESIGNATIO VARCHAR 50
5. MOBILE_NO INT 20
6. EMAIL VARCHAR 50
7. PASSWORD VARCHAR 50
8. SECURITY_ VARCHAR 50
QUESTION
9. SECURITY_ VARCHAR 50
ANSWER
LOGIN_DETAILS TABLE
[Link] COLOUM DATA LENGTH/ COMMENT
NAME TYPE SET
1. sno INT 11
2. fname VARCHAR 50
3. lname VARCHAR 50
BOOK_ADD TABLE
[Link] COLOUM NAME DATA TYPE LENGTH COMMENT
1. [Link] INT 20
2. BOOK_ID INT 50
3. BOOK_NAME VARCHAR 20
4. AUTHOR_NAME VARCHAR 20
5. PUBLISHERS_ VARCHAR 20
NAME
6. BOOK_CATEGOR VARCHAR 20
7. BOOK_SHELL_NO INT 100
8. BOOK_ROW_NO INT 500
9. BOOK_QUANTITY INT 100
10. BOOK_STATUS VARCHAR 10
BOOK_ISSUE TABLE
FIELD NAME DATA TYPE LENGTH COMMENT
BOOK_ID INT 50
Q_ID INT 20
ISSUE DATE VARCHAR 10
RETURN VARCHAR 10
DATE
PANELTY INT 10
AUTHOR VARCHAR 20
NAME
CONCLUSION
While preparing E-LIBRARY MANAGEMENT SYSTEM it has
been a great pleasure to me to work on this exciting and
challenging project. This project proved good for me as it
provided practical knowledge of not only the programing in
advance java and web based application, and SQL server, but
also about all handling procedure related with library
management process.
This will provide better opportunity and guidance in future as
developing projects independently.
This ultimate web technology helps users to check book details
at home, u can lock your books for next twelve hours so this is
the biggest advantage of my project which will going to help
users and save time.
Secondly it doesnt make your body tired while searching any
book because we already describe physical existence of a book
in library so go and get your book it becomes too easy.
FUTURE ENHANCEMENTS
FUTURE ENHANCEMENTS/RECOMMENDATIONS
In future enhancement we decided to provide SMS facilities to users in which
automatic message will be generated and send to those users whose date of
issued period is about to expire and provide information about penalty amount.
In future, students have authority to re assign book for more period as well.
In future, we would apply algorithm which identify the theft book details and user.
In future advancement we have decided to provide more advance look and feel to
our system so as to make our system more attractive.
BIBLIOGRAPHY
BOOKS:
# JAVA: The complete reference 5th edition
# HTML 5 for beginners
# Learning Web Design
#
WEB SITES:
[Link]
# [Link] html
# [Link] JavaScript
#[Link] (for servlet)
# [Link]
#[Link] (Sourabh Shukla
lecture on servlet and jsp)
THANKU FOR WATCHING
HAVE A GOOD DAY