Shri C. J.
Patel College of Computer Studies,
Visnagar
Group No :- 22
A
PROJECT REPORT
ON
E-commerce web site for shopping
(BAKERY SHOP-SWEET STAR)
Submitted to: Shahnavaz Khan Pathan
Shri C. J. Patel College of Computer Studies,
Visnagar
Affiliated to
Submitted by:
Project Partner Details
SHEKH BASIR ILIYASBHAI 192
RAVAL HET SUNILKUMAR 235
THAKOR HARSH RAMANJI 246
CHAVDA DHRUV ISHWERBHAI 019
[1 ]
Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
INDEX
Sr. No Contents Page No:
1. Preface/Introduction of Project 3
2. Acknowledgment 4
3. Drawback of Existing System 5
4. Need for new System 6
5. Tools & Technology 7
i. Software Tools 7
ii. Hardware Tools
6 i. Data Flow Diagram 8
ii. ER – Diagram 11
7. Bibliography 21
[2 ]
Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Preface
online Bakery shop allows users to check and purchase
various bakery products available online.
The project consists of list of bakery products displayed in
various categories and the user can browse through the
items.
User can add the selected items it to his shopping cart. User
needs to register on the site before checking out.
He can then login using same id password next time. Now he
may pay through a credit card or cash on delivery.
The user receives a copy of the shopping receipt on his email
id after the successful transaction.
Here we use user-friendly interface to make the entire
frontend.
The middle tier or code behind model is designed for fast
processing.
In addition, SQL serves as a backend to store bakery products
lists data.
Thus, the online Bakery shopping project brings an entire
bakery shop online.
making it easy for both buyer and seller.
[3 ]
Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Acknowledgement
This major project would not have been possible without the help of
many people. Here after, we would like to thank them for their help,
support, and advice they have given us while working on the project.
First, we would like to thank our Major Project guide, Prof.
ShahnavazKhan Pathan for his guidance, help, and the many discussion
sessions that gave us courage and enthusiasm to Batchelor of Computer
for their support and guidance. We extend our gratitude to BCA
College, Dr. Abhijeetsinh Jadeja.
Finally, we would like to thank our collage. Shri C.J Patel College of
Computer Studies to provide the excellent environment to us and for
this opportunity to work on this project
[4 ]
Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Drawback of Existing System
The Existing System has several drawback like
TIME AND ENERGY
It’s cause many time and Energy as well.
PRODUCT CHOICEMENT
Exiting System is lack of in product choice.
Customer can’t Choose goods some times.
SERVICES FOR CUSTOMER
Exiting System has lower Customer support.
They aren’t available 24/7.
LCK OF ORDER OF PRODUCT MANAGEMENT
We have go to shop to take out order/product.
It’s also cause lots of time Energy.
LOW DEAL & OFFERS
Exiting System has Lower offers Support for Customer.
Exiting System have many Lower Support to new Customer.
RETURN POLICY
Exiting System has no or maybe return policy.
Customer can’t trust easily.
LOW MANAGEMENT SYSTEM
Customer can’t Find there order product easily.
Low detail of Customer.
[5 ]
Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Need for new System
SAVE TIME AND ENERGY
Customer can get & choose product easily without
even presented on shop physically,
It’s save many energy & time.
PRODUCT CHOICEMENT
Customer can get there own product by searching
product list,
It’s way to help customer & gain there interest in
shop
SERVICES FOR CUSTOMER
Our website provide 24/7 customer care support,
Query section also available.
BETTER ORDER OF PRODUCT
We provide your product in your home,
Customer don’t need to go shope to take product.
BETTER OFFERS & DISCOUNT
We will provide best details & discount for
customer,
Special discount for new users
RETURN POLICY
We will provide customer to Return policy with on
some condition,
EX- Return policy available for 1 day not more than
BETTER MANAGEMENT
[6 ]
Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
We have better management for customer , details
& many information.
Tools & Technology
Software Tools
FRONT END:- HTML, CSS , JAVASCRIPT
BACK END:- PHP , MYSQL
DESIGN:- VS CODE
o DOCUMENTATION:-
Hardware Tools
PROCESSOR:- i3-
RAM:- 8 GB
HARD DISK:- 256
[7 ]
Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Data Flow Diagram
LEVEL 0 - DFD
[8 ]
Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
ADMIN 1st LEVEL DFD
[9 ]
Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
USER 1st LEVEL DFD
[1 ]
0 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
ER- Diagram
[1 ]
1 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
[1 ]
2 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Hierachy Diagram
Online bakery shop
website
1. Search 3. Add Product to
2. Choose Product 4. Payment
Product cart
Search Product
Category
2.2Final
2.1 Choose Another
Choose
3.1 Final Buy
4.1Online Payment
4.2 Cod
Option
[1 ]
3 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Login table
Sr.No Field Name Field Field Constraints Description
Type Size
1 USERNAM VARCHAR 15 NOT NULL USER
E NAME
2 PASSWORD VARCHAR 10 NOT NULL PASSWORD
Description:-
The Login Table Store authorize Username and
Password.
[1 ]
4 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Login table
Sr.No Field Name Field Field Constraints Description
Type Size
1 ADMIN NAME VARCHAR 15 NOT NULL ADMIN USER
NAME
2 PASSWORD VARCHAR 10 NOT NULL PASSWORD
[1 ]
5 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Admin Table
Sr.no Field name Field Field constraints description
type size
1 A ID INT 10 FOREIGN ADMIN ID
KEY
2 A NAME VARCHAR 10 NOT NULL ADMIN
NAME
3 EMAIL VARCHAR 20 NOT NULL ADMIN
EMAIL
4 PASSWOR STRING 10 NOT NULL ADMIN
D PASS
[1 ]
6 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
USER Table
Sr.No Field Name Field Field constraints Descreption
Type Size
1 USERNAM VARCHAR 15 NOT NULL USERNAME
E
2 EMAIL VARCHAR 30 NOT NULL EMAIL
3 PASSWORD VARCHAR 10 NOT NULL PASSWORD
4 CONFIRM VARCHAR 10 NOT NULL CONFIRM
PASSWORD PASSWORD
5 ADDRESS VARCHAR 60 NOT NULL ADDRESS
[1 ]
7 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Product Table
Sr.No Field Name Field Field Constraints Description
Type Size
1 P ID VARCHAR 20 PRIMARY KEY PRODUCT ID
2 P NAME VARCHAR 20 PRIMARY PRODUCT
KEY NAME
3 P PRICE VARCHAR 05 PRIMARY PRODUCT
KEY PRICE
4 PIMAGE IMAGE 50 NOTNULL PRODUCT
IMAGE
5 P CATEGORY VARCHAR 10 NOT NULL PRODUCT
CATEGORY
6 PDESCRIPTION VARCHAR 60 NOT NULL PRODUCT
DECRIPTION
[1 ]
8 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Order Table
Sr.No Field Name Field Fiel Constraints Description
Type d
Size
1. O NAME VARCHAR 15 PRIMERY ORDER NAME
KEYTYHU
2. O DETAIL VARCHAR 60 NOT NUL ORDER DETAIL
3. P ID VARCHAR 20 FOREIGN KEY PRODUCT ID
[1 ]
9 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Category Table
Sr.No Field Field Field Constraints Description
Name Type Size
1 C NAME VARCHAR 15 PRIMARY CATEGOERY
KEY NAME
2 C ID VARCHAR 20 NOT NULL CATEGOERY ID
3 C VARCHAR 50 NOTNULL CATEGOERY
SELCTION SELECTION
[2 ]
0 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
PAYMENT TABLE
Sr.No Field Field Field Constraints Description
Name Type Size
1 P ID VARCHAR 20 FOREIGN PRODUCT ID
KEY
2 PAYMEN VARCHAR 20 NOT NULL COD( CASE ON
TYP DELIVERY)
ONLINE
PAYMENT
3 P DETAIL VARCHAR 50 NOTNULL PAYMENT
DETAIL
[2 ]
1 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Bibliography
[2 ]
2 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
[2 ]
3 Project Title
Shri C. J. Patel College of Computer Studies,
Visnagar
Thank
you
[2 ]
4 Project Title
