Dinesh Emboss

A Website on Library Management System 2023-24
SHIVAJI UNIVERSITY, KOLHAPUR

DEPARTMENT OF COMPUTER SCIENCE
2023-2024
Internship Report
(Technical Intern at Visha’s IT Solution LLP)
Under Guidance of
Mr. P.T. Goyal
(Project Mentor)
&
Mr. Vishwajeet Dubal

(Internship Mentor)
Submitted by
Mr. Dinesh Rajendra Lipare.
(PRN - 2022012131)
Part-II, Semester - IV
Page 1
Shivaji University Kolhapur
CERTIFICATE
This is to certify that, Mr. Dinesh Rajendra Lipare have satisfactorily

completed the project entitled as “Library Management System” in the partial
fulfillment of MSc. II SEM IV during the academic year 2023-2024.
Place: Kolhapur
Date: …. /..../2024
Examiner Mr. P. T. Goyal Dr. K. S. Oza

(Guide) (HOD)
Page 2
DECLARATION
To,
The Head Of Department,
Department Of Msc
Shivaji University,
Kolhapur.
Respected Sir,
We undersigned hereby declare that the project entitled
“Library Management System” developed and submitted by us and
under the guidance of Mr. P.T. Goyal is our original work. The
empirical finding in this project work is based on the information
collected by me, while preparing this project we have not copied
from any other report submitted to Shivaji University, Kolhapur
earlier.
We understand that any such copying is liable to be punished in

a way the center university authority may be deem fit.
Place:Kolhapur
Date:
Sign .Of Student
(Mr.Dinesh Lipare)
Page 3
ACKNOWLEDGEMENT
Every project is always a scheduled, guided & coordinated team effort
aimed at achieving common minimum goals. This minimum goal cannot be
achieved without the guidance of guide.
It is with immense pleasure that we present our report to our project guide
Mr.P.T. Goyal. We find no words to describe her efforts and total confidence in
our potential to see this project to completion. She has always been a source of
inspiration and a tower of support boosting our moral beyond imagination. We
would like to express our gratitude to our Head of the Department Dr. K. S. Oza
her continuing support and encouragement.
We sincerely express our gratitude to our parents for their blessing for
making this project successful.
Finally we are thankful to our Computer Department and all our
friends who have helped us to realize our efforts.
Thanking all of them, again.
Mr. Dinesh Lipare.

Date: …./…./2024 Place: Kolhapur
Page 4
INDEX
Sr.No Title Page No.
1 Introduction to website 6
2 Proposed System 7
3 Requirement Gathering 8
4 Introduction to SQL Server 9
5 System in Detail 10
6 Webpage Sequence 11-12
7 Sitemap 13
8 System Requirement Specification 14
9 Context Level DFD 15
10 First Level DFD 16-18
11 ERD Diagram 19
12 Screenshot 20-32
13 Conclusion 33
Page 5
Introduction To Website
In today's fast paced world, especially students need a lot of different books
for their studies. Also, in today's age, there is a tendency towards online method, so we have
created this website for them as well as for teachers, using online method to issue books from the
library.
Using this website, you can see if the book you want is available for reading
or available copies of book, and you can get that book from the library for reading. In this website,
anyone who is a librarian as admin can add students and teachers as well as extract all their
records in one click. In it, A student of which department of which class can know which book he
took and for how many days. In addition, we have given many more features in this website. Also,
if the book taken is not returned in time, whatever is fine for each day will be charged on it.
Feedback is also provided on this website so that student/teacher can provide
feedback for the website. Also, In the shortest possible time, you can quickly and securely issue
books from the library.
Page 6
Proposed System
Benefits:
1) User Friendliness:
This Project will have user-friendly screens designed will have very simple functionality
for the information.
2) Consistency:
The constancy in the proposed system will high efficiency due to smaller learning curves
and increased data integrity.
3) Compatibility:
This project offers great compatibility, as it will be designed with proper methodology,
new tools and technology.
4) Security:
This project is secured system, which will provide corporate level security. Also, that will
enable a user to view/edit/add the information, based on roles and privilege assigned to
that user.
5) Reliability & Robustness:
The project built with proper architecture and design it will provide a reliable and robust
application to that user.
6) Performance:
The performance of this application will be high because of it is optimize design and
sound architecture.
7) Extensibility:
This project has a modules design and would provide the flexibility of adding, future
modules to the application.
8) Flexibility:
This project has the flexibility of adding new modules when needed.
Page 7
Requirement Gathering
Introduction to ASP.NET
What is .net?
.Net is a set of software technology for connecting information, people, system and device. .Net
word says that it is related internet. It is a platform which is used to compile and execute programs
written by using .Net compatible language.
Blocks for framework architecture:
1. .NET compatible language:

ASP.net, C# .net are languages compatible to .net framework.
2. Common language specification:
These are set of rules designed for .net compatible languages. It helps to enhance and
ensure language interpretability by defining a set of features that developer can really on to
available in wide variety of language.
3. Common type system:

It is part of CLS. The CLS performs following function:
It is establishing a framework that helps the cross language integral type safely and high-
performance code execution. Provide an object-oriented model that supports the complete
implementation of many programming language. Define rules the language must be
follows which helps to ensure that 5 objects written in language can interact with each
other.
4. Framework class library:
It supports collection of predefined class. These classes put under hierarchy of special
structure called namespace. In .net “system” is highest level namespace.
5. Common language runtime:
CLR is the heart of the .net framework. It takes Gaze entire execution of application it is
also called as managed execution environment.
Page 8
Introduction To SQL Server 2012
SQL stands for Structured Query Language. SQL are used to communicate with a
database. According to ANSI (American National Standard Institute), it is the standard language
for relational database management system. SQL statements are used to perform task such as
update data on a database, or retrieve data from a database. Some common relational database
management system that uses SQL are: Oracle, Sybase, Microsoft SQL Server, access, Ingres,
etc. Although most database system use SQL, most of them also have their own additional
proprietary extensions that are usually only used on their system.
However, the standard SQL command such as “Select”,” Insert,” Update”,” Delete”,” Create” and
“Drop” can be used to accomplish almost everything that one need to do with a database. This
tutorial will provide you with the instruction on the basics of each of these commands as well as
allow you to put theme to practice using the SQL Interpreter.
Page 9
System in Detail
This website contains all the relevant information of Library Management System information are
as follow:
 Home
 Admin login
 Teacher login
 Student login
 About us
 Contact us
 Feedback
Page 10
Web Page Sequence
 Home
 Admin
 Login
 Teacher
 Student
 Book
 Book Issue
 Book Return
 Fixed Value
 Message
 Report
 Log Out
 Teacher
 Login
 My Profile
 Book Issue
 Book Return
 Fine
Page 11
 Message
 Log Out
 Student
 Login
 My Profile
 Book Issue
 Book Return
 Fine
 Message
 Log Out
 About us
 Contact us
 Feedback
Page 12
Site Map
Add Teacher
Teacher Update Teacher
Home Delete Teacher
Admin Login Add Student
Student Update Student
Delete Student
Teacher Login
Add Book
My Profile Book
Update Book
Book Issue Record
Book Return Record Delete Book

Fine Record
Issue Book
Issue Record Add
Message
Student Login Issue Record Update
Issue Record Delete

My Profile
Book Issue Record Return Record Add
Book Return Record Return Book Return Record Update

Fine Record
Fixed Value Return Record Delete
Message
Message Teacher
About us
Report Student
Book
Contact us Logout
Book Issue
Book Return
Feedback
Message
Page 13
System Requirement Specification
Hardware Requirement:
 PROCESSOR : Pentium 4& Above

 RAM : 1 GB & Above
 HARD DISK SPACE : 120 GB & Above
 PRINTER : Dot Matrix/ink jet
 DISPLAY UNIT : Monitor or LED
Operating system:
 WINDOWS XP/7 & Above
Software Requirement:
1. ASP.NET 2010/2012 & Above

2. MS-SQL Server (Back End)
Backup media:
 Hard Disk 120GB and Above
Page 14
DFD (Data Flow Diagram):
Context level DFD:
Admin
Login Response
Login
0.0
Teacher
Library
manageme Response
Login Response
Student
Page 15
1ST LEVEL DFD
Admin Request to login

1.0
Check for login
Login Admin
Response Reply
1.1 Insert data
Add/edit Add Teacher

Teacher
Response Reply
Add/edit Insert Data

1.2
Add Student
Student
Response Reply
Add/edit 1.3 Insert Data
ReportAdd Add Book

Book
Response View Reply
Add/edit 1.4
Insert Data
Issue Issue Book

Book
Response Reply
Add/edit 1.5 Insert Data
Return Return Book

Book
Response Reply
send Request 1.6 View
view
Message Message
Display data Display data
send Request 1.7 View
Display Data Report Report
Page 16
Request for login 2.0 Check for login

Teacher
Login Login
Response Reply
Update Insert data

2.1
Response Profile My Profile

Reply
Request View
2.2
Book Issue
Book Issue
Response Record Display Data
Request View
2.3
Book Return Book Return

Record
Response Display Data
Request 0 view
2.4
Fine
Fine
Display data Display data
Request 2.5 view
Display data Message Message
Display data
Page 17
Stud/Teac id 3.0 Check for login

Student
Login
Login
Response Reply
Update Insert data

3.1
My profile
Profile
Response Reply
Request View
3.2
Book Issue
Book Issue
Response Record
Display Data
Request View
3.3
Return Book
Book
Display data Return Display data
Record
Request View
3.4
Fine
Fine
Display Data Display Data
3.5
Request View
Message
Message
Display Data Display Data

