0% found this document useful (0 votes)
25 views41 pages

Online Cake Ordering System Project

The document outlines the project titled 'Online Cake Ordering System' submitted by students Faizan Shaikh and Mehboob Khajure as part of their BBA-CA degree requirements. It details the system's objectives, specifications, and the advantages of automating the existing manual cake ordering process to improve efficiency and data management. The project aims to provide a user-friendly platform for customers to order cakes online, featuring functionalities such as user registration, order tracking, and payment integration.

Uploaded by

saud.sayyed.1301
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
25 views41 pages

Online Cake Ordering System Project

The document outlines the project titled 'Online Cake Ordering System' submitted by students Faizan Shaikh and Mehboob Khajure as part of their BBA-CA degree requirements. It details the system's objectives, specifications, and the advantages of automating the existing manual cake ordering process to improve efficiency and data management. The project aims to provide a user-friendly platform for customers to order cakes online, featuring functionalities such as user registration, order tracking, and payment integration.

Uploaded by

saud.sayyed.1301
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Online Cake Ordering System

Submitted by

Faizan Shaikh
Mehboob Khajure
Seat No: XXX

In partial fulfillment of the requirement of


record of the degree
of

BBA-CA
(Bachelor or Business Administration
Computer Applications)

DPSS’S FORESIGHT COLLEGE OF COMMERCE


(Affiliated To Savitribai Phule University)
382, YMCA Complex, New Rasta Peth,
Quarter Gate, Pune–411011.

DPSS’S
FORESIGHT COLLEGE OF COMMERCE
382, YMCA Complex, New Rasta Peth,
Quarter Gate, Pune–411011

CERTIFICATE

THIS IS TO CERTIFY THAT THE PROJECT ENTITED


Online Cake Ordering System
Has been partially completed successfully by
Student Name

Towards partial fulfillment of


BACHELOR OR BUSINESS ADMINISTRATION
(COMPUTER APPLICATIONS)

Academic year 2023-2024

INTERNAL EXAMINER EXTERNAL EXAMINER


Asst. Prof. Heena Shaikh
HOD BBA-CA

DECLARATION
I affirm that the project work titled “Online Cake Ordering System” being
submitted in partial fulfillment for the award of Bachelor or Business
Administration Computer Applications is the original work carried out by
me. It has not formed the part of any other project work submitted for award of
any degree or diploma, either in this or any other University.

(Signature of the Candidate)


Candidate Name

TABLE OF CONTENTS
CHAPTER NO TITLE PAGE NO
ABSTRACT vii
LIST OF FIGURES viii
LIST OF TABLES ix
1 INTRODUCTION 1
1.1 Objective 1
2 SYSTEM ANALYSIS 2
2.1 Existing System 2
2.2 Proposed System 3
2.3 Feasibility Study 3
2.3.1 Economical Feasibility 3
2.3.2 Technical Feasibility 3
2.3.3 Operational Feasibility 3
3 SYSTEM SPECIFICATION 5
3.1 Hardware Specification 5
3.2 Software Specification 5
4 SOFTWARE DESCRIPTION 6
4.1 Package-Visual Studio 2010 6
4.2 Development Tools and Technologies 6
4.2.1 Front-end 6
4.2.2 Back-end 7
4.2.3 Connectivity 8
5 PROJECT DESCRIPTION 9
5.1 Problem Definition 9
5.2 Overview of The Project 9
5.3 Module Description 10
5.4 System Flow Diagram 13
5.5 Data Flow Diagram 13
5.6 System Design 15
5.6.1 Entity Relationship Diagram 16
5.6.3 Database Design 18
5.6.4 Input Design 24
5.6.5 Output Design 26
6 CONCLUSION AND FUTURE
29
ENHANCEMENTS
8.1 Conclusion 29
8.2 Scope for Future Development 29

ABSTRACT
The purpose of online cake Ordering System is to automate the existing manual
system by the help of computerized equipment’s and full-fledged computer
software, fulfilling their requirements, so that their valuable data/information can
be stored for a longer period with easy accessing and manipulation of the same.
The required software and hardware are easily available and easy to work with.

Online cake ordering system, as described above, can lead to error free, secure,
reliable and fast management system. It can assist the user to concentrate on
their other activities rather to concentrate on the record keeping. Thus, it will help
organization in better utilization of resources. The organization can maintain
computerized records without redundant entries. That means that one need not
be distracted by information that is not relevant, while being able to reach the
information.

