PROJECT
REPORT
Submitted By: Afreen Begum
Class: XII B
E-COMMERCE DATABASE
MANAGEMENT SYSTEM
PROJECT REPORT
(2023-2024)
IN PARTIAL FULFILLMENT OF THE
REQUIREMENT FOR THE AWARD OF
THE CLASS
COMPUTER SCIENCE
SUBMITTED BY
AFREEN BEGUM
UNDER THE GUIDANCE OF
Mrs. AULVEERA
(MSc. Software Engineering, [Link]
Computer Science, [Link])
PGT COMPUTER SCIENCE
INDEX
PAGE
[Link]. TITLE NO.
1 Certificate 01
2 |Acknowledgement 02
3 Declaration 03
4 Hardware & Requirement Software 04
5 |Introduction of Python & MySQL 05
6 Introduction Of Project 07
7 Objectives of the project 11
Scope of the project 12
9 Source Code 14
10 Output of the Code 21
11 Bibliography 26
UMMAT PUBLIC SCHOOL
COMPUTER SCIENCE
2023-2024
BONAFIDE CERTIFICATE
This is to certify that this project
"E-COMMERCE
DATABASE MANAGEMENT SYSTEM" is a record of
bonafide work carried out by
AFREEN BEGUM
in partial fulfillment of the requirement in Computer
Science(083) prescribed by CBSE for AISSCE 2023-2024
in the school "Ummat Public School",
Date: Principal's Signature
APUB LAILAMMA KT
SR. BEC TooH PRINCIPAL
UMMAT PUBLIC SCHOOL
PORTBLAIR) PORT BLAIR
KWDAMA
Internal xaminer's Sign External Examiner's Sign
ACKNOWLEDGEMENT
It gives me great pleasure to express mny gratitude
towards my Computer Science Teacher Mrs.
Aulveera for her guidance, support and
encouragement throughout the development of
this (E-COMMERCE DATABASE MANAGEMENT
SYSTEM) project.
This project is an original piece of work. I would
also like to thank my Principal Mrs. Lailamma KT
for motivation, without her help this project could
not be possible to bring up to this form.
DECLARATION
We hereby declare that the project work
entitled "E-COMMERCE DATABASE
MANAGEMENT SYSTEM" submitted to
Ummat Public School for the subject of
Computer Science
Under the guidance of
Mrs. Aulveera
PGT Computer Science
is a record of original work done by us. We
further declare that this project record or any
part of this has not been submitted elsewhere
for any other class.
HARDWARE AND SOFTWARE
REQUIREMENT
Hardware
Operating System
4 GB RAM
5GB free disk space.
SOFTWARE
PYTHON (latest version)
MYSql Python Connector
INTRODUCTION OF PYTHON AND MYSQL
º PYTHON:OVERVIEW
an interpreted, object-oriented, high-level
Python is
language with dynamic semantics. Its
programming
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, easyto learn syntax emphasizes readability
and therefore reduces the cost of program
[Link] 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.
> MySQl: OVERVVEW
MySQL
MySQL is an Oracle-backed open source relational
database management system (RDBMS) based on
Structured Query Language (SQL). It runs on all
platforms, including Linux, UNIX and Windows.
Although it can be used in a wide range of
applications, it is most often associated with web
applications and online publishing. The MySQL
database server is very fast, reliable, scale-able, and
easy to use. It was developed to handle large
databases much faster than existing solutions. SQL is
the most common standardized language used to
access database.
INTRODUCTION
This project automates the E-COMMERCE
DATABASE MANAGEMENT SYSTEM which
gives the user threedifferent options
through which theycan search for the
product of their choice, and finally place
their orders.
Thefirst option is to search through various
catagories of products, for e.g.
Smartphones, Clothes, Groceries, etc.
The user canchoose their category and they
willbe shown all the products
available in
that particular category.
The second option is to take a look at all the
products available. The user can choose to
take alook 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 choose aparticular [Link]
choosing the particular brand theuser will
beshown all the products that are available
from that particular brand.
Lastly, theuser can place an order of their
product of choice. On placing the order of a
particularproduct, 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.
PURPOSE OF THIS PROJECT
The purpose of this project is to provide an
interface tothe user which is easy to use
and efficient.
Italso helps the e- commerce company to
keep a track of the products available, and
thetransactions which are being made.
SOME IMPORTANT TERMS
"MySgl Database
" Interfacing MySql with python
"MySgl connector
"Functions in python
OBJECTIVES OF THE PROJECT
>To reach maximum customers at the right
time
> Increase sales and profitability of the
business
>Allows the Customers to Overcome
geographical barriers and allows them to
purchase products anytime and from
anywhere
º Produce information needed for business
transactions that is available when
needed
SCOPE OF THE PROJECT
>The potential for e-commerce
development is enormous.
>Now a days one can buy products
online through some sites like
Flipkart and Amazon. In the age of e
Commerce everything from gym
equipment to laptops are available
online.
>E-Commerce is a Super set of
business cases.
be
>Scope of e-commerce can
enumerated as follows:
1. Exchange of digitized information
2. Technology-enabled
3. Customers retention
4. Accounting
5. Supplier integration
6. Support the exchange
SOURCE
CODE
OUTPUT:
WELCOME TO E-SHOP :)
Press 1 if you are looking for a category.
Press 2 if you are looking for a product.
Press 3 if you are looking for a brand.
Press 4 if you want to place an order.
Enter your number: 1
*********Catagories available are:
Smartphones
TABLETS
Television
Clothes
Shoes_Footwears
Grocery
Games
Enter your category: |
BIBLIOGRAPHY
1. Computer Science Class XII (By: SUMITA ARORA)
2. [Link]
3. [Link]/Python project
4. [Link]/python projects
5. [Link]
6. Class notes