The Online Cake Ordering Management System is a database management system project that enables the management of orders, customers, products, and employees in a cake shop. Here are the complete details of the project:
Table of Contents
Overview
The Online Cake Ordering Management System is a web-based application designed to automate the processes involved in a cake shop. The system allows customers to browse through the available products and place orders online. The system also enables employees to manage orders, customers, and products efficiently.
Features
The Online Cake Ordering Management System has the following features:
Customer Management
- Customer Registration: Customers can register themselves on the system by providing their details like name, email address, phone number, and password.
- Customer Login: Registered customers can log in to the system using their email addresses and password.
- View Profile: Customers can view their profile details and edit them if necessary.
Product Management
- Product Management: Employees can add new products, update existing products, and delete products from the system.
- View Products: Customers can view the available products on the system along with their prices.
Order Management
- Place Order: Customers can place orders by selecting the desired products, specifying the quantity, and providing the delivery address.
- Order Tracking: Customers can track their orders and view the status of the orders.
- Manage Orders: Employees can manage the orders by accepting or rejecting them, updating the order status, and marking the orders as completed.
Employee Management
- Employee Registration: Employees can register themselves on the system by providing their details like name, email address, phone number, and password.
- Employee Login: Registered employees can log in to the system using their email address and password.
- View Profile: Employees can view their profile details and edit them if necessary.
Database Design
The database of the Online Cake Ordering Management System consists of the following tables:
Customers Table
- Customer ID (Primary Key)
- Name
- Email Address
- Phone Number
- Password
Products Table
- Product ID (Primary Key)
- Name
- Description
- Price
- Image URL
Orders Table
- Order ID (Primary Key)
- Customer ID (Foreign Key)
- Product ID (Foreign Key)
- Quantity
- Delivery Address
- Order Date
- Order Status
Employees Table
- Employee ID (Primary Key)
- Name
- Email Address
- Phone Number
- Password
Technologies Used
The Online Cake Ordering Management System is developed using the following technologies:
- Programming Language: PHP
- Database Management System: MySQL
- Web Technologies: HTML, CSS, JavaScript
Conclusion
The Online Cake Ordering Management System is an efficient way of managing the orders, customers, products, and employees in a cake shop. It automates the manual processes involved in a cake shop and makes the operations more streamlined and organized.