The aim is to automate its existing manual system by the help of computerized
equipment’s and full-fledged computer software, fulfilling their requirements, so
that their valuable data/information can be stored for a longer period with easy
accessing and manipulation of the same. Basically, the project describes how to
manage for good performance and better services for the clients.

LIST OF DIAGRAMS
TOPIC NO. CONTENTS Page No.

5. Data Flow Diagram 13


5. Entity Relation Diagram 16

LIST OF TABLES
TOPIC NO. CONTENTS PAGE NO.
1 Database 20

1 Admin Login 22

1 User Login 22

1 Cake Detail 22

1 Cake Order Detail 24


CHAPTER 1.0
INTRODUCTION
Objective of Online Cake Ordering System

The main objective of the project online cake ordering system is to manage the
details of customer cake type order payment great managers all the information
about customer shipping address payment customer. The project is totally built at
administrative end and there’s only the administrator is guaranteed the access.
The purpose of the project is to build an application programme to reduce the
manual work for managing the customer, Cake shipping address, Type. It tracks
all the details about the type order payment.

The online cake ordering system has been developed to write the problems
prevailing in the practicing manual system stop this software is supported to
eliminate and, in some cases, reduce the hardships faced by this existing system.
Moreover, this system is designed for the particular need of the company to carry
out operations in smooth and effective manner.

The application is reduced as much as possible to avoid errors while entering the
data dot. It also provides error message while entering invalid data. Knowledge is
needed for the user to use this system. Those why these all it proves it is user
friendly. Online cake ordering system, as described above, error free cover secure,
reliable and fast management system. It Can assist the user to concentrate on
their other activities rather to concentrate on the record keeping. Thus, it will help
organization in better utilization of resources.

Every organization, every organization weather big or small has challenges to


overcome managing the information of cake customer, order, shipping address,
payment. Every online cake ordering system has different customer needs,
therefore we design explosive employee management systems that are adapted
to your managerial requirements.

This is design to assist in strategic planning and will help you ensure that your
organization is equipped with the right level of information and details for your
future goals. Also, amma for those busy executive who are always on the go our
systems come with remote access features will allow you to manage your
workforce anytime, at all time. These systems will ultimately allow you to better
manage resources.

1|Page
CHAPTER 2.0

SYSTEM ANALYSIS
Existing Systems
In the existing system the exams are done only manually but in proposed system
we have to computerize the exams using this application.

 Lack of security of data.

 More man power.

 Time consuming.

 Consumes large volume of pare work.

 Needs manual calculations.

 No direct role for the higher officials

Proposed System
The aim of proposed system is to develop a system of improved facilities. The
proposed system can overcome all the limitations of the existing system. The
system provides proper security and reduces the manual work.
 Security of data.
 Ensure data accuracy’s.
 Proper control of the higher officials.
 Minimize manual data entry.
 Minimum time needed for the various processing.
 Greater efficiency.
 Better service.
 User friendliness and interactive.
 Minimum time required.
Advantages of Proposed System

1. It is trouble-free to use.
2. It is a relatively fast approach to enter attendance
3. Is highly reliable, approximate result from user

2|Page
4. Best user Interface
5. Efficient reports
Feasibility Study
After doing the project Online Cake System, study and analyzing all the existing or
required functionalities of the system, the next task is to do the feasibility study
for the project. All projects are feasible – given unlimited resources and infinite
time.

Feasibility study includes consideration of all the possible ways to provide a


solution to the given problem. The proposed solution should satisfy all the user
requirements and should be flexible enough so that future changes can be easily
done based on the future upcoming requirements.
ECONOMIC FEASIBILITY
This is a very important aspect to be considered while developing a project. We
decided the technology based on minimum possible cost factor.

 All hardware and software cost has to be borne by the organization.

 Overall, we have estimated that the benefits the organization is going to


receive from the proposed system will surely overcome the initial costs and
the later on running cost for system.
TECHNICAL FEASIBILITY
This included the study of function, performance and constraints that may affect
the ability to achieve an acceptable system. For this feasibility study, we studied
complete functionality to be provided in the system, as described in the System
Requirement Specification (SRS), and checked if everything was possible using
different type of frontend and backend platforms.

OPERATIONAL FEASIBILITY
No doubt the proposed system is fully GUI based that is very user friendly and all
inputs to be taken all self-explanatory even to a layman. Besides, a proper training
has been conducted to let know the essence of the system to the users so that
they feel comfortable with new system. As far our study is concerned the clients

3|Page
are comfortable and happy as the system has cut down their loads and doing.

CHAPTER 3.0

4|Page
SYSTEM SPECIFICATION

HARDWARE REQUIREMENTS (Minimum Requirement)


 Minimum RAM:- 2GB
 Hard Disk:- 500GB
 Processor:-Intel Intel Core I3 ( 1.50 GHZ) or above

SOFTWARE REQUIREMENTS (minimum Requirement) (Will differ


accordingly)
 Operating system: Windows 8 and above.
 Front-End Design: Visual Studio 1.63.0
 Front-End Language: JS & CSS
 Back-End: XAMP with PHP Runtime Environment MYSQL Server (Cross
Platform Apache MYSQL PHP)

CHAPTER 4.0

SOFTWARE DESCRIPTION
5|Page
Package-Visual Studio
Visual Studio Code (VSCode) is a lightweight and versatile source-code editor
developed by Microsoft. It provides a user-friendly interface with powerful features
for coding, debugging, and version control. VSCode supports various programming
languages and extensions, making it highly customizable to suit different
development needs. Its latest version, as of my last update, is designed to offer
enhanced performance, stability, and new features to improve the coding
experience for developers.

DEVELOPMENT TOOLS AND TECHNOLOGIES


Introduction of Html

Hyper-Text Mark-up Language (HTML) is a simple mark-up system used to create


hypertext documents that are portable from one platform to another. 19 HTML
documents are SGML documents with generic semantics that are appropriate for
representing information from a wide range of applications. HTML mark-up can
represent hypertext news, mail, documentation, and hypermedia; menus of
options; database query results; simple structured documents with in-lined
graphics; and hypertext views of existing bodies of information.

Advantages of Html

1 It is widely used.

2 Every browser supports HTML language.

2 Easy to learn and use.

3 It is by default in every window so we don’t need to purchase extra software.

Introduction of CSS

Cascading Style Sheets, fondly referred to as CSS, is a simply designed language


intended to simplify the process of making web pages presentable. CSS allows you
to apply styles to web pages. More importantly, CSS enables you to do this
independent of the HTML that makes up each web page.

Advantages of CSS

6|Page
1. Greater consistency in design.

2. Ease of presenting different styles to different viewers.

About PHP:

PHP: Hypertext Pre-processor is a widely used, general-purpose scripting language


that was originally designed for web development to produce dynamic web pages.
For this purpose, PHP code is embedded into the HTML source code and can be
interpreted but a web server with PHP processor module, which helps to generate
web page document. PHP is a general-purpose scripting language that is
especially suited to server-side web development where PHP generally runs 20 on
a web server. It can also be used for command line scripting and client- side GUI
application. Many operating system and platforms, can be used with many
relational database management systems. It is also free of charge.

Working with PHP:

When a client requests web page containing PHP code from the server, then the
requested PHP pages are passed under PHP environment and interaction with
database is made if required. After server-side processing, the resulting HTML
pages are passed to client and displayed on the browser. In this way the working
of PHP is complete.

Introduction to MySQL:

MySQL is a Relational Database Management System (RDBMS) that runs as a


server providing multi-user access to a number of databases. MySQL is
pronounced (“My S-Q-L”) MySQL development project has made its source
available under the terms of General Public License. MySQL is owned and
sponsored by a single for profit firm, the Swedish company MySQL AB, now owned
by Sun Microsystem, a subsidiary of Oracle Corporation.

MySQL works on many different system platforms including AIX, BSD i, FreeBSD,
HPUX, i5/OS, Linux, Mac OS X, Net BSD, Novell NetWare, Open BSD, Open Solaris,
e com Station, OS/2 Wrap, QNX, IRIX, Solaris, Symbian, SunOS, SCO Open Server,
SCO Unix Ware, Sano’s, Tru64 and Microsoft Windows. A port of MySQL to Open
VMS also exits. All major programming languages with language specific APIs

7|Page
include Libraries for accessing MySQL database.

Connecting PHP Application with MySQL Database

 Make a connection variable with the database:

$conn =

mysql_connect(“localhost”,“servername”,“password”);

Here $conn is a connection variable to database.

 Select a database over that connection variable:

$db=mysqli_select_db(“databasename”

,“$conn”); Prepare a sql query to execute:

$query = Select * from databasename;

 Run the sql query:

$result = mysqli_query ($query);

 Iterate over the result:

while ($row = mysqli_fetch_array($result)

//statements

21

Introduction to APACHE SERVER

In this project Apache server is user to parse and execute PHP pages, before
deploying websites on the server, the website should be tested at the developer’s
side to get a feel of how the website will work on actual server.

CHAPTER NO.5

PROJECT DESCRIPTION
PROBLEM DEFINATION
The Problems are:

8|Page
• Lack of immediate retrievals.

• Lack of Immediate Information storage.

• Lack of Prompt Updating

• Preparation of accurate and prompt reports.

PROJECT OVERVIEW
SweetSlice is an online platform designed to streamline the process of ordering
custom cakes for various occasions. With the increasing trend of online shopping
and the convenience it offers, the cake industry is also adapting to online
platforms to cater to the needs of customers who prefer ordering cakes from the
comfort of their homes. SweetSlice aims to provide a seamless experience for
customers to order cakes for birthdays, weddings, anniversaries, and other special
events.

Features:

1. User Registration and Login.

2. Browse Cake Catalog.

3. Customization Options.

4. Order Placement.

5. Payment Gateway Integration.

6. Order Tracking.

7. Feedback and Reviews.

8. Admin Dashboard.

9. Analytics and Reporting.

10. Responsive Design.

MODULE DESCRIPTION
Systems are designed keeping in mind an issue that is to be solved. Every system
is designed in its unique keeping in mind the requirement of the problem or the
issue. Our system solves the problem of searching for the good that the

9|Page
customer’s needs. System design involves the design of overall architecture,
based on which we design components, modules and interfaces. The beginning of
any system architecture is by decomposing it into smaller fragments.
Decomposition and binding of components makes the architecture easy to
understand and makes it easier to understand. Our system uses algorithm for
collecting data which will collect the data of user and we have data analysing
algorithm which will analyse and highlight the needs of user.

ADMINISTRATOR MODULE:
The administrative module of the online cake ordering system is designed to
provide the administrators with the necessary tools to manage the platform
efficiently. It includes various features and functionalities that allow administrators
to oversee orders, inventory, user accounts, and other aspects of the system.

1. Dashboard:

 The administrative module starts with a comprehensive dashboard


that provides an overview of key metrics such as total orders, sales
revenue, pending orders, etc.

 Administrators can quickly access important information and navigate


to different sections of the module from the dashboard.

2. Order Management:

 Administrators can view and manage all incoming orders placed by


customers.

 They can update order statuses, such as pending, confirmed, in


progress, delivered, etc.

 Ability to track order history and details, including customer


information, delivery/pickup preferences, and order items.

3. Inventory Management:

 Administrators can manage the inventory of cakes, ingredients, and


supplies.

10 | P a g e
 They can add new cake listings, edit existing ones, or remove items
that are out of stock.

 Receive notifications for low stock levels to replenish inventory in a


timely manner.

4. User Management:

 Administrators have control over user accounts and profiles.

 They can view user information, including contact details, order


history, and preferences.

 Ability to add new users, deactivate accounts, or resolve account-


related issues.

5. Cake Catalog Management:

 Administrators can manage the catalog of available cakes and cake


designs.

 They can add new cake designs, update descriptions, and adjust
pricing as needed.

 Ensure that the catalog is up-to-date with the latest offerings and
seasonal specials.

6. Reporting and Analytics:

 Generate reports on various aspects of the business, such as sales


performance, popular cake designs, customer feedback, etc.

 Analyze trends and patterns to make informed decisions for business


growth and improvement.

 Access to historical data for forecasting and planning purposes.

7. Communication Tools:

 Administrators can communicate with customers, suppliers, and other


stakeholders through built-in messaging or email functionalities.

 Address customer queries, resolve complaints, and provide support


as needed.

11 | P a g e
8. Security and Permissions:

 Implement security measures to safeguard sensitive information and


ensure data integrity.

 Role-based access control to restrict access to certain features and


functionalities based on user roles within the administrative team.

The administrative module plays a crucial role in the smooth operation of the
online cake ordering system, empowering administrators to efficiently manage the
platform and provide excellent service to customers.

Data Flow Diagram


Below is a simplified data flow diagram (DFD) for a Hospital Management System.
This diagram provides an overview of how data flows within the system, including
inputs, processes, data storage, and outputs.

Customer

Orders Cake
12 | P a g e
Enters order Details
(Cake selection
customization option)
13 | P a g e
14 | P a g e
This DFD outlines the flow of data and information within the online cake ordering
system:

1. Customer Interface: Customers interact with the system by placing orders


through the online interface. They provide details such as cake selection,
customization options, and delivery preferences.

2. Online Cake Ordering System: This component receives and processes


the order details from customers. It handles order processing, including
payment verification and inventory management.

3. Cake Management System: Manages the inventory of cakes and


ingredients. It ensures that there are enough supplies to fulfill orders and
updates stock levels accordingly.

4. Payment Processing System: Verifies payment details provided by


customers and processes transactions securely.

5. Customer Notification System: Notifies customers about their order


status, including confirmation, progress, and delivery updates.

6. Bakery Staff Notification System: Notifies bakery staff about new orders
and order details so they can prepare the cakes accordingly.

7. Delivery Staff Notification System: Notifies delivery staff about order


assignments, including delivery or pickup instructions.

This DFD illustrates the flow of information and interactions


between different components of the online cake ordering system, from order
placement to delivery or pickup.

15 | P a g e
System Diagram
Entity Relationship Diagram

Admin Role

admin_Id Role_Id

username name

password

Email

Role_id

Category
Cake
category_Id
cake_Id
name
name

description

prize

image_url

availability

16 | P a g e
17 | P a g e
Cake Order
Details
Admin Login Get Access

Customer
Details
Forgot Passwd

Cake Details
Check
Credentials

Delivery Manage Sys


Details Admin
Manage
Module
Delivery
Details Manage
Report
Manage user
Roles Manage user
Permission

In this diagram:

 Customer: Represents the customers who place orders. It includes


attributes like CustomerID (unique identifier), Name, Email, and Phone.

 Order: Represents the orders placed by customers. It includes attributes


such as OrderID (unique identifier), CustomerID (foreign key referencing
Customer table), CakeID (foreign key referencing Cake table), Quantity
(number of cakes ordered), and Status (order status like pending,
confirmed, delivered, etc.).

 Cake: Represents the different types of cakes available for ordering. It


includes attributes like CakeID (unique identifier), Name, Description, and
Price.

 This ER diagram illustrates the relationships between the entities Customer,


Order, and Cake in the online cake ordering system. Each customer can
place multiple orders, and each order can include one or more cakes. Each
cake can be associated with multiple orders.

18 | P a g e
DATABASE DESIGN
Entities:

19 | P a g e
1. Admin:

 admin_id (Primary Key)

 username

 password

 email

 role (to distinguish admin roles if there are different levels of access)

2. Cake:

 cake_id (Primary Key)

 name

 description

 price

 image_url

 availability (to mark if the cake is available for purchase or not)

3. Category:

 category_id (Primary Key)

 name

4. Order:

 order_id (Primary Key)

 customer_id (Foreign Key referencing a Customer table if you have


one)

 order_date

 total_price

 status (e.g., pending, processing, delivered)

5. OrderItem:

 order_item_id (Primary Key)

 order_id (Foreign Key referencing the Order table)

20 | P a g e
 cake_id (Foreign Key referencing the Cake table)

 quantity

 price

6. Customer:

 customer_id (Primary Key)

 username

 password

 email

 address

 phone_number

7. Feedback:

 feedback_id (Primary Key)

 customer_id (Foreign Key referencing the Customer table)

 message

 date

This is a basic schema to get you started. Depending on the specific requirements
of your project, you might need to expand or modify it. Additionally, don't forget to
establish relationships between the entities, like one-to-many relationships
between Order and OrderItem, Customer and Order, etc.

Table Name: Admin Login

FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTION


Id Int(20) Notnull Admin Id
Admin Name Varchar(100) Notnull Admin Name

21 | P a g e
Mobile Number Int(11) Notnull Mobile Number
Email Varchar(30) Notnull Email Id
Password Varchar(20) Notnull Password

Table Name: User Login

FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTION


Id Int(11) Notnull User Id
First Name Varchar(18) Notnull First Name
Last Name Int(15) Notnull Last Name
Email Varchar(30) Notnull Email Id
Password Varchar(20) Notnull Password

Table Name: Cake Detail

FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTION


Id Int(11) Notnull Cake Id
Category Name Varchar(18) Notnull Category Name
Item Name Varchar(15) Notnull Cake Name
Item Price Varchar(5) Notnull Cake Price
Item Des Varchar(80) Notnull Cake Description
Image Blob(5) Notnull Cake Image
Item Quantity Int(10) Notnull Cake Quantity

Table Name: Cake Order Detail

FIELD NAME DATA TYPE CONSTRAINTS DESCRIPTION


Id Int(20) Notnull Admin Id
User Id Varchar(25) Notnull User Name
Caked Id Varchar(25) Notnull Cake Id

22 | P a g e
Order Number Varchar(30) Notnull Order Number
Password Varchar(20) Notnull Payment Method

Input Design
1. Order Form:

 Name: Text input field for the customer's name.

 Email: Text input field for the customer's email address.

23 | P a g e
 Phone: Text input field for the customer's phone number.

 Address: Text input field for the delivery address.

 Delivery Date: Date picker for selecting the desired delivery date.

 Cake Selection: Dropdown menu or radio buttons for selecting the


desired cake from available options.

 Quantity: Text input field for specifying the quantity of cakes.

 Customization Options: Checkbox or dropdown menus for selecting


additional customization options like flavor, size, frosting, etc.

 Special Instructions: Text area for customers to provide any special


instructions or requests.

2. Registration/Login Form (Optional):

 Name: Text input field for the user's name.

 Email: Text input field for the user's email address.

 Password: Password input field for creating a new account or logging


in.

 Confirm Password: Password input field for confirming the password


during registration.

3. Admin Login Form (If applicable):

 Username: Text input field for the administrator's username.

 Password: Password input field for the administrator's password.

4. Cake Management Form (For Admin):

 Cake Name: Text input field for entering the name of the cake.

 Description: Text area for providing a brief description of the cake.

 Price: Text input field for specifying the price of the cake.

 Image Upload: File upload field for uploading an image of the cake.

 Add/Edit/Delete Buttons: Buttons for adding, editing, or deleting cake


listings.

5. Order Management Interface (For Admin):

24 | P a g e
 Filter Options: Dropdown menus or checkboxes for filtering orders
based on status (e.g., pending, confirmed, delivered).

 Order List: Table displaying order details including OrderID, Customer


Name, Order Date, Delivery Date, Status, etc.

 Order Details View: Clickable links or buttons to view detailed


information about each order, including customer details, cake
selection, quantity, customization options, etc.

 Update Status: Dropdown menu or checkboxes for updating the


status of orders (e.g., confirm, in progress, delivered).

6. Feedback Form:

 Name: Text input field for the customer's name.

 Email: Text input field for the customer's email address.

 Feedback: Text area for customers to provide feedback or comments


about their experience.

 Rating: Star rating system for customers to rate their satisfaction


(optional).

These input designs provide a user-friendly interface for customers to place


orders, register/login, provide feedback, and for administrators to manage cakes,
orders, and customer feedback efficiently. Adjustments can be made based on
specific project requirements and user preferences.

Output Design
1. Order Confirmation Page:

 Display a confirmation message confirming the successful placement


of the order.

 Include order details such as Order ID, Customer Name, Delivery


Date, and Total Amount.

 Provide a summary of the ordered cakes including their names,


quantities, and customization options.

2. Order Status Page:

25 | P a g e
 Allow customers to track the status of their orders.

 Display order details including Order ID, Order Date, Delivery Date,
and Current Status.

 Provide real-time updates on the status of the order (e.g., confirmed,


in progress, delivered).

3. Order History Page:

 Allow customers to view their order history.

 Display a list of past orders including Order ID, Order Date, Delivery
Date, and Status.

 Provide options to view detailed information about each order such as


cake selection, quantity, and customization options.

4. Cake Catalog Page:

 Display a catalog of available cakes with images, names,


descriptions, and prices.

 Allow customers to browse through different categories (e.g., birthday


cakes, wedding cakes, cupcakes).

 Include filtering and sorting options for ease of navigation.

5. User Profile Page:

 Display customer information such as Name, Email, Phone Number,


and Address.

 Provide options to edit or update user profile details.

 Show order history and status for easy reference.

6. Admin Dashboard:

 Provide a centralized dashboard for administrators to manage the


online cake shop.

 Display key metrics such as Total Orders, Total Revenue, and Order
Status Overview.

 Include tabs or sections for managing orders, cakes, customers, and


feedback.

26 | P a g e
7. Order Management Interface (Admin):

 Display a list of orders with details such as Order ID, Customer Name,
Order Date, Delivery Date, and Status.

 Provide options to filter and search orders based on various criteria.

 Allow administrators to update the status of orders and view detailed


order information.

8. Cake Management Interface (Admin):

 Display a list of cakes with details such as Cake ID, Name,


Description, Price, and Availability.

 Provide options to add, edit, or delete cakes from the catalog.

 Include features for managing cake inventory and uploading cake


images.

9. Feedback Management Interface (Admin):

 Display customer feedback and ratings.

 Allow administrators to view, respond to, and manage feedback.

 Provide options to filter feedback by rating or date.

These output designs provide a user-friendly interface for customers to place


orders, track order status, browse cakes, and manage their profiles, as well as for
administrators to manage orders, cakes, and customer feedback efficiently.

27 | P a g e
Conclusion and Enhancement
Conclusion
The Online cake shop system is designed to generate bills when customer orders
an item.

It has the facility to generate bills and only the authorized user can login in system
and view details of customers and items.

This application provides facility for adding customer details, adding item details
and it automatically calculates amount and generate bill.

It also provides Automation of the entire system improves the efficiency, it


provides a friendly graphical user interface which proves to be better when
compared to the existing system, updating of information becomes so easier.

The system has adequate scope for modification in future if it is necessary.

Scope for future development


Some of the Future Scope are Real Time Notification

28 | P a g e
 Reduction of paper work.
 Human effort or Manual Labor can be reduced drastically.
 Major operations that are done manually can be done within a matter of
seconds.
 This project enables the owner of shop to maintain database of customers
visited and purchase item from shop.

Screen Shots
Orders:

29 | P a g e
Dashboard

30 | P a g e
Cake Categories

31 | P a g e
Parcel Tracking

32 | P a g e
33 | P a g e

Common questions

Powered by AI

The use of GUI in the operational feasibility of the system enhances user interaction by providing visually intuitive input and output forms. It simplifies order processing, reduces the need for technical expertise, and ensures the system is self-explanatory to end-users, fostering ease of use and user acceptance .

The system architecture facilitates automated data capture for orders, which allows for reduced reliance on manual entry and processing of order details. Integrated forms and backend processing manage the input, storage, and retrieval of data seamlessly, allowing transactions to be completed with minimal manual intervention, enhancing overall productivity and reducing errors .

System flexibility is essential to accommodate future changes and adaptations without significant redevelopments. It ensures the system remains relevant and can integrate new features or accommodate evolving business requirements, thus protecting investment and maintaining long-term operational efficiency .

Error-free operations in the system mitigate data inaccuracies, prevent fraud, and ensure orders are managed correctly from entry to delivery. This reliability builds customer trust, improves service delivery, and ensures the business processes are efficient and fail-safe, contributing to customer satisfaction and retention .

For administrators, the system provides a centralized dashboard that includes options to manage orders, including viewing details, filtering, searching, and updating the status of each order. It enables efficient tracking and management of orders, crucial for coordinating logistics and enhancing customer service .

The main objectives of developing the online cake ordering system include managing the details of customer information, cake types, orders, payments, and shipping addresses. The application aims to reduce the manual work associated with these tasks, track detailed information about orders, and rectify problems in the current manual system. It's designed to ensure security, reliability, and user-friendliness, assisting in better organizational resource utilization .

The proposed system improves data security by ensuring that data accuracy is maintained and providing proper control by higher-level officials over data transactions. It minimizes manual data entry, which reduces chances of human error, and secures data handling through controlled access measures, such as admin login credentials, which were absent in the existing manual system .

The Entity-Relationship Diagram illustrates the relationships between primary entities such as Customer, Order, and Cake in the system. It defines how customers can place multiple orders, how each order can include multiple cakes, and highlights foreign key relationships among tables. This diagram is crucial for database design, ensuring cohesive and accurate data integration and retrieval within the system .

The feasibility study examines economic, technical, and operational aspects to determine the practicality of implementing the system. Economic feasibility considers cost-effectiveness, with expected benefits outweighing initial and running costs. Technical feasibility assesses whether system functionalities can be achieved with available technology. Operational feasibility ensures user-friendly GUI and proper training for ease of use. This study is crucial as it predicts the system's success and adapts it for future changes .

The proposed system enhances user efficiency by automating manual processes, thereby reducing time spent and errors in data entry. It allows users to concentrate on other essential activities beyond record-keeping, provides an accessible and interactive environment, and ensures tasks are completed with greater speed and accuracy .

You might also like