Kanha Makhan Public School

Baad (Mathura)

ACADEMIC YEAR: 2024-2025

Project Report on

Project Name

ROLL NO : ________________

NAME : 1. ____________ & 2. __________________

CLASS : XII

SUBJECT : COMPUTER SCIENCE

SUB CODE : 083

PROJECT GUIDE : Mr. Uma Shankar Garg

PGT (Computer Science)

Kanha Makhan Public School, Township (Mathura)

CERTIFICATE

This is to certify that Mr. / Ms. ____________ Roll No: __________ has successfully completed the

project Work entitled Project Name in the subject Computer Science (083) laid down in the

regulations of CBSE for the purpose of Practical Examination in Class XII to be held in Kanha

Makhan Public School, Township (Mathura) on _____________.

_________________________

(Uma Shankar)
PGT Computer Science

Examiner:

Name: _______________

Signature: _______________
ACKNOWLEDGEMENT

Apart from the efforts of me, the success of any project depends largely on the encouragement and
guidelines of many others. I take this opportunity to express my gratitude to the people who have
been instrumental in the successful completion of this project.

I express deep sense of gratitude to almighty God for giving me strength for the successful
completion of the project.

I express my heartfelt gratitude to my parents for constant encouragement while carrying out
this project.

I gratefully acknowledge the contribution of the individuals who contributed in bringing this
project up to this level, who continues to look after me despite my flaws,

I express my deep sense of gratitude to the luminary The Principal, Kanha Makhan Public
School, Township (Mathura) who has been continuously motivating and extending their helping hand
to us.

I am overwhelmed to express my thanks to The Administrative Officer for providing me an

infrastructure and moral support while carrying out this project in the school.

My sincere thanks to Mr. Uma Shankar, Project guide, Mentor all the above a friend, who
critically reviewed my project and helped in solving each and every problem, occurred during
implementation of the project

The guidance and support received from all the members who contributed and who are
contributing to this project, was vital for the success of the project. I am grateful for their constant
support and help.
About Project

Banking management involves a series of essential operations, ranging

from opening new accounts to facilitating customer transactions. To
initiate the banking relationship, the process of opening a new account
begins with collecting pertinent customer details, generating a unique
account number, and updating both the "customers" and "accounts"
tables in the database. Subsequently, depositing and withdrawing
funds are integral components of day-to-day banking. When a
customer deposits an amount, the system identifies the relevant
account and updates the balance accordingly, recording the transaction
for reference. Similarly, for withdrawals, the system checks for
adequate funds, processes the withdrawal, and logs the transaction
details. Additionally, providing comprehensive customer details
involves retrieving and presenting information based on customer-
specific queries, ensuring a seamless and personalized banking
experience. These operations collectively contribute to the efficient and
secure functioning of a banking management system, offering a robust
foundation for customer interactions and financial transactions.
HARDWARE AND SOFTWARE USED

HARDWARE

 Processor : Pentium Dual Core

 RAM : 2 GB

 Hard disk : 128 GB

 Monitor : USB

 Keyboard and Mouse : USB

SOFTWARE

 Operating System : WINDOWS 10

 Language : Python 3.13
 RDBMS : MySQL 8.0

.
What is Python
Python is an interpreted, object-oriented, high-level programming language with dynamic semantics. Its high-
level built in data structures, combined with dynamic typing and dynamic binding, make it very attractive for
Rapid Application Development, as well as for use as a scripting or glue language to connect existing
components together. Python's simple, easy to learn syntax emphasizes readability and therefore reduces the
cost of program maintenance. Python supports modules and packages, which encourages program modularity
and code reuse. The Python interpreter and the extensive standard library are available in source or binary form
without charge for all major platforms, and can be freely distributed.

Often, programmers fall in love with Python because of the increased productivity it provides. Since there is no
compilation step, the edit-test-debug cycle is incredibly fast. Debugging Python programs is easy: a bug or bad
input will never cause a segmentation fault. Instead, when the interpreter discovers an error, it raises an
exception. When the program doesn't catch the exception, the interpreter prints a stack trace. A source level
debugger allows inspection of local and global variables, evaluation of arbitrary expressions, setting
breakpoints, stepping through the code a line at a time, and so on. The debugger is written in Python itself,
testifying to Python's introspective power. On the other hand, often the quickest way to debug a program is to
add a few print statements to the source: the fast edit-test-debug cycle makes this simple approach very
effective.

