SSM ACADEMY [CBSE] SR.SEC.

SCHOOL-DINDIGUL

affiliated to Central Board of Secondary Education-New Delhi

Affiliation number: 1930414 school code: TN-55351

ACADEMIC YEAR (2024-2025)

PROJECT REPORT

The project submitted to the

CENTRAL BOARD OF SCHOOL EDUCATION
in partial fulfillment of the requirements for the
ALL INDIA SENIOR SECONDARY CERTIFICATE EXAMINATION
(AISSCE) - SECOND YEAR
 SSM ACADEMY[CBSE]SENIOR
SECONDARY SCHOOL
DINDIGUL
PROJECT WORK
2024-2025

NAME : NANTHIGA HARINI M.V

CLASS :
SUBJECT : Computer Science (083)
Roll No. :
 SSM ACADEMY [CBSE] SR.SEC.SCHOOL-Dindigul
Affiliated by Central Board of Secondary Education-New Delhi

Affiliation number: 1930414 school code: TN-55351

CERTIFICATE
Certified to the Bonafide Project report work done

in Computer Science by NANTHIGA HARINI M.V

Roll number

Standard XII of Group

during the year 2024-2025.

Signature of teacher Principal

Submitted for the AISSCE (Project/Practical)

Examination Held on

Internal Examiner External Examiner

DONE BY:
1. NANTHIGA HARINI M.V
2. PANDI JOTHI K
3. RAGAVI S

FROM CLASS:
 ACKNOWLEDGEMENT

I would like to express my sincere thanks to everyone who contributed to the

completion of my computer science project.

Firstly, I wish to thank my computer teacher, whose continuous support and

guidance were instrumental in making this project a success. His/her theoretical
knowledge and valuable guidance made me understand complex concepts, and I
amgrateful for the encouragement throughout the project.

I want to express my gratitude to our honorable principal for providing us with the
opportunity to delve into technology education, and for the faculty members who
played a big role in making the theoretical aspects understandable.

I would like to acknowledge my friends, who not only supported me throughout

but also provided the best samples and practical insights. Their guidance and
encouragement were crucial in refining the project at various stages.
 TABLE OF CONTENT

S.NO. DESCRIPTION PAGENO.

01. REQUIREMENTS 01

02. INTRODUCTION 02

03 PURPOSE OF THE PROJECT 05

04. FEATURES OF PYTHON 06

05. FEATURES OF MYSQL 12

06 SOURCE CODE 18

07. OUTPUT 26

08. BIBLIOGRAPHY 32
HARDWARE AND SOFTWARE REQUIRED

 HARDWARE
OPERATING SYSTEM: window 8.1 and above
PROCESSOR: intel core
DISPLAY: Monitor
RAM: 512 GB

 SOFTWARE

APPLICATION:

python3.10 and above version

DATABASE:
MySQL server8.0

Page 1
 INTRODUCTION

This project automates the E-COMMERCE DATABASE

MANAGEMENT SYSTEM which
gives the user three different options to search for
the product of their choice, and finally place their
orders.

The first option is to search through various

categories of products, e.g.
Smartphones, Clothes, Groceries, etc.
The user can choose their category and they will be
shown all the products available in that particular
category.

Page 2
The second option is to take a look at all the
products available. The user can choose to take a look at
all the different types of products available and choose
their product from there.

The third option is to search through the various brands

available. The user can choose to take a look at all the
brands available and select a particular brand. On
choosing the particular brand the user will be shown all
the products that are available from that particular
brand.

Page 3
Lastly, the user can place an order for their product of
choice.

On placing the order for a particular product, that product

is added into the order_table in the database with various
other details like the transaction ID (which is allotted to
every transaction that has been made), product ID,
product name, date of dispatch, and the contact details of
the customer.

Also, the quantity of the product which has been

ordered is reduced by 1 from the main_table.

Page 4
PURPOSE OF THIS PROJECT
The purpose of this project is to provide an interface to
the user which is easy to use and efficient.

It also helps the e-commerce company to keep track

of the products available, and the transactions being
made.

SOME IMPORTANT TERMS

● MySql Database
● Interfacing MySql with python
● MySql connector
● Functions in Python

Page 5
FEATURESOFPYTHON

Page 6
PYTHON is a dynamic, high-level, free open-source, and interpreted
programming language. It supports object-oriented programming as well
as procedural-oriented programming.
In Python, we don’t need to declare the type of variable because it is a
dynamically typed language. For example, x = 10 Here, x can be
anything such as String, int, etc. In this article, we will see what
characteristics describe the Python programming language.

Page 7
 FEATURES IN PYTHON

In this section we will see what are the features of Python

programming language:

1. Free and Open Source:

Python language is freely available at the official website and you can
download it from the given download link below click on the Download
Python keyword. Download Python Since it is open-source, this means
that source code is also available to the public. So you can download it, use
it as well as share it.

2. Easy to code:
Python is a high-level programming language. Python is very easy to
learn the language as compared to other languages like C, C#, Javascript,
Java, etc. It is very easy to code in the Python language and anybody can
learn Python basics in a few hours or days. It is also a developer-
friendly language.

Page 8
3. Easy to Read:
As you will see, learning Python is quite simple. As was already
established, Python’s syntax is straightforward. The code block is defined by
the indentations rather than by semicolons or brackets.

4. Object-Oriented Language:
One of the key features of Python is Object-Oriented programming.
Python supports object-oriented language
and concepts of classes, object encapsulation, etc.

5. High-Level Language:
Python is a high-level language. When we write programs in Python, we
do not need to remember the system architecture,
nor do we need to manage the memory.

Page 9
5. lLarge Community Support:
Python has gained popularity over the years. Our questions are
constantly answered by the enormous Stack Overflow community. These
websites have already provided answers to many questions about Python, so
Python users can consult them as needed.

6. Easy to Debug:
Excellent information for mistake tracing. You will be able to quickly
identify and correct the majority of your program’s issues once you
understand how to interpret Python’s error traces. Simply by glancing at
the code, you can determine what it is designed to perform.

7. Python is a Portable language:

Python language is also a portable language. For example, if
we have Python code for Windows and if we want to run this code on
other platforms such as Linux, Unix, and Mac then we do not need to
change it, we can run this code on any platform.

Page 10
8. Python is an integrated language:
Python is also an integrated language because we can easily integrate
Python with other languages like C, C++, etc.

9. Interpreted Language:
Python is an Interpreted Language because Python code is executed line
by line at a time. like other languages C,
C++, Java, etc. there is no need to compile Python code this makes it easier
to debug our code. The source code of Python is converted into an
immediate form called bytecode.

Page 11
FEATURES OFMYSQL

Page 12
MySQL is a relational database management system (RDBMS) based
on SQL (Structured Query Language) queries. It is one of the most
popular languages for accessing and managing the records in the table.
MySQL is open-source and free software under the GNU license. Oracle
Company supports it.

Page 13
 FEATURES IN MYSQL

1. Relational Database Management System (RDBMS):

MySQL is a relational database management system. This database
language is based on SQL queries to access and manage the records of
the table.

2. Easy to use:
MySQL is easy to use. We have to get only the basic knowledge of
SQL. We can build and interact with MySQL by using only a few simple SQL
statements.

3. It is secure:
MySQL consists of a solid data security layer that protects sensitive data
from intruders. Also, passwords are encrypted in MySQL. 09

Page 14
3. Client/ Server Architecture:
MySQL follows the working of a client/server architecture.
There is a database server (MySQL) and arbitrarily many clients
(application programs), which communicate with the server; that is, they
can query data, save changes, etc.

4. Free to download:
MySQL is free to use so we can download it from MySQL's official
website without any cost.

5. It is scalable:
MySQL supports multi-threading which makes it easily scalable.
Itcan handle almost any amount of data, up to as much as 50 million
rows or more. The default file size limit is about 4 GB. However, we can
increase this number to a theoretical limit of 8 TB ofdata.

Page 15
6. Compatible on many operating systems:
MySQL is compatible to run on many operating systems, like Novell
NetWare, Windows* Linux*, many varieties of UNIX* (such as Sun*
Solaris*, AIX, and DEC* UNIX), OS/2,Free BSD*, and others. MySQL
also provides a facility that the clients
can run on the same computer as the server or on another computer
(communication via a local network or the Internet).

6. Memory efficiency:
Its efficiency is high because it has a very low memory leakage
problem.

Page 16
Disadvantages/Drawbacks of MySQL
Following are the few disadvantages of MySQL:
o MySQL version less than 5.0 doesn't support ROLE,
COMMIT, and stored procedures.
o MySQL does not support a very large database size as
efficiently.
o MySQL doesn't handle transactions very efficiently, and it is
prone to data corruption.
o MySQL is accused of not having a good developing and
debugging tool compared to paid databases.
o MySQL doesn't support SQL check constraints.

Page 17
SOURCE
CODE

Page 18
|P age

Page 19
|P age

Page 20
Page 21
Page 22
MYSQL TABLE

Page 23
Page 24
Page 25
OUTPUT

Page 26
Page 27
Page 28
Page 29
Page 30
Page 31
 REFERENCES

● Class 11 Book (Sumitra Arora Python)

● Class12 Book( Sumitra Arora python)
● LINKS:.
www.google.com

Page 32