Page 18
ERD (Entity Relationship Diagram):
Author Book Name Photo
Name
Book ID Address
Edition Teacher ID
Books Teacher
Add
Aadhar no
M M
Response
Publication Check
1 1
Type Request
Admin for book
Issue Book
1 1
Issue Add
Select Date
book
Student ID
Issue ID M
Student
M
Take Class Department
Return book return
book Photo
Language
Return ID Mobile no
Total Fine Amount
Delay days
Send
Record
Page 19
Home Page
Page 20
Admin Login
Page 21
Add Teacher
Page 22
Add Student
Page 23
Add Book
Page 24
Teacher Login
Page 25
Teacher Profile
Page 26
Student Login
Page 27
Student Profile
Page 28
Reports
Page 29
Page 30
Database for Add Teacher
Database for Add Student
Page 31
Database for Add Book
Database for Add Book Issue
Page 32
Conclusion
In this Project we were give you all information about “Library
Management System’’. We have done various research for this project and this system is
designed using ASP.net. In that project include front-end and back-end database. This has been
developed by considering all the needs given in the project and by through interaction with the
user of the system. After the completion of this project work. We feel that we have gained
sufficient knowledge in the development of “Library Management System’’. This project has
been developed using “ASP.NET & C#.NET”.
The Library Management System allows the user to store the book details and persons
details. This project allows storing the details of all the data related to the library. The
implementation of system will reduce data entry time and provide readily calculated reports.
In the Library Management system, the librarian can add/update/remove the student and
book details into the database. The students have a Unique ID for accessing any book from the
library. Through the ID, the librarian can check the user details and book details.
Library Management System is designed to help users maintain and organize library. The
report generation facility of library system helps to get a good idea of which are the books
borrowed by the members, makes users possible to generate reports' hard copy.
Page 33
Advantages, Limitations & Future Scope
Advantages:
 It helps in maintaining records.

 It is user friendly website and easy to use.
 It saves human effort and time.
 Database is provided in this website so authorized user can access the information.
 For a while students and teacher can issue books from this website easily.
 This is Dynamic Website.
Limitations:
 We are not providing the facility of online purchase books.

 Notification not going to students or teacher mobile from website.
 This website provides only book details.
 We are adding limited languages, limited books.
Future Scope:
 We will provide the online purchasing facility for all types of books.
 After students or teachers issue a book from the library, we will facilitate the
delivery of the massage directly to their mobile.
 In the future, we will arrange for you to read online books through our website.
 In the future, we will make books available in all languages on our website.
 In future we provide online payment facility.
Page 34

Dinesh Emboss

Uploaded by

Copyright:

Available Formats

Dinesh Emboss

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Dinesh Emboss

Uploaded by

Copyright:

Available Formats

A Website on Library Management System 2023-24

SHIVAJI UNIVERSITY, KOLHAPUR

Mr. Vishwajeet Dubal

Shivaji University Kolhapur

This is to certify that, Mr. Dinesh Rajendra Lipare have satisfactorily

Examiner Mr. P. T. Goyal Dr. K. S. Oza

We understand that any such copying is liable to be punished in

Sign .Of Student

Mr. Dinesh Lipare.

Sr.No Title Page No.

4 Introduction to SQL Server 9

6 Webpage Sequence 11-12

8 System Requirement Specification 14

9 Context Level DFD 15

10 First Level DFD 16-18

Feedback is also provided on this website so that student/teacher can provide

books from the library.

Blocks for framework architecture:

1. .NET compatible language:

3. Common type system:

Introduction To SQL Server 2012

proprietary extensions that are usually only used on their system.

allow you to put theme to practice using the SQL Interpreter.

Web Page Sequence

Teacher Update Teacher

Home Delete Teacher

Admin Login Add Student

Student Update Student

Book Return Record Delete Book

Student Login Issue Record Update

Issue Record Delete

Book Issue Record Return Record Add

Book Return Record Return Book Return Record Update

System Requirement Specification

 PROCESSOR : Pentium 4& Above

 WINDOWS XP/7 & Above

1. ASP.NET 2010/2012 & Above

 Hard Disk 120GB and Above

DFD (Data Flow Diagram):

Context level DFD:

1ST LEVEL DFD

Admin Request to login

1.1 Insert data

Add/edit Add Teacher

Add/edit Insert Data

Add/edit 1.3 Insert Data

ReportAdd Add Book

Issue Issue Book

Add/edit 1.5 Insert Data

Return Return Book

send Request 1.6 View

Display data Display data

send Request 1.7 View

Display Data Report Report

Request for login 2.0 Check for login

Update Insert data

Response Profile My Profile

Book Return Book Return

Request 2.5 view