Advantages of Python

 Easy to Learn and Use

For Beginners, Python is simple to understand and use. It's a highly developed programming language with an
English-like syntax. The language is simple to adapt as a result of these factors. Because of its simplicity,
Python's fundamentals can be implemented faster than those in other programming languages.

 Free and Open-Source

Python is distributed under an open-source license approved by the Open-Source Initiative (OSI). As a result,
users can work on it and distribute it. Users can download the source code, modify it, and even distribute their
Python version. Companies that wish to modify a specific behavior and build their version will benefit.

 Rapid Development

Users can create new kinds of applications using the Python programming language. Because of its versatility,
this language permits the operator to try new things. Because of the language, the user is not prevented from
trying something new. Python is favored in these scenarios since other programming languages lack the
flexibility and freedom that Python does.

 Interpreted Language

Python is an interpreted language, implying that the code is implemented line by line. This is one of the features
that makes it simple to use. In the event of an error, it halts the process and reports the problem. Python only
shows one error, even if the program has multiple errors. This makes debugging easier.

 Wide Range of Libraries and Frameworks

Python includes a huge number of libraries that the user can use. The standard library in Python is immense,
and it includes almost every function imaginable. Large and supportive communities, as well as corporate
sponsorship, have contributed to this. When working with Python, users do not need to use external libraries.

 Dynamically Typed

Until we run the program, Python has no idea what kinds of parameter we're talking about. It allocates the data
type automatically during execution. Variables and their data types do not need to be declared by the
programmer.

 Portability

Many other languages, including C/C++, demand that user must change their code to run on different platforms.
Python, on the contrary, is not equivalent to other programming languages. It only needs to be written once, and
then it can be run anywhere. However, the user should avoid involving any system-dependent features.

 Strong Community Support

Python is a programming language generated many years ago and has a large community that can assist
programmers of all experience levels, from rookies to specialists. Python's community has helped it grow
quickly in comparison to other languages. The Python programming language comes with many guides,
instructional videos, and highly understandable documentation to help developers learn the language faster and
more effectively.

Applications of Python

Here are the most common applications of Python in the world of programming.

 Visualization of data

Another popular and growing area of interest is data visualization. Again, it plays to many of Python's strengths.
Python, in addition to its flexibility and open-source nature, offers a wide range of graphic libraries with a
variety of features.

 Artificial intelligence and machine learning

Python is a stable, versatile, easy yet effective programming language that is ideal for various machine learning
(ML) and artificial intelligence (AI) projects. Thanks to the abundance of Python machine learning and artificial
intelligence libraries and packages, python is undoubtedly one of the most widely used programming languages
among data analysts and data scientists.

 Data Analytics

Python makes sense for data science and analytics. The language is simple to learn, flexible, and very well
supported, making it quick and simple to use for data analysis. It's useful for attempting to manipulate data and
performing repetitive tasks when working directly with huge amounts of data.

 Desktop GUI

Python is a much more interactive language for programmers than other languages that enable developers to
quickly and easily create graphical user interfaces. It includes many built-in tools such as PyQT, wxWidgets,
kivy, and many other packages and libraries that can be used to create a fully operational GUI efficiently and
securely.

 Web Development

Web design and development using Python is very efficient. This is largely due to the innumerable Python web
development paradigms, such as Django, Flask, and Piramyd that are available. These frameworks have been
used by sites and services such as Spotify, Reddit, and Mozilla.

 Audio and Visual Applications

Python's audio and visual applications are, without a doubt, its most impressive feature. Python comes with
many frameworks and functions to help us complete our tasks flawlessly. Netflix, Hubspot, and YouTube are
just a few examples of Python-based applications. Libraries like Mignus, Dejavu, Pyo, SciPy, and OpenCV can
help.

 CAD Applications

