PANCHSHEEL PUBLIC
SCHOOL
ACADEMIC YEAR 2024-2025
PYTHON PROJECT FILE
Roll no:
Name : ANUJ KUMAR THAKUR
Class: XII A
Subject: COMPUTER SCIENCE
Project guide: Mrs SANGEETA YADAV
Index
1. Project Title
2. Certificate
3. Acknowledgment
4. Introduction
5. About the Programming Language (Python +
SQL)
6. Libraries
7. Project Modules
Certificate
This is to certify that ANUJ KUMAR THAKUR has
successfully completed the CD/DVD Management
System project as part of CLASS 12TH at
PANCHSHEEL PUBLIC SCHOOL The project was
completed in session 2024-2025
Sign of subject Sign of
examiner
teacher
Acknowledgment
I would like to express my special thanks of
gratitude to my Computer science teacher "MRs.
sangeeta yadav” for their able guidance and
support in completing my Project.
I would also like to extend my gratitude to the
Principal Mam "MRS Bharti mehta for providing
me with all the facility that was required
Name-anuj kumar thakur
Introduction
The CD/DVD Management System is a web-based
application designed to facilitate the
management of CDs and DVDs in a store. It
allows users to add, borrow, and return CDs and
DVDs, providing a user-friendly interface for
efficient. of media The system is developed using
Python and SQL, and utilizes the Django
framework and MySQL database.
About the Programming
Language (Python SQL)
Python: Python is a high-level, interpreted
programming language known for Its readability
and versatility. It is widely used for web
development, data analysis, artificial intelligence,
and more
Python is dynamically typed and garbage-
collected. It supports multiple programming
paradigms,
including structured (particularly procedural), obj
ect-oriented and functional programming. It is
often described as a "batteries included"
language due to its comprehensive standard
library.
Guido van Rossum began working on Python in
the late 1980s as a successor to
the ABC programming language and first
released it in 1991 as Python 0.9.0. Python 2.0
was released in 2000. Python 3.0, released in
2008, was a major revision not
completely backward-compatible with earlier
versions. Python 2.7.18, released in 2020, was
the last release of Python 2.
Python consistently ranks as one of the most
popular programming languages, and has gained
widespread use in the machine
learning community.
SQL: Structured Query Language (SQL) is a
standardized programming language that is used to
manage relational databases and perform various
operations on the data in them. Initially created in the
1970s, SQL is regularly used not only by database
administrators but also by developers writing data
integration scripts and data analysts looking to set up
and run analytical queries.
The term SQL is pronounced ess-kew-ell or sequel.
SQL is used for the following:
Modifying database table and index structures.
Adding, updating and deleting rows of data.
Retrieving subsets of information from within
relational database management systems. This
information can be used for transaction
processing, analytics applications and other
applications that require communicating with a
relational database.
Libraries
For a CD/DVD management system using Python
and SQL, you can utilize the following libraries:
1.SQLite3: For a lightweight database to store
CD/DVD information. It comes built-in with
Python.
[Link]: An ORM (Object Relational
Mapper) that makes it easier to interact with
SQL databases in a more Pythonic way.
[Link]: For building the graphical user
interface (GUI) for user interactions.
[Link]: For data manipulation and analysis if
you need to handle datasets more easily.
[Link]: For file management and interacting with
the file system.
[Link]: If you plan to connect to any online
APIs for fetching additional data.
Project Modules
The project consists of the following modules:
User Authentication Module: This module
handles user registration, login, and session
management.
CD Management Module: This module allows
users to add, view, and manage CDs.
DVD Management Module: This module is
similar to the CD module, but for DVDs.
Borrowing and Returning Module: This
module manages the borrowing and returning
process for CDs and DVDs.
Search Module: This module enables users to
search for CDs and DVDs by title, artist, or genre.
System Design
The system is designed using the following
components:
Frontend: The frontend is developed using
python It provides a user-friendly interface for
users to interact with the system.
Backend: The backend is developed using
Python. It handles user requests, interacts with
the database, and provides APIs for the frontend.
Database: The database is developed using
MySQL. It stores information about CDs and
DVDs, including title, artist, genre, and
availability.
Source Code
Step 1: Setting Up the Database
We will need to set up an SQLite database. Here's
how you can create a database with a table to
store CD/DVD information.
Step 2: Creating the Python Functions you
create functions to add, view, and delete
CDs/DVDs from the database
Step 3: User Interface You can create a simple
command-line interface to interact with the s
Bibliography
[Link]
[Link]
Computer science with python by Smita
Arora
