Dissertation Project
Dissertation Project
The rapid advancement of digital technologies has significantly transformed the retail industry by
enabling businesses to provide products and services through online platforms. Modern
consumers expect secure transactions, responsive user interfaces, personalized shopping
experiences, and seamless order management. To address these requirements, this project
presents "VAYU – A Scalable Full-Stack E-Commerce Platform for Digital Retail
Management," a comprehensive web-based application designed to provide a secure, efficient,
and user-friendly online shopping environment.
The platform enables customers to browse products, search across multiple categories, manage
shopping carts, maintain wishlists, place orders securely, and track order status through an
integrated web interface. The application incorporates secure payment processing, customer
account management, promotional offers, discount management, invoice generation, and
responsive design to ensure a consistent user experience across desktops, tablets, and mobile
devices.
The system follows a modular architecture in which individual components such as authentication,
product management, shopping cart, checkout, payment processing, customer accounts,
analytics, and administrative functions operate independently while remaining fully integrated.
This modular approach enhances maintainability, scalability, and future extensibility of the
platform.
Overall, the proposed system successfully addresses the major challenges faced by conventional
online retail platforms by combining usability, performance, security, and modern software
engineering principles into a unified digital commerce solution.
Keywords: E-Commerce, Digital Retail, Web Application, PHP, MySQL, HTML5, CSS3,
JavaScript, Responsive Design, Payment Gateway, Search Engine Optimization, Shopping Cart,
Wishlist, Customer Authentication.
1
CHAPTER 1: INTRODUCTION
1.1 INTRODUCTION
The emergence of the Internet has significantly transformed the way businesses interact with
customers and conduct commercial activities. Traditional retail stores have gradually evolved into
digital marketplaces where customers can browse products, compare prices, place orders, and
make secure online payments from anywhere at any time. This transformation has resulted in the
rapid growth of Electronic Commerce (E-Commerce), making it one of the fastest-growing sectors
in the digital economy.
An e-commerce platform is a web-based application that facilitates the buying and selling of
products or services over the Internet. It integrates various modules such as product
management, customer authentication, inventory management, shopping cart, order processing,
secure payment systems, customer support, and data analytics into a single unified system.
Modern e-commerce applications emphasize usability, security, scalability, and high performance
to provide an enhanced shopping experience.
The project "VAYU – A Scalable Full-Stack E-Commerce Platform for Digital Retail
Management" has been developed as a comprehensive web-based digital commerce solution.
The platform enables customers to explore products across multiple categories, search and filter
items, maintain wishlists, manage shopping carts, complete secure online transactions, and
monitor their order status through a responsive and intuitive user interface.
Unlike conventional static websites, the proposed platform is designed to automate various
business operations including product catalog management, discount administration, invoice
generation, customer authentication, promotional campaign management, order processing, and
customer engagement. The modular architecture adopted in this project ensures easier
maintenance, improved scalability, and future extensibility.
Over the last decade, the rapid increase in Internet accessibility and smartphone usage has
revolutionized consumer purchasing behavior. Customers increasingly prefer online shopping
because it offers convenience, wider product choices, competitive pricing, secure payment
options, and doorstep delivery.
The Indian e-commerce industry has experienced remarkable growth due to increased digital
adoption, affordable internet connectivity, government initiatives promoting digital payments, and
improvements in logistics infrastructure. Businesses of every scale are adopting digital commerce
platforms to expand their market reach beyond geographical limitations.
2
Despite this growth, many small and medium-scale businesses continue to face challenges such
as:
The development of VAYU is motivated by the objective of providing a scalable online retail
platform capable of supporting modern commerce functionalities while maintaining simplicity,
efficiency, and high performance.
1.3 MOTIVATION
The increasing demand for digital shopping platforms inspired the development of this project.
While several commercial e-commerce solutions exist, many businesses require customized
platforms that reflect their own branding, business strategies, and customer engagement
methods.
The project also serves as a practical implementation of software engineering concepts studied
during the [Link]. Computer Science curriculum.
Many existing online shopping platforms suffer from one or more of the following limitations:
In addition, businesses often rely on third-party marketplaces, reducing their control over
branding, customer relationships, and pricing strategies.
The scope of the proposed system covers the complete lifecycle of an online shopping platform,
beginning from customer registration and product browsing to secure payment processing and
order completion.
The system is designed to support future expansion with minimal architectural modifications.
The proposed system provides several advantages over conventional online shopping platforms.
Customer Benefits
Business Benefits
Efficient product management.
Simplified order management.
Better customer engagement.
Improved website visibility.
Performance optimization.
Data-driven decision making.
Enhanced branding opportunities.
Scalable architecture.
Apparel stores.
Lifestyle brands.
Fashion retailers.
Gift stores.
Merchandise businesses.
5
CHAPTER 2: LITERATURE REVIEW
2.1 INTRODUCTION
The rapid advancement of information technology has transformed traditional business models
into digital commerce ecosystems. Electronic Commerce (E-Commerce) has become one of the
fastest-growing sectors worldwide by enabling businesses to offer products and services through
web-based platforms. The widespread adoption of smartphones, high-speed internet, secure
digital payment systems, and cloud computing has significantly accelerated the growth of online
retail.
This chapter presents an overview of e-commerce, discusses various business models, analyzes
existing platforms, reviews related technologies, and identifies the research gap that motivated
the development of the proposed system.
Electronic commerce has evolved significantly over the last three decades. Initially, online
shopping websites offered only basic product catalogs with limited interaction and manual
payment processes. Over time, improvements in networking technologies, database systems,
cloud computing, and cybersecurity transformed these platforms into intelligent digital commerce
ecosystems capable of handling millions of transactions daily.
Generation Characteristics
First Generation (1990– Static web pages, limited product information, email-based
2000) communication
Second Generation (2000–
Dynamic websites, database integration, online payment systems
2010)
Third Generation (2010– Mobile commerce, responsive design, social media integration,
2020) cloud hosting
Fourth Generation (2020– AI-driven recommendations, real-time analytics, personalization,
Present) digital wallets, automation
Electronic commerce can be categorized into different business models depending upon the
participating entities.
Business-to-Consumer is the most common form of e-commerce where businesses directly sell
products or services to customers through an online platform.
Examples:
Amazon
Flipkart
Myntra
AJIO
The proposed system, VAYU, also follows the Business-to-Consumer (B2C) model.
In this model, commercial transactions occur between two businesses rather than between
businesses and individual consumers.
Examples include:
Alibaba
IndiaMART
TradeIndia
Examples:
OLX
eBay
Facebook Marketplace
Freelancer
Fiverr
Upwork
A study of leading e-commerce platforms was conducted to understand modern digital commerce
practices and identify features that contribute to customer satisfaction and operational efficiency.
Amazon
Amazon is the world's largest online marketplace offering millions of products across various
categories. It provides advanced product search, personalized recommendations, one-click
purchasing, secure payment systems, customer reviews, and AI-driven product suggestions.
Strengths
Limitations
Flipkart
Flipkart is one of India's largest e-commerce companies specializing in electronics, fashion, and
lifestyle products. The platform offers responsive design, multiple payment methods, exchange
offers, and personalized recommendations.
Strengths
Easy navigation
Fast checkout
Mobile-first design
Attractive promotional campaigns
Limitations
8
Limited customization for independent brands
Dependence on marketplace policies
Myntra
Myntra specializes in fashion and lifestyle products with emphasis on product visualization and
customer engagement.
Strengths
Limitations
Category-specific platform
Marketplace dependency
Shopify
Shopify enables businesses to create customized online stores with complete administrative
control over products, customers, and branding.
Strengths
Limitations
Subscription cost
Technical customization may require expertise
9
2.5 COMPARATIVE STUDY OF EXISTING SYSTEMS
These challenges create a need for an independent digital commerce platform that provides
complete administrative control while maintaining modern e-commerce functionality.
The proposed platform, VAYU, has been designed to overcome the limitations identified during
the literature review.
By combining these functionalities, the proposed system delivers a scalable, maintainable, and
user-centric digital commerce solution suitable for modern online businesses.
11
CHAPTER 3: REQUIREMENT ANALYSIS
3.1 INTRODUCTION
Requirement Analysis is one of the most important phases of the Software Development Life
Cycle (SDLC). It involves identifying, analyzing, documenting, and validating all functional and
non-functional requirements necessary for successful development of a software system.
A well-defined requirement analysis ensures that the developed system satisfies user
expectations while maintaining security, scalability, maintainability, and performance.
For the proposed project "VAYU – A Scalable Full-Stack E-Commerce Platform for Digital
Retail Management," the requirement analysis focuses on understanding customer needs,
business requirements, administrator functionalities, technical constraints, and overall system
objectives.
The system has been designed to automate online retail operations by providing a secure,
responsive, and efficient digital shopping environment for customers while simplifying
administrative operations.
The requirements of the proposed system were identified through careful analysis of modern e-
commerce platforms, business workflows, customer expectations, and digital retail practices.
The collected requirements were categorized into Functional Requirements and Non-Functional
Requirements.
Product Management
Category Management
Inventory Management
Order Management
Customer Management
Coupon Management
Discount Configuration
Website Content Management
Analytics Monitoring
Payment Monitoring
Performance Optimization
3.3.2 Customer
User Registration
Login
Google Sign-In
Product Search
Product Browsing
Wishlist Management
Shopping Cart Management
Secure Checkout
Online Payment
Order Tracking
Profile Management
Review Submission
The major functional requirements of the proposed system are listed below.
Functions:
13
User Registration
Secure Login
Google Authentication
Password Recovery
Session Management
Functions:
Add Products
Update Products
Delete Products
Category Management
Product Variations
Product Images
Functions:
Keyword Search
Category Search
Product Filtering
Sorting
Functions:
Add to Cart
Remove Product
Quantity Update
Cart Summary
Shipping Calculation
Wishlist Module
Functions:
Save Products
Remove Products
Move Product to Cart
14
Checkout Module
Functions:
Billing Details
Shipping Details
Coupon Application
Order Summary
Payment Selection
Payment Module
Functions:
Razorpay Integration
UPI
Debit Card
Credit Card
Wallet
Net Banking
COD
Functions:
Place Order
Order Confirmation
Order History
Order Tracking
Invoice Generation
Customer Dashboard
Functions:
View Profile
Update Address
View Orders
Track Orders
Logout
Contact Module
15
Functions:
Contact Form
Customer Support
Business Information
Analytics Module
Functions:
Visitor Tracking
Product Analytics
Conversion Tracking
Customer Behaviour Analysis
SEO Module
Functions:
XML Sitemap
Meta Tags
URL Optimization
Structured Data
Module Description
Authentication User Login, Registration & Google Sign-In
Product Management Product Listing & Categories
Shopping Cart Product Selection
Wishlist Save Favourite Products
Checkout Billing & Shipping
Payment Secure Online Payment
Order Management Order Processing
Customer Dashboard User Account
Analytics Visitor Tracking
SEO Search Optimization
Contact Customer Support
16
3.6 NON-FUNCTIONAL REQUIREMENTS
Non-functional requirements describe how the system performs its operations.
Performance
The website should load quickly with optimized images, caching, and compressed resources.
Reliability
Scalability
The architecture should support future expansion with increasing products, customers, and traffic.
Security
The system should provide secure authentication, encrypted communication, secure payment
processing, and protected customer information.
Availability
Maintainability
Portability
The website should work efficiently across multiple operating systems and browsers.
Usability
17
The user interface should be simple, intuitive, and easy to navigate.
Responsiveness
Desktop
Laptop
Tablet
Smartphone
Component Specification
Processor Intel Core i3 or above
RAM 4 GB Minimum (8 GB Recommended)
Storage 20 GB Free Space
Internet Broadband Connection
Display 1366 × 768 Resolution
18
3.8 SOFTWARE REQUIREMENTS
Software Purpose
Operating System Windows / Linux
PHP Server-side Processing
MySQL Database
HTML5 Page Structure
CSS3 Styling
JavaScript Client-side Interaction
Apache / Nginx Web Server
Google Chrome Testing
Visual Studio Code Development
Git Version Control
Before developing any software system, it is necessary to evaluate whether the proposed solution
is feasible from technical, economic, and operational perspectives.
Technical Feasibility
The proposed system uses widely adopted technologies such as HTML5, CSS3, JavaScript, PHP,
MySQL, and modern web application frameworks. These technologies are reliable, scalable, well-
documented, and supported by a large developer community.
Economic Feasibility
The proposed platform minimizes operational costs by automating several business processes
including order management, customer interaction, promotional campaigns, and payment
processing.
The development cost is relatively low compared to commercial enterprise solutions, making the
system economically feasible.
Operational Feasibility
The application provides an intuitive interface for both administrators and customers.
19
The automated workflows simplify product management, customer interactions, order processing,
and payment management, making the system operationally efficient.
3.11 SUMMARY
This chapter presented the detailed requirement analysis of the proposed e-commerce platform.
Functional requirements, non-functional requirements, software and hardware requirements, user
roles, feasibility study, and system constraints were discussed in detail.
The analysis confirms that the proposed system satisfies modern digital commerce requirements
while ensuring security, scalability, maintainability, and high performance.
The next chapter focuses on the complete system design and architecture, including diagrams
that illustrate the internal workflow and interaction between various modules of the platform.
20
CHAPTER 4: SYSTEM DESIGN &
ARCHITECTURE
4.1 INTRODUCTION
System Design is one of the most critical phases of software development. It translates the
requirements gathered during system analysis into a structured blueprint that guides the
implementation of the software system. A well-designed architecture ensures that the application
remains scalable, secure, maintainable, and efficient while allowing future enhancements with
minimal modifications.
The proposed project, "VAYU – A Scalable Full-Stack E-Commerce Platform for Digital
Retail Management," follows a modular architecture in which every major functionality is
implemented as an independent module. This modular approach improves code maintainability,
simplifies debugging, enhances security, and allows individual modules to be upgraded without
affecting the overall system.
The architecture consists of multiple interconnected layers that work together to provide seamless
communication between users, application logic, database, and third-party services.
Presentation Layer
Business Logic Layer
Database Layer
External Service Layer
Each layer performs a specific responsibility, resulting in improved software organization and
better overall system performance.
The proposed system follows a layered architecture where the customer interacts with the web
interface, which communicates with the application layer. The application layer processes user
requests, retrieves or stores information in the database, and communicates with external
services such as payment gateways, email servers, and authentication providers.
21
Figure 4.1 Overall System Architecture
+--------------------------------------------+
| CUSTOMER |
|----------------------------------------------|
| Desktop / Laptop / Mobile Device |
+----------------+-----------------+--------+
|
|
▼
+---------------------------------------------------------------+
| PRESENTATION LAYER (Frontend) |
|-----------------------------------------------------------------
| Home | Shop | Search | Cart | Wishlist |
| Checkout | My Account | Track Order |
+----------------+------------------------------+--------------+
▼
+-------------------------------------------------------+
| APPLICATION / BUSINESS LAYER |
|--------------------------------------------------------+
| User Authentication |
| Product Management |
| Cart Management |
| Wishlist |
| Order Processing |
| Discount Engine |
| Checkout Management |
| Payment Processing |
+----------------+-------------------------------------+
|
▼
+-----------------------------------------------+
| DATABASE LAYER |
|------------------------------------------------|
| Users |
| Products |
| Categories |
| Orders |
| Payments |
| Wishlist |
| Coupons |
| Reviews |
+----------------+-----------------------------+
|
▼
+-------------------------------------------------------------+
| THIRD-PARTY SERVICE LAYER |
|--------------------------------------------------------------|
| Razorpay Payment Gateway |
| Google Authentication |
| SMTP Email Service |
| Analytics & SEO |
+------------------------------------------------------------+
22
4.3 SYSTEM COMPONENTS
The proposed system consists of four major architectural components.
The Presentation Layer acts as the interface between the user and the application. It is
responsible for displaying information and collecting user input through interactive web pages.
Homepage
Product Catalogue
Product Search
Product Details
Shopping Cart
Wishlist
Checkout
Customer Dashboard
Contact Page
About Page
The interface is fully responsive and automatically adjusts according to different screen sizes.
The Business Logic Layer acts as the core processing unit of the application. It validates user
requests, processes transactions, manages products, calculates discounts, handles orders, and
communicates with the database.
User Authentication
Product Management
Shopping Cart
Wishlist
Checkout Processing
Order Management
Payment Processing
Discount Management
Customer Management
Analytics
This layer ensures that business rules are applied consistently across the application.
Customer Information
Product Catalogue
Categories
Product Variations
Orders
Transactions
Coupons
Wishlist Items
Customer Reviews
Website Configuration
Modern e-commerce applications rely on external services to extend their capabilities. The
proposed system integrates several trusted third-party services for secure and efficient operation.
These include:
The integration of these services improves customer experience while reducing implementation
complexity.
The overall workflow of the application begins when a customer visits the website. The user can
browse products, search for specific items, add products to the wishlist or shopping cart, proceed
to checkout, complete payment, and receive order confirmation.
24
Figure 4.2 System Workflow
Customer Visits Website
│
▼
Browse Products
│
▼
Search / Filter Products
│
▼
View Product Details
│
▼
Add to Cart / Wishlist
│
▼
Login / Register
│
▼
Checkout
│
▼
Payment Processing
│
▼
Order Confirmation
│
▼
Track Order
The proposed system has been designed by considering modern software engineering principles.
The major characteristics include:
Scalability
The modular architecture allows future expansion without affecting existing functionalities.
Security
The application implements secure authentication, encrypted payment processing, and protected
user sessions.
Reliability
The system ensures consistent operation under normal business conditions while maintaining
data integrity.
Maintainability
25
Independent modules simplify software maintenance and future enhancements.
Performance
The platform utilizes optimized content delivery, caching mechanisms, responsive layouts, and
resource optimization to improve loading speed and user experience.
Availability
The web application is designed to provide continuous service availability, enabling customers to
access products and services at any time.
4.6 INTRODUCTION
For the proposed e-commerce platform, UML diagrams have been designed to represent user
interactions, data movement, order processing, and system behavior. These diagrams simplify
system understanding and improve software maintainability.
The Use Case Diagram illustrates the interaction between different users and the proposed
system. The application has two primary actors:
Customer
Administrator
The customer performs shopping-related activities, whereas the administrator manages the
overall website operations.
26
VAYU SYSTEM
Explanation
The Use Case Diagram shows that customers interact with the website to perform shopping
activities such as product browsing, searching, adding items to the cart, managing wishlists,
completing secure payments, and tracking orders.
A Level-0 Data Flow Diagram provides a high-level overview of the complete system by showing
how data flows between external entities and the main software system.
27
Figure 4.4 DFD Level 0
+----------------------+
| CUSTOMER |
+----------+-----------+
|
| Product Request
|
▼
+-----------------------------+
| VAYU SYSTEM |
+----------+-----------------+
|
---------------------------------------------
| | | |
▼ ▼ ▼ ▼
Product DB User DB Order DB Payment Gateway
▲ ▲ ▲ ▲
| | | |
---------------------------------------------
|
▼
Order Confirmation
|
▼
CUSTOMER
Explanation
The customer sends requests to the system for product browsing, authentication, and order
placement. The application communicates with various databases and external payment services
to process transactions and finally returns order confirmation to the customer.
The Level-1 DFD provides a detailed representation of the internal processing modules of the
proposed system.
28
Figure 4.5 DFD Level 1
Customer
|
▼
User Authentication
|
▼
Product Browsing
|
▼
Search & Filter
|
▼
Product Selection
|
▼
Shopping Cart
|
▼
Checkout
|
▼
Payment Gateway
|
▼
Order Processing
|
▼
Invoice Generation
|
▼
Order Tracking
Explanation
This diagram illustrates the complete customer purchase cycle. The process starts with
authentication, followed by browsing and searching products. After product selection, customers
manage their shopping cart, complete checkout, make secure payments, and finally receive order
confirmation with invoice generation and order tracking.
The Activity Diagram represents the sequence of operations performed during online shopping.
29
Figure 4.6 Activity Diagram
Start
|
▼
Visit Website
|
▼
Browse Products
|
▼
Search Product
|
▼
View Product
|
▼
Add to Cart?
|
Yes
|
▼
Login/Register
|
▼
Proceed to Checkout
|
▼
Select Payment Method
|
▼
Payment Successful?
|
Yes
|
▼
Generate Order
|
▼
Send Confirmation
|
▼
Track Order
|
▼
End
Explanation
The activity begins when a customer visits the website and browses products. After selecting
products, the customer logs into the system, proceeds through checkout, completes payment,
and receives confirmation. The process concludes with order tracking.
30
4.11 SEQUENCE DIAGRAM
Explanation
The Sequence Diagram shows the interaction among the customer, website, database, shopping
cart, payment gateway, and order management module. Each component communicates in
sequence until the order is successfully processed.
The UML diagrams prepared for the proposed system provide several advantages:
31
Better understanding of system architecture.
Improved communication among developers.
Simplified software maintenance.
Easier debugging and testing.
Improved documentation.
Faster future enhancements.
Better project visualization.
Reduced software complexity.
4.13 SUMMARY
This section presented the UML representation of the proposed e-commerce platform. The Use
Case Diagram, Data Flow Diagrams, Activity Diagram, and Sequence Diagram collectively
illustrate how customers interact with the application, how data flows through different modules,
and how transactions are processed.
These models provide a comprehensive blueprint of the proposed system and establish the
foundation for database design and implementation discussed in the subsequent section.
4.14 INTRODUCTION
Database design plays a vital role in the successful implementation of any web-based application.
A properly designed database ensures efficient storage, retrieval, and management of data while
maintaining consistency, integrity, and security.
The proposed e-commerce platform utilizes a relational database architecture in which different
entities such as users, products, orders, payments, categories, wishlists, and reviews are
interconnected through relational mappings. The database has been designed following
normalization principles to reduce redundancy and improve query performance.
Apart from database architecture, this section also describes the navigation structure, customer
purchase workflow, and administrator workflow of the proposed system.
The Entity Relationship (ER) Diagram represents the relationship among different database
entities used in the proposed system.
Users
Products
Categories
Orders
Order Items
Payments, Wishlist & Reviews
32
Figure 4.8 Entity Relationship Diagram
+--------------------+
| USERS |
+--------------------+
| User_ID (PK) |
| Name |
| Email |
| Phone |
| Password |
+-------+-----------+
|
|
Places Order
|
▼
+--------------------+
| ORDERS |
+--------------------+
| Order_ID (PK) |
| User_ID (FK) |
| Payment_ID |
| Status |
| Date |
+-------+------------+
|
|
|
▼
+-------------------------+
| ORDER ITEMS |
+-------------------------+
| Product_ID (FK) |
| Quantity |
| Price |
+----------+-------------+
|
|
▼
+----------------------+
| PRODUCTS |
+----------------------+
| Product_ID(PK) |
| Category_ID |
| Name |
| Price |
| Stock |
+-------+------------+
|
|
▼
+-----------------------+
| CATEGORIES |
+-----------------------+
| Category_ID |
| Category Name |
+----------------------+
33
Users -------------------- Wishlist ---------------- Products
Explanation
The ER Diagram illustrates the relationships among various entities within the application.
Each customer can place multiple orders, while every order may contain one or more products.
Products belong to specific categories and can be added to wishlists or reviewed by customers.
Payment records are linked with orders to maintain transaction details.
This relational architecture minimizes data redundancy while ensuring efficient retrieval of
information.
The database stores information related to customers, products, orders, payments, reviews,
promotional offers, and administrative activities.
Each table has been designed with appropriate primary keys and foreign key relationships to
maintain consistency and improve query performance.
The normalization process ensures efficient data retrieval while maintaining consistency
throughout the database.
The navigation flow represents how customers move from one page to another during their
shopping journey.
35
Figure 4.9 Website Navigation Flow
HOME PAGE
│
┌──────────────────────┼───────────────────────┐
▼ ▼ ▼
Shop Page Offers Page About Page
│ │
▼ ▼
Product Categories Promotional Offers
│
▼
Product Details
│
▼
Add to Cart
│
▼
Shopping Cart
│
▼
Login / Register
│
▼
Checkout
│
▼
Payment Gateway
│
▼
Order Confirmation
│
▼
My Account
│
▼
Track Order
Explanation
The navigation structure has been designed to minimize user effort while completing an online
purchase.
Customers begin from the homepage, browse product categories, view product details, add
products to the shopping cart, complete checkout, make payment, and finally track their orders
through the customer dashboard.
The navigation structure reduces unnecessary page transitions and improves overall user
experience.
36
4.19 CUSTOMER PURCHASE WORKFLOW
The customer purchase workflow illustrates the complete purchasing cycle.
37
├────────► Product Management
│
├────────► Category Management
│
├────────► Order Management
│
├────────► Customer Management
│
├────────► Coupon Management
│
├────────► Analytics
│
├────────► Website Configuration
│
▼
Logout
38
CHAPTER 5: TECHNOLOGIES USED
5.1 INTRODUCTION
The selection of these technologies was based on factors such as reliability, compatibility,
scalability, security, ease of maintenance, and industry adoption.
The overall technology stack has been designed to support efficient product management, secure
transactions, customer authentication, responsive user interfaces, analytics, and search engine
optimization.
5.3 HTML5
HTML5 (HyperText Markup Language Version 5) is the standard markup language used for
designing and structuring web pages. It provides the basic framework for presenting content on
the website and supports multimedia, semantic elements, and modern web standards.
Advantages
Semantic structure
Cross-browser compatibility
Better SEO support
Multimedia integration
Responsive page structure
5.4 CSS3
CSS3 (Cascading Style Sheets) is responsible for the visual presentation of the website. It
defines the layout, colors, typography, animations, responsiveness, and overall appearance of
the web application.
CSS3 has been used extensively to create a professional, modern, and responsive user interface.
Responsive layouts
Product cards
Navigation menu
Buttons
Forms
Animations
Grid layouts
Mobile optimization
Advantages
Attractive UI
Faster page rendering
Improved responsiveness
Better user experience
Reusable styling
5.5 JAVASCRIPT
JavaScript is the client-side scripting language responsible for making the website interactive.
It allows the web pages to respond dynamically without requiring complete page reloads.
40
In the proposed project, JavaScript is used for:
Interactive navigation
Product image gallery
Cart updates
Form validation
Dynamic filtering
User interaction
Search functionality
Responsive menus
Advantages
Dynamic content
Better user experience
Reduced server requests
Interactive interface
Faster response
5.6 PHP
PHP (Hypertext Preprocessor) is the server-side scripting language responsible for processing
business logic and communicating with the database.
User authentication
Session management
Product retrieval
Order processing
Checkout
Payment verification
Customer dashboard
Database communication
PHP provides secure server-side execution while supporting modular and scalable application
development.
Advantages
Open-source
Fast execution
Easy database integration
Secure server-side processing
Cross-platform compatibility
5.7 MySQL
41
MySQL is the relational database management system used for storing and managing application
data.
Customer information
Products
Categories
Orders
Payments
Wishlist
Coupons
Reviews
Contact messages
The database has been designed using relational architecture to ensure consistency and
minimize redundancy.
Advantages
High performance
Reliable
Secure
ACID compliance
Easy scalability
It acts as an interface between the client browser and the server-side application.
The proposed application utilizes WordPress as the underlying content management framework
to simplify website administration and content organization. WordPress provides a robust
architecture for managing pages, media assets, user roles, menus, and configuration settings
while allowing the application to be extended through modular components.
42
Within this project, WordPress serves as the application foundation by enabling efficient
management of website content, products, and user interactions without affecting the overall
system architecture.
Major Benefits
Simplified content management
Secure user role management
Extensible architecture
Efficient media handling
Easy maintenance and updates
WooCommerce functions as the core commerce engine responsible for handling business
operations within the application.
Product management
Category management
Shopping cart
Checkout
Order processing
Inventory management
Coupon management
Customer accounts
Reports
WooCommerce enables seamless integration between the application interface and the
underlying commerce workflow.
Advantages
Modular architecture
Scalable commerce engine
Flexible product management
Secure order processing
Large extension ecosystem
Elementor has been utilized to design responsive and visually consistent user interfaces
throughout the website. It allows efficient layout management while maintaining responsive
behavior across multiple devices.
43
Responsive page layouts
Reusable design components
Mobile-friendly interfaces
Improved visual consistency
Faster UI development
Responsive Web Design ensures that the website automatically adapts to different screen sizes
and devices.
Desktop computers
Laptops
Tablets
Smartphones
Benefits
Improved accessibility
Better customer experience
Mobile compatibility
Reduced maintenance
5.13 SUMMARY
This chapter presented the major technologies used in the development of the proposed e-
commerce platform. Each technology contributes to a specific layer of the application, collectively
providing a secure, scalable, responsive, and maintainable digital commerce solution.
The next section explains the third-party services, APIs, authentication mechanisms, analytics,
search engine optimization, payment gateway integration, email services, and performance
optimization techniques that further enhance the capabilities of the proposed system.
44
5.14 AUTHENTICATION SYSTEM
Authentication is one of the fundamental security mechanisms of any e-commerce application. It
ensures that only authorized users can access personalized services such as order history,
wishlists, customer profiles, and checkout functionality.
The Google Sign-In feature simplifies the registration and login process by allowing users to
authenticate using their existing Google accounts. This reduces the need to remember additional
passwords while improving user convenience and security.
User Registration
Secure Login
Google Authentication
Session Creation
Session Validation
Logout
Password Recovery
Advantages
Secure authentication
Faster registration process
Reduced password dependency
Improved customer experience
Simplified account management
The proposed application integrates the Razorpay Payment Gateway, which supports multiple
payment methods through a single unified interface.
Payment Initialization
Secure Transaction Processing
Payment Verification
Order Confirmation
Transaction Record Storage
Customer Notification
Advantages
The Customer Account Module provides personalized services for registered users.
After successful authentication, customers can access a dedicated dashboard that enables them
to manage their shopping activities efficiently.
Profile Management
Address Management
Order History
Wishlist Management
Password Update
Account Details
Logout Functionality
This centralized dashboard improves usability by allowing customers to monitor all their activities
from a single location.
The Shopping Cart Module temporarily stores products selected by customers before order
placement.
Add products
Remove products
Modify quantity
Calculate total price
46
Apply promotional coupons
Continue shopping
Proceed to checkout
The shopping cart automatically updates the order summary whenever changes are made,
ensuring accurate pricing throughout the purchase process.
Benefits
Improved shopping convenience
Dynamic order calculation
Reduced checkout complexity
Better user interaction
The Wishlist Module allows customers to save products for future purchases.
Instead of immediately adding products to the shopping cart, users can bookmark products for
later consideration.
Save products
Remove saved products
Move items directly to cart
Personalized product collection
Quick product comparison
The Checkout Module is responsible for collecting customer information and processing orders
securely.
The checkout process has been designed to minimize unnecessary steps while ensuring
sufficient information is collected for successful order fulfillment.
Billing Information
Shipping Address
Contact Details
Coupon Application
Order Summary
Payment Method Selection
Order Confirmation
47
A simplified checkout process contributes to lower cart abandonment rates and improved
customer satisfaction.
The Order Management Module automates the complete order lifecycle from order placement to
delivery tracking.
Order Creation
Payment Verification
Invoice Generation
Order Status Update
Order History Management
Order Tracking
Customers receive immediate confirmation after successful order placement, while administrators
can efficiently manage incoming orders through the administrative interface.
Search Engine Optimization (SEO) improves the visibility of websites on search engines by
optimizing website structure, metadata, URLs, and page content.
These techniques improve search engine indexing and enhance the discoverability of products.
Benefits
Increased organic traffic
Better search rankings
Improved product visibility
Enhanced website credibility
48
Analytics plays an important role in understanding customer behavior and website performance.
Website Visitors
Product Views
Customer Sessions
Conversion Rate
User Navigation
Device Information
Traffic Sources
The collected data assists administrators in making informed business decisions and improving
customer experience.
The application integrates an SMTP-based email notification system for reliable communication
with customers.
User Registration
Password Recovery
Order Confirmation
Payment Confirmation
Invoice Delivery
Account Notifications
This ensures that customers remain informed throughout the shopping process.
Website performance directly influences customer satisfaction, search engine rankings, and
conversion rates.
The proposed application incorporates several optimization techniques to improve loading speed
and overall efficiency.
Server-side caching
Browser caching
Image optimization
Content Delivery Network (CDN)
Lazy Loading
Minification of CSS and JavaScript
GZIP Compression
49
Critical Resource Optimization
These techniques significantly reduce page loading time while improving Core Web Vitals.
Security has been given high priority during the development of the proposed application.
User Authentication
Session Management
Secure Password Storage
HTTPS Communication
Payment Gateway Security
Input Validation
Spam Protection
Secure Checkout Process
Role-Based Access Control
These measures help protect customer information, prevent unauthorized access, and ensure
secure financial transactions.
The following table summarizes the major software components integrated within the proposed
system.
Component Purpose
Authentication Module User Login and Google Sign-In
Product Management Product Catalog Administration
Shopping Cart Temporary Product Storage
Wishlist Save Products for Future Purchase
Checkout System Order Placement
Payment Gateway Secure Online Transactions
Analytics Customer Behaviour Analysis
SEO Engine Search Visibility
Email System Automated Notifications
Performance Engine Speed Optimization
Security Module Data Protection
50
CHAPTER 6: SYSTEM IMPLEMENTATION &
FUNCTIONAL MODULES
6.1 INTRODUCTION
The implementation phase is the stage where the system design is transformed into a fully
functional software application. During this phase, all planned modules are integrated to provide a
complete e-commerce platform capable of handling customer interactions, product management,
order processing, secure payment, and administrative operations.
The proposed platform has been implemented using a modular architecture, where each
functional component operates independently while maintaining seamless communication with
other modules. This approach improves maintainability, scalability, and overall system
performance.
The application provides customers with an intuitive shopping experience while offering
administrators complete control over products, orders, promotions, and customer management.
Homepage Module
Product Management Module
Search Module
Customer Authentication Module
Wishlist Module
Shopping Cart Module
Checkout Module
Payment Processing Module
Order Management Module
Customer Dashboard
Contact Module
About Module
Offer Management Module
Objective
The Homepage serves as the entry point of the website and provides visitors with an overview of
the platform, featured products, promotional offers, and easy navigation to different sections of
the application.
It has been designed to create a visually appealing first impression while allowing users to quickly
access important information and product categories.
51
Features
Working
The system retrieves product categories, featured products, promotional offers, and navigation
menus from the database. Customers can browse categories directly or use the search bar to
locate products.
The homepage also provides quick access to customer account management, shopping cart,
wishlist, and promotional offers.
Advantages
User-friendly interface
Easy navigation
Responsive design
Attractive product presentation
Quick access to important pages
52
6.3 PRODUCT MANAGEMENT MODULE
Objective
The Product Management Module is responsible for displaying products and organizing them into
appropriate categories. It enables customers to browse available products efficiently while
allowing administrators to manage the product catalogue.
Features
Product listing
Product categorization
Product variations
Multiple product images
Product pricing
Product availability
Product description
Featured products
Working
Products are stored in the database with associated information such as category, pricing, stock
availability, product description, and images.
Whenever customers browse the shop page, the system retrieves product information
dynamically and displays it according to the selected category or search criteria.
The module supports product variations such as size and color wherever applicable.
Advantages
Easy product browsing
Organized product categories
Dynamic product updates
Better customer experience
Objective
The Product Details Module provides comprehensive information about an individual product,
enabling customers to make informed purchasing decisions.
53
Features
Product name
Product images
Product description
Product specifications
Product price
Product variations
Availability status
Wishlist button
Add-to-cart button
Related products
Working
When a customer selects a product, the application retrieves complete product information from
the database and displays it on the product details page.
Customers can choose available product variations, add the product to their shopping cart, or
save it to their wishlist.
Advantages
Complete product information
Better purchasing decisions
Interactive product presentation
Improved customer engagement
Objective
The Search Module enables customers to quickly locate products based on keywords, categories,
or browsing preferences.
Efficient product discovery significantly improves user experience and reduces the time required
to locate desired products.
Features
Keyword search
Category filtering
54
Product sorting
Dynamic search results
Responsive search interface
Working
The search module compares customer search queries with product information stored in the
database.
The filtering functionality further allows customers to narrow results according to selected
categories.
Advantages
Faster product discovery
Improved navigation
Better customer satisfaction
Reduced browsing time
Objective
The Offer Management Module is designed to display promotional campaigns, discount offers,
and limited-time deals to customers.
This module plays an important role in improving customer engagement and increasing sales.
Features
Promotional banners
Coupon offers
Product discounts
Category discounts
Limited-time campaigns
Featured offers
Working
The system automatically displays active promotional campaigns configured by the administrator.
55
Customers can view available discounts before proceeding to checkout.
Advantages
Improved customer engagement
Increased sales
Better promotional visibility
Simplified offer management
Objective
The Contact Module enables customers to communicate directly with the business regarding
enquiries, support requests, or product-related questions.
Features
Contact form
Email communication
Business contact details
Customer support
Social media links
Working
The submitted information is securely transmitted to the administrator through the integrated
email notification system.
Advantages
Easy communication
Customer support
Improved customer satisfaction
Reliable enquiry management
56
6.8 ABOUT MODULE
Objective
The About Module provides information about the organization, its mission, vision, objectives, and
brand identity.
This module helps build customer trust by presenting authentic information about the platform.
Features
Company introduction
Vision
Mission
Brand story
Contact information
Social media links
Working
The About page presents static organizational information stored within the application and
serves as an informative section for customers.
Advantages
Improves brand credibility
Builds customer trust
Provides organizational transparency
6.9 SUMMARY
This section presented the implementation of the core customer-facing modules of the proposed
e-commerce platform. The Homepage, Product Management, Product Details, Search, Offer
Management, Contact, and About modules collectively provide an intuitive and responsive
interface that enables customers to discover products, access information, and interact effectively
with the platform.
The modular implementation ensures that each component performs a dedicated function while
remaining integrated with the overall application architecture, resulting in improved maintainability,
scalability, and user experience.
57
6.10 USER AUTHENTICATION MODULE
Objective
The User Authentication Module is responsible for verifying customer identity before allowing
access to personalized services such as order history, wishlist management, secure checkout,
and account settings. It ensures that only authorized users can access sensitive information while
maintaining data privacy and system security.
Features
User Registration
Secure Login
Google Sign-In
Forgot Password
Session Management
Logout
Profile Authentication
Working
New users can create an account by providing their basic details such as name, email address,
and password. Existing users can log in using their registered credentials or authenticate directly
through their Google account using OAuth authentication.
Once authentication is successful, the system creates a secure user session and redirects the
customer to the personalized dashboard. The session remains active until the user logs out or the
session expires.
Advantages
Secure customer authentication
Faster login using Google
Personalized shopping experience
Protected customer information
Simplified account management
Objective
58
The My Account Module provides registered customers with a centralized dashboard to manage
their profile and shopping activities.
Features
View Profile
Edit Account Information
Manage Addresses
Order History
Wishlist Access
Password Update
Logout
Working
After successful authentication, customers are redirected to the account dashboard where all
account-related operations can be performed. The dashboard retrieves customer information
directly from the database and displays it in a structured manner.
The module enables customers to update personal information, manage addresses, review
previous purchases, and monitor account activity.
Advantages
Centralized account management
Easy profile updates
Convenient order tracking
Improved customer experience
Objective
The Wishlist Module allows customers to save products for future purchase without adding them
directly to the shopping cart.
Features
Add Products to Wishlist
Remove Products
Move Products to Cart
59
Personalized Product Collection
Persistent Wishlist
Working
Customers can save products while browsing the website. Wishlist information is associated with
the customer's account and remains available across future sessions.
Products stored in the wishlist can later be transferred directly to the shopping cart for checkout.
Advantages
Improved customer engagement
Encourages future purchases
Personalized shopping experience
Simplified product management
Objective
The Shopping Cart Module temporarily stores products selected by customers before completing
the purchase process.
Features
Add Products
Remove Products
Update Quantity
Display Order Summary
Coupon Application
Proceed to Checkout
Working
Whenever customers add products to the cart, the system dynamically updates the order
summary, including product quantity, pricing, applicable discounts, and subtotal.
Customers can modify product quantities, remove unwanted items, or continue shopping before
proceeding to checkout.
60
Advantages
Flexible shopping experience
Real-time order calculation
Easy quantity modification
Improved purchase convenience
Objective
The Checkout Module collects customer information and processes orders securely before
payment.
It has been designed to reduce unnecessary steps while ensuring complete and accurate order
information.
Features
Billing Details
Shipping Address
Contact Information
Coupon Support
Order Summary
Payment Selection
Order Confirmation
Working
During checkout, customers enter billing and shipping information, verify the order summary,
select their preferred payment method, and confirm the purchase.
The system validates customer details before forwarding the transaction to the secure payment
gateway.
Advantages
Simplified purchase process
Secure order handling
Faster checkout
Reduced cart abandonment
61
6.15 PAYMENT PROCESSING MODULE
Objective
The Payment Processing Module ensures secure and reliable online financial transactions
through integration with a trusted payment gateway.
Features
Secure Online Payment
UPI
Debit Cards
Credit Cards
Net Banking
Digital Wallets
Payment Verification
Working
After confirming the order, customers are redirected to the payment interface. Once the payment
is successfully completed and verified, the application automatically updates the order status and
generates the corresponding transaction record.
Advantages
Secure transactions
Multiple payment options
Fast payment processing
Reliable verification
Objective
The Order Management Module controls the complete lifecycle of customer orders from order
placement to delivery.
62
Features
Order Creation
Order History
Order Confirmation
Order Status
Invoice Generation
Delivery Tracking
Working
After successful payment, the application creates a new order and stores all associated
information in the database. Customers can access order details through the dashboard, while
administrators can process and update order status through the administrative interface.
Advantages
Automated order handling
Simplified administration
Accurate record management
Better customer experience
Objective
The Track Order Module enables customers to monitor the progress of their orders after
purchase.
Features
Order Search
Order Status
Tracking Information
Delivery Progress
Order Verification
Working
63
Customers can enter their order details to retrieve the latest order status. The application displays
current processing information, allowing customers to remain informed throughout the delivery
process.
Advantages
Improved transparency
Reduced customer enquiries
Better post-purchase experience
Objective
The Email Notification and Invoice Module automates customer communication after important
activities such as registration, order placement, and payment confirmation.
Features
Order Confirmation Email
Payment Confirmation
Invoice Generation
PDF Invoice
Packing Slip
Customer Notification
Working
Immediately after successful order placement, the application generates a PDF invoice and
sends automated confirmation emails to the customer using the integrated SMTP service. This
ensures proper documentation of every completed transaction.
Advantages
Automated communication
Professional documentation
Improved customer trust
Reduced manual effort
64
6.19 SUMMARY
This section described the implementation of customer interaction and transaction modules that
form the operational core of the proposed e-commerce platform. The Authentication, Customer
Dashboard, Wishlist, Shopping Cart, Checkout, Payment Processing, Order Management, Order
Tracking, and Email Notification modules work together to provide a secure, efficient, and user-
friendly shopping experience.
The integration of these modules ensures seamless execution of the complete purchase workflow,
from customer registration to successful order completion and post-purchase communication.
The modular design also facilitates future enhancements while maintaining system reliability,
scalability, and maintainability.
Objective
The Administrator Dashboard serves as the central control panel of the proposed e-commerce
platform. It enables administrators to efficiently monitor and manage website operations, products,
customer activities, orders, promotional campaigns, and overall system performance.
The dashboard provides a unified interface for administrative tasks, reducing manual effort and
improving operational efficiency.
Features
Dashboard Overview
Product Management
Category Management
Order Management
Customer Management
Coupon Management
Discount Management
Website Configuration
Analytics Reports
Media Management
User Role Management
Working
65
Administrators can navigate through different modules to manage products, monitor customer
orders, configure promotional campaigns, and analyze website performance.
Advantages
Centralized management
Easy monitoring
Reduced manual work
Improved business efficiency
Better operational control
Objective
The Product Management Module enables administrators to efficiently maintain the product
catalogue while ensuring accurate inventory information.
Features
Add New Products
Update Product Information
Delete Products
Upload Product Images
Manage Product Categories
Configure Product Variations
Inventory Monitoring
Stock Availability
Working
Administrators can create and modify products by providing details such as product name,
category, description, pricing, stock quantity, images, and product variations.
The inventory information is updated dynamically whenever customer orders are processed.
Advantages
Easy inventory maintenance
Accurate stock information
Faster product updates
Organized product catalogue
66
6.22 DISCOUNT & PROMOTIONAL MANAGEMENT MODULE
Objective
Promotional campaigns are essential for attracting customers and increasing sales. The
proposed application provides a flexible discount management system that supports multiple
promotional strategies.
Features
Product Discounts
Category Discounts
Coupon Codes
Payment Method Discounts
Seasonal Offers
Promotional Campaigns
Working
Administrators configure promotional rules through the management interface. The application
automatically validates customer eligibility and applies appropriate discounts during checkout.
Advantages
Increased customer engagement
Higher sales conversion
Automated discount calculation
Flexible promotional campaigns
Objective
67
Features
Website Visitor Statistics
Product Performance
Sales Reports
Conversion Analysis
Customer Behaviour
Traffic Sources
Device Analysis
Revenue Reports
Working
The analytics system continuously collects visitor information and generates reports that help
administrators understand customer preferences and purchasing patterns.
These reports support strategic decision-making by identifying popular products, peak traffic
periods, and conversion trends.
Advantages
Better business insights
Data-driven decision making
Customer behaviour analysis
Sales monitoring
Objective
Search Engine Optimization (SEO) improves the visibility of the website in search engine results,
enabling potential customers to discover products more easily.
Features
XML Sitemap
Meta Title Optimization
Meta Description
Canonical URLs
Schema Markup
Search-Friendly URLs
Image Optimization
68
Working
The SEO module generates search engine-friendly content by optimizing page metadata, URLs,
product descriptions, and indexing information.
Advantages
Higher search rankings
Increased organic traffic
Better product visibility
Improved website discoverability
Objective
Website performance directly influences customer satisfaction, user engagement, and search
engine rankings.
The proposed system incorporates multiple optimization techniques to improve loading speed
and overall website performance.
Features
Browser Caching
Server-side Caching
Image Compression
Lazy Loading
Content Delivery Network (CDN)
CSS Optimization
JavaScript Optimization
Core Web Vitals Enhancement
Working
The optimization module reduces unnecessary server requests, compresses website resources,
optimizes images, and delivers static assets through optimized delivery mechanisms.
69
Advantages
Faster website loading
Improved user experience
Better SEO ranking
Reduced server load
Higher customer retention
Objective
Working
The security module continuously validates user credentials, protects customer sessions,
encrypts sensitive communications, and restricts unauthorized access to administrative resources.
The integration of secure authentication and payment verification minimizes the risk of
unauthorized access and transaction fraud.
Advantages
Customer data protection
Secure online payments
Reduced security risks
Reliable authentication
Enhanced system integrity
70
6.27 RESPONSIVE DESIGN IMPLEMENTATION
Objective
The application has been designed following responsive web design principles to ensure
compatibility across various screen sizes and devices.
Supported Devices
Desktop Computers
Laptop Computers
Tablets
Smartphones
Features
Responsive Layout
Flexible Grid System
Adaptive Images
Mobile Navigation
Touch-Friendly Interface
Cross-Browser Compatibility
Advantages
Better accessibility
Improved customer experience
Mobile-friendly interface
Consistent design across devices
Objective
To ensure business continuity and prevent data loss, the application includes a backup and
recovery mechanism for website files and database records.
Features
Automated Scheduled Backups
Database Backup
71
Website File Backup
Backup Restoration
Cloud Storage Support
Benefits
Protection against accidental data loss
Quick restoration of website data
Improved reliability
Disaster recovery support
6.29 SUMMARY
This chapter presented the implementation details of all major functional modules integrated into
the proposed e-commerce platform. The customer-facing modules, administrative dashboard,
inventory management, promotional engine, analytics, search engine optimization, security
mechanisms, responsive interface, and backup management collectively provide a robust and
scalable digital commerce solution.
72
CHAPTER 7: DATABASE DESIGN
7.1 INTRODUCTION
A database is one of the most important components of any web-based application because it
stores, organizes, and manages all information required for system operation. In an e-commerce
platform, the database maintains customer details, product information, orders, payments,
inventory, and other operational records.
The proposed application uses a MySQL Relational Database Management System (RDBMS)
due to its reliability, scalability, security, and compatibility with PHP-based web applications.
The database has been designed by following normalization principles to minimize redundancy,
maintain data integrity, and improve query performance.
The proposed database follows a relational architecture in which different entities are
interconnected using primary keys and foreign keys.
Users
Products
Categories
Orders
Order Items
Payments
Wishlist
Reviews
Coupons
Contact Messages
The architecture ensures efficient communication among different modules of the application
while maintaining consistency across all records.
73
Figure 7.1 Database Architecture
USERS
│
┌───────────┼───────────┐
▼ ▼
ORDERS WISHLIST
│ │
▼ ▼
ORDER ITEMS ───────────► PRODUCTS
│ │
▼ ▼
PAYMENTS CATEGORIES
│
▼
INVOICES
The following tables constitute the core database structure of the proposed application.
Users Table
The Users table stores all customer-related information required for authentication and order
processing.
74
Major Fields
Products Table
The Products table stores complete product information displayed on the website.
Major Fields
Product_ID
Product Name
Category
Price
Stock Quantity
Product Description
Product Images
Orders Table
Major Fields
Order_ID
User_ID
Order Date
Payment Status
Order Status
Total Amount
Payments Table
The Payments table stores transaction information generated after successful payment.
Major Fields
Payment_ID
Order_ID
Payment Method
Transaction ID
Payment Status
75
Payment Date
Wishlist Table
The Wishlist table stores products bookmarked by customers for future purchase.
The database maintains relationships among tables using Primary Keys and Foreign Keys.
Primary Keys
User_ID
Product_ID
Order_ID
Payment_ID
Category_ID
Foreign Keys
User_ID → Orders
Product_ID → Order_Items
Order_ID → Payments
Category_ID → Products
To improve efficiency and reduce redundancy, the proposed database has been normalized up to
the Third Normal Form (3NF).
The proposed database incorporates several security measures to protect customer and
business information.
These measures help ensure confidentiality, integrity, and availability of stored information.
7.8 SUMMARY
This chapter presented the database architecture used in the proposed e-commerce platform.
The relational database structure enables efficient management of products, customers, orders,
payments, and business operations.
By following normalization principles and implementing proper relationships among tables, the
database provides reliable data storage while ensuring scalability, consistency, and security.
The next chapter presents the testing methodology adopted to verify the functionality,
performance, compatibility, and reliability of the developed application.
77
CHAPTER 8: REFERENCES
The following references were consulted during the design and development of the proposed
system.
Books
Research Papers
Official Documentation
78