P.A.
INTERNATIONAL SCHOOL
Pollachi, Tamil Nadu, Coimbatore-642002
Phone: 9688059995, Email: [email protected]
Affiliated to C.B.S.E, Delhi- No.1931011
RECORD OF PROJECT WORK
IN
COMPUTER SCIENCE (083)
CLASS XII
Name: Tarun. V
Reg. No: ....................................................................…
Submitted to: Ms. DEEPTHI M NAIR, MCA
P.A. INTERNATIONAL SCHOOL
Pollachi, Tamil Nadu, Coimbatore-642002
Phone: 9688059995, Email:
[email protected] Affiliated to C.B.S.E, Delhi- No .1931011
SSCE –PRACTICAL EXAMINATION 2025
CLASS: XII
CERTIFICATE
Certified that the entries in this project file is the bona fide work of
Master: Tarun. V Grade XII, Reg. No.__________________, completed during the
academic year 2024-2025.
Teacher In charge: Ms. DEEPTHI M NAIR, MCA
This project file was submitted for the SSCE Practical Examination in
Computer Science conducted on _________________ 2025.
Internal Examiner Principal External Examiner
ACKNOWLEDGEMENT
I have taken efforts in this project. However, it would not have
been possible without the kind support and help of many individuals
and organizations. I would like to extend my sincere thanks to all of
them.
I am highly indebted to our subject teacher Ms. Deepthi M Nair,
MCA, for their guidance and constant supervision as well as for
providing necessary information regarding the project & also for her
support in completing the project.
I would like to express my gratitude towards the school
management, Principal Mr. Mahesh K Narayanan, all other teachers
and my parents for their kind cooperation and encouragement which
helped me in the completion of this project.
Tarun. V
INDEX
PAGE
S.NO TOPIC
NO.
1 INTRODUCTION 1
2 OBJECTIVES OF THE PROJECT 2
3 FLOW CHART 3
4 TEAM ROLE 5
5 THEORETICAL BACKGROUND 6
6 HARDWARE & SOFTWARE REQUIREMENTS 8
7 SOURCE CODE 9
8 DATABASE DESIGN 13
9 OUTPUT 15
10 BIBLIOGRAPHY 19
INTRODUCTION
A Library Management System (LMS) automates
essential library tasks such as cataloging, circulation,
and inventory control, improving efficiency and
reducing manual work. It helps manage both physical
collections and digital resources, including e-books
and online databases, making it easier to track and
access materials.
LMS also offers features like member management,
fine tracking, and report generation. By centralizing
these functions, it streamlines library operations,
saving time and ensuring libraries can better serve
their communities with up-to-date, easily accessible
resources.
1
OBJECTIVE OF THE PROJECT
• Automation of Library Processes: To automate
cataloging, circulation, and inventory management to
reduce manual effort and improve operational efficiency.
• Improved Resource Management: To track both
physical and digital resources effectively, ensuring
timely access and proper management of library
materials.
• Enhanced User Experience: To provide an intuitive
interface for users to easily search, borrow, and return
books, and access digital content.
• Data Management and Reporting: To offer features
like member management, fine tracking, and report
generation, enabling better decision-making and resource
allocation.
• Cost and Time Efficiency: To reduce administrative costs,
save time, and improve overall library operations, ensuring the
library serves its community effectively and efficiently.
2
FLOW CHART
3
4
TEAM ROLE
ROLE TEAM MEMBER
ROLE
DESCRIPTION NAME
PROGRAMMER AMIRTHESH
ADMIN AND USER
AND DEBUGGER RAM. B. S
DATABASE DESIGN
PROGRAMMER TARUN. V
AND TESTING
DEBUGGER AND TABLE DESIGN AND
THANVANTH. H
PROGRAMMER USER PART
5
THEORETICAL BACKGROUND
WHAT IS PYTHON?
Python is a high-level, interpreted programming language
that is known for its simplicity, readability, and versatility.
It was created by Guido van Rossum and first released in
1991. Python emphasizes code readability and allows
developers to express concepts in fewer lines of code
compared to other programming languages like C++ or
Java.
FEATURES OF PYTHON:
Easy to Learn and Use: Python’s syntax is clear and easy to
read, making it an excellent choice for beginners. It closely
resembles natural language in some areas, which reduces the
learning curve.
Interpreted Language: Python is an interpreted language, which
means that code is executed line-by-line by the Python interpreter,
rather than being compiled into machine code first. This makes it
easier to test and debug code.
Dynamic Typing: Python is dynamically typed, meaning you
don’t need to specify the type of a variable when you declare it.
The interpreter determines the type at runtime.
6
WHAT IS SQL?
SQL (Structured Query Language) is a standard
programming language used to manage and manipulate
relational databases. It is specifically designed for
interacting with relational database management systems
(RDBMS) like MySQL.
FEATURES OF SQL:
SQL operates on relational databases, which store data in
tables. A table consists of rows and columns, where each
column represents a data field and each row represents a
record.
DDL is a subset of SQL used to define and modify database
structures, such as tables, indexes, and schemas.
DML is used to interact with the data stored in tables (insert,
update, select, and delete data).
DCL is used to control access to data stored in a database.
TCL is used to manage the changes made by DML
commands and to ensure data integrity.
7
HARDWARE & SOFTWARE
REQUIREMENTS
• PYTHON IDLE/VISUAL STUDIO CODE
• MySQL 8.0(and above)
• Modern Operating System:
o Windows 7 or 10
o Mac OS X 10.11 or higher,64-bit
o Linux: RHEL 6/7,64-bit (almost all libraries
work in ubuntu)
o x86 64-bit CPU (Intel/AMD architecture)
o 4 GB RAM
o 5 Gb free disk space
8
SOURCE CODE
DATABASE: “books”
TABLES: “library”, “customers”, “passws123”,
“balance”.
9
10
11
12
DATABASES
DATABASE: “books”
TABLE <library>:
TABLE <customers>:
13
TABLE <passws123>:
TABLE <balance>:
14
OUTPUT
Starting Page:
=>For Admins:
=>For Users:
=>Account exists:
=>Password Matched:
15
=>Password Mismatched:
=>Account Does Not Exist:
16
=>Borrow Function:
17
=>Return Function:
=>Delete Function:
18
BIBILIOGRAPHY
https://www.chatgpt.com/
https://www.smartdraw.com/
CLASS 12 COMPUTER SCIENCE TEXTBOOK
[SUMITA ARORA]
19