Digitally created 3D and 2D models. Architects, construction managers, and product designers use this
application to build things with extremely high consistency, which has replaced manual drift. Python comes
pre-installed with fantastic applications such as Blender, Open Cascade, FreeCAD, and many others that help us
design products quickly. Technical drawing, dynamic system development and import are all enhanced features.

 Scientific Computing

Python is becoming more widely used in finance, particularly in domains such as qualitative data analysis and
qualitative analysis. It can be a useful tool for predicting asset price trends, automating workflows across
multiple data sources, and deciding asset price patterns and predictions.

 Web Scraping Application

Web scraping is a fully automated method of extracting data from webpages in a more efficient and timely
manner. Researchers, organizations, and analysts use the data for a wide range of purposes. Python has a
number of characteristics that make it ideal for web scraping, including:

o A simple syntax that improves readability and saves time.

o Simple to use and comprehend
o The web scraping process is simple and efficient thanks to a variety of libraries and tools such as
pandas, matplotlib, and Selenium.

Other useful and important applications of Python language are:

o Game Development
o Internet of Things (IoT)
o Network Programming
o Robotics
o Natural Language Processing (NLP)
Real-World examples for Python applications

Python is used everywhere now a days. The real-world example tasks performed by Python applications are
given below.

YouTube - Video transcoding, content recommendations, and analytics.

Dropbox - Building and maintaining the file hosting service's server infrastructure.

NASA - Scientific computing, data analysis, and simulation tasks.

Spotify - Data analysis, recommendation systems, and backend services in the music streaming platform.

Instagram - Backend infrastructure and data processing in the popular social media platform.

Google - Web crawling, data analysis, and automation.

About MySQL

MySQL is the world's most popular open-source database. With its proven performance, reliability and ease-of-
use, MySQL has become the leading database choice for web-based applications, used by high profile web
properties including Facebook, Twitter, YouTube, Yahoo! and many more.
Oracle drives MySQL innovation, delivering new capabilities to power next generation web, cloud, mobile and
embedded applications.

MySQL is a Relational Database Management System

relational database stores data in separate tables rather than putting all the data in one big storeroom. The
database structure is organized into physical files optimized for speed. The logical data model, with objects such
as data tables, views, rows, and columns, offers a flexible programming environment. You set up rules
governing the relationships between different data fields, such as one to one, one to many, unique, required, or
optional, and “pointers” between different tables. The database enforces these rules so that with a well-designed
database your application never sees data that’s inconsistent, duplicated, orphaned, out of date, or missing.

The “SQL” part of “MySQL” stands for “Structured Query Language.” SQL is the most common standardized
language used to access databases. Depending on your programming environment, you might enter SQL
directly (for example, to generate reports), embed SQL statements into code written in another language, or use
a language-specific API that hides the SQL syntax.

MySQL is Open Source

Open source means it’s possible for anyone to use and modify the software. Anybody can download MySQL
software from the internet and use it without paying for it. You can also change its source code to suit your
needs. MySQL software uses the GNU General Public License (GPL) to define what you may and may not do
with the software in different situations.

MySQL benefits
MySQL is fast, reliable, scalable, and easy to use. It was originally developed to handle large databases quickly
and has been used in highly demanding production environments for many years.

Although MySQL is under constant development, it offers a rich and useful set of functions. MySQL’s
connectivity, speed, and security make it highly suited for accessing databases on the internet.

 Ease of use: Developers can install MySQL in minutes, and the database is easy to manage.
 Reliability: MySQL is one of the most mature and widely used databases. It has been tested in a wide
variety of scenarios for more than 25 years, including by many of the world’s largest companies.
Organizations depend on MySQL to run business-critical applications because of its reliability.
 Scalability: MySQL scales to meet the demands of the most accessed applications. MySQL’s native
replication architecture enables organizations such as Facebook to scale applications to support billions
of users.
 Performance: MySQL Heatwave is faster and less expensive as demonstrated by multiple standard
industry benchmarks, including TPC-H, TPC-DS, and CH-benchmark.
 High availability: MySQL delivers a complete set of native, fully integrated replication technologies
for high availability and disaster recovery. For business-critical applications, and to meet service-level
agreement commitments, customers can achieve
 Recovery point objective = 0 (zero data loss)
 Recovery time objective = seconds (automatic failover)
 Security: Data security entails protection and compliance with industry and government regulations,
