ST. ARNOLD’S CENTRAL SCHOOL, PUNE.
Academic Year: 2023-24
Class-(class) (CBSE)
COMPUTER SCIENCE
PROJECT
TOPIC:
Topic name
Submitted by: -
Name:
Class:
Roll no:
Page | 1
CERTIFICATE
This is to certify that <<YOUR NAME HERE>> of class
XII A/B of <<SCHOOL NAME>> has done his/her project
on <<PROJECT NAME>> under my supervision. He/She
has taken interest and has shown at most sincerity in
completion of this project.
I certify this Project up to my expectation & as per
guidelines issued by CBSE, NEW DELHI.
Internal Examiner External Examiner
Principal
Page | 2
ACKNOWLEDGEMENT
It is with pleasure that I acknowledge my sincere gratitude
to our teacher, <<Teacher Name>> who taught and
undertook the responsibility of teaching the subject
computer science. I have been greatly benefited from his
classes.
I am especially indebted to our Principal <<Principal
Name>> who has always been a source of encouragement
and support and without whose inspiration this project
would not have been a successful I would like to place on
record heartfelt thanks to him.
Finally, I would like to express my sincere appreciation for
all the other students for my batch their friendship & the
fine times that we all shared together.
Page | 3
PREFACE
In the field of Computer Science the term PROJECT refers
to a Computerization Work that is completely performed
by using a computer. Today when every field is going to be
computerized means that all task of any field now a days
done by using computer and their appropriate computer
programs, then to do every field’s different-different works,
today different programs or software’s are available in the
form of Project.
Learning Python in schools is a part of our syllabus, and
according to the syllabus worked out by the CBSE, to
which my school is affiliated, I enjoyed doing project work
for the session 2021-22. I learned a lot, especially learning
by doing was a great experience.
The report is a summary of what I observed and learnt in
school. My humble thanks are going to all the concerned
related to my project. I also feel that it is the right time to
thank my teacher, who guided me during my project. I also
feel that it is the right time to thank my parents, friends
and my project partners for their constant assistance, co-
operation extended by them time to time.
Page | 4
Table of Content
Sr. No. Topic Page No.
1 Abstract 6
2 Project Aim and Objectives 7
3 Background of Project 8
4 Project Scope 9-11
5 Development Environment
Software 12
Hardware 12
6 Table Design 13
7 Data Flow Diagrams 14
8 System Design 15
9 E-R Diagram 16
10 Use Case Diagram 17
11 System Implementation 18-21
12 References 22
Page | 5
ABSTRACT
Today’s world is the world of Science and Technology. It is
the today’s requirement in every field for quick movement.
My Project Library Management System is just been a little
contribution to this developing world of science and
technology. My project is basically about the complete
automation of Library System. The project is mentioned by
following references from which we get more information
about the whole books and members details very easily
and in no time.
The knowledge of Python is not completed until the project
work has been completed successfully. Thinking this point
in mind, I had taken this project in our school library,
when already e-Granthalaya was functional. Based on the
information collected from Librarian about the library
processing project work started. This project has
capability of adding new book in stock, edit book, search
book, issue book and return book. It also has capabilities
for member addition, updating, search. The unique
features like report of all type required in library is also in
this project.
The project starts from Login screen, where username and
password are entered, once validated the home screen will
appear with all the functionality. Different menus are
available like BOOK, MEMBER, TRANSACTION, REPORT,
CHANGE PASSWORD,etc.
Page | 6
Project Aim and Objectives
The project aims and objectives that will be achieved after
completion of the system is as follows:
✓ To eliminate the paper-work in library
✓ To record every transaction in computerized system
so that the problem such as record file missing won’t
happen.
✓ To design a user friendly graphical user interface
which suits the users.
✓ To complete the system according to project schedule
✓ To produce technical report that documents the
phases, tasks and deliverables in the project
✓ Future objective is to add Bar Code, SMS technologies
into the system.
Page | 7
Background of the Project
Library management system is an application refer to other library
system and it is suitable to use by small and medium size library.
It is used by librarian and library admin to manage the library
using a computerized system. The system was developed and
designed to help the librarian record every book transaction to that
the problem such as file missing or record missing will not
happened again.
Book and member maintenance module also included in Library
Management System. User can register or edit the member or book
in the system. With this computerized maintenance, library will
not lost the book record or member record which always happened
when no computerized system bring used.
In addition, report module is also included in Library Management
System. If user’s position is Admin, the user is able to view
different kind of report. First type of report are issued and return
report, user can check the issued, return transaction which
happen on particular day. Besides that, user can check the Top10
books which borrow by the member in a day, month or year based
on category. Moreover, activity log report also provided by system
so that admin can check what process has been carried out such
as register new book, edit member information as well as login,
logout information.
When student lost the book, user can use lost book module to
register the lost book and receive the fine which is same as the
price of book, also receive fine on late submission of book @Rs.
2/day.
All these module are able to help librarian to manage the library
more convenience and efficiency compare to those library without
computerized system.
Page | 8
Project Scope
In this part, I would like to discuss various modules inside the
project Library Management System.
1. Authorization and Authentication Module
This module is used for logging in to the system by providing
user id and password. In order to distinguish the user’s level,
user can access to different module when successfully login.
For example, only admin level users are able to access the
report module. Password recovery can also be done by admin
user.
2. Member Maintenance Module
This module is used to adding new member in library, update
details of member on request, ID card to be printed for
members, and also search member information when
required.
Page | 9
3. Book Maintenance Module
Delete
book
This module is used for adding new book in library, edit book
details, remove book when lost by students, or damaged or
condemned, search book details.
4. Book Transaction Module
This module is used for issue books to students, taking books
back from students, check the availability of book, fine
collection and also lost book module entry to collect fine.
Page | 10
5. Report Module
This module is used to get report of all issued books, books
which are not returned after their due date, Top10 book issue
report and also activity log of various activities.
Page | 11
Development Environment
Software:
1) Operating System (Windows 7 or later) : Windows 7 is
selected as my operating system because of additional file
system, improved performance on multi-core processors,
improved boot performances, security features and better
GUI.
2) Database (MySQL): MySQL is selected as database, main
reason is quite obvious it is in our syllabus. MySQL is free
and open source relational database management system.
3) Programming Language (Python): The reason of selecting
Python is same as with MySQL. Python is also free and open
source programming language.
Hardware
1) Processor: Intel i3 or AMD Ryzen processor for better
performance
2) RAM : Minimum 2 GB required
3) Screen Resolution: Monitor with screen resolution minimum
1024x768
4) Hard Disk : Minimum 2 GB of space is required for database
Page | 12
Table Design
Book Table
Member Table
Issue Table
Return Table
Login Table
Page | 13
Data Flow Diagram
Zero Level DFD – Library Management System
First Level DFD – Library Management System
Page | 14
System Design
Page | 15
E-R Diagram
E-R Diagram – Library Management System
Page | 16
Use Case Diagram
Use case diagram – Library Management System
Page | 17
System Implementation
Login Screen
If username and password entered is valid then it will display “Login
Successful” message otherwise “Access Denied” message will appear.
New Book Entry Form
In this screen we will enter all the details of book and click on
save. Data will be automatically saved to database.
Page | 18
Edit Book Form
In this form we will enter book number and click on Find button, if
record is present then it will display corresponding detail to edit, change
the desired values and click on Update. If book number not found, then
book number not found message will appear.
Delete Book Form
Similar to Edit Book Form, we will enter book number, and if book
number exists it will display detail before deletion, if you are sure to
delete click on Delete Button. If book number not found, then book
number not found message will appear.
Page | 19
Search Book Form
In this form we will enter book number and click on find, if book number
exists, then it will display all details otherwise error message will
appear.
Show All Book Form
This form will display the list of all books in the library also it will
display the status whether the book is issued or not.
Book Issue Form
In this form we will enter book number and member id, it will
automatically check whether book is already issued or not, it also check
whether member has already issued any book or not, if everything is
OK then we can click on Issue My Book and record will be stored in
database.
Page | 20
Return Book Form
In this form, we will enter member id, if any book is issued against
member id, then it will popup message the name of book issued and
then we can click on Return My Book to get back the book from member.
If no book is issued then a message “No Book Issued” will appear.
Page | 21
References
Name of Book, website to be mentioned here.
Page | 22