including the European Union General Data Protection Regulation, the Payment Card Industry Data
Security Standard, the Health Insurance Portability and Accountability Act, and the Defense Information
Systems Agency’s Security Technical Implementation Guides. MySQL Enterprise Edition provides
advanced security features, including authentication/authorization, transparent data encryption, auditing,
data masking, and a database firewall.
 Flexibility: The MySQL Document Store gives users maximum flexibility in developing traditional
SQL and NoSQL schema-free database applications. Developers can mix and match relational data and
JSON documents in the same database and application.
File Handling in Python
File handling in Python is a powerful and versatile tool that can be used to perform a wide range of
operations. However, it is important to carefully consider the advantages and disadvantages of file handling
when writing Python programs, to ensure that the code is secure, reliable, and performs well.

Python File Handling

Python too supports file handling and allows users to handle files i.e., to read and write files, along with many
other file handling options, to operate on files. The concept of file handling has stretched over various other
languages, but the implementation is either complicated or lengthy, but like other concepts of Python, this
concept here is also easy and short. Python treats files differently as text or binary and this is important. Each
line of code includes a sequence of characters and they form a text file. Each line of a file is terminated with a
special character, called the EOL or End of Line characters like comma {,} or newline character. It ends the
current line and tells the interpreter a new one has begun. Let’s start with the reading and writing files.

Advantages of File Handling

 Versatility: File handling in Python allows you to perform a wide range of operations, such as
creating, reading, writing, appending, renaming, and deleting files.
 Flexibility: File handling in Python is highly flexible, as it allows you to work with different file
types (e.g. text files, binary files, CSV files, etc.), and to perform different operations on files (e.g.
read, write, append, etc.).
 User–friendly: Python provides a user-friendly interface for file handling, making it easy to
create, read, and manipulate files.
 Cross-platform: Python file-handling functions work across different platforms (e.g. Windows,
Mac, Linux), allowing for seamless integration and compatibility.

CSV File Reading and Writing

The so-called CSV (Comma Separated Values) format is the most common import and export format for
spreadsheets and databases. CSV format was used for many years prior to attempts to describe the format in a
standardized way in RFC 4180. The lack of a well-defined standard means that subtle differences often exist in
the data produced and consumed by different applications. These differences can make it annoying to process
CSV files from multiple sources. Still, while the delimiters and quoting characters vary, the overall format is
similar enough that it is possible to write a single module which can efficiently manipulate such data, hiding the
details of reading and writing the data from the programmer.
The csv module implements classes to read and write tabular data in CSV format. It allows programmers to say,
“write this data in the format preferred by Excel,” or “read data from this file which was generated by Excel,”
without knowing the precise details of the CSV format used by Excel. Programmers can also describe the CSV
formats understood by other applications or define their own special-purpose CSV formats.

The csv module’s reader and writer objects read and write sequences. Programmers can also read and write data
in dictionary form using the DictReader and DictWriter classes.

Binary Files
Generally, binary means two. In computer science, binary files are stored in a binary format having digits 0’s
and 1’s. For example, the number 9 in binary format is represented as ‘1001’. In this way, our computer stores
each and every file in a machine-readable format in a sequence of binary digits. The structure and format of
binary files depend on the type of file. Image files have different structures when compared to audio files.
However, decoding binary files depends on the complexity of the file format. In this article, let’s understand the
reading of binary files.

Reading Binary Files in Python

Reading binary files is an important skill for working with data (non-textual) such as images, audio, and videos.
Using file mode and the “read” method you can easily read binary files. Python has the ability to handle the data
and consent provides various help with certain criteria. Whether you are dealing with multimedia files,
compressed data, or custom binary formats, Python’s ability to handle binary data empowers you to create
powerful and versatile applications for a wide range of use cases. In this article, you will learn What binary files
are and how to read data into a byte array, and Read binary data into chunks? and so on.
SOURCE CODE
OUTPUT
BIBLIOGRAPHY

1. Computer Science with Python - Class XI By: Sumita Arora

2. Computer science with Python - Class XII By: Sumita Arora
3. Website: https://www.wikipedia.org
4. Website: https://www.google.com