E-Commerce Platform
Built with modern agile methodologies, “eGrocer” is a fully responsive application leveraging a relational database to efficiently manage products, inventory, and delivery requests.
Front-End Features
Dynamic search, multi-criteria filtering, detailed product pages, and a real-time shopping cart with instant pricing updates.
Back-End Power
Robust SQL database managing categories, customer baskets, and an integrated administrator console.
Project Scope
This project develops FreshDash, a grocery delivery web application designed for busy professionals in Australia (aged 25–60). The goal is to save time by replacing supermarket visits with a seamless online experience.
The slogan "Shop Fast, Eat Fresh!" emphasizes speed and quality. Key features include preferred delivery windows to suit working schedules.
Context: With Australian internet traffic split nearly evenly between mobile (47.2%) and desktop (49.2%), FreshDash is built with a mobile-first responsive design to maximize accessibility and sales.
Core Requirements
Show available items & categories
Advanced Search functionality
Filter search results
Sort functionality (Price/Discount)
Detailed Product Views
Shopping Cart Management
Cart Modification (Edit/Delete)
Delivery Request Creation
User Stories & Acceptance Criteria
1. Browse Items
"As a customer, I want to see what is available so I can decide if I want to shop here."
Acceptance Criteria
- Landing page with categories
- Clickable categories to view items
2. Search
"As a customer, I want to search by keyword to find items quickly."
Acceptance Criteria
- Keyword search bar
- Results display images & prices
- Quick-add to cart
3. Filter Results
"As a customer, I want to filter results to narrow down my options."
Acceptance Criteria
- Filter by category
- Display only matching items
- Reset filters
4. Sort Results
"As a customer, I want to sort by price or discount to find the best deals."
Acceptance Criteria
- Sort Price (Asc/Desc)
- Sort Discount (Desc)
- Reset sorting
5. Item Details
"As a customer, I want detailed info to ensure the product meets my needs."
Acceptance Criteria
- Show weight, price, discount
- Show similar item recommendations
- Add to cart from detail page
6. Manage Cart
"As a customer, I want to view and edit my cart before purchasing."
Acceptance Criteria
- View quantities & totals
- Remove items
- Update quantities
7. Checkout
"As a customer, I want to schedule delivery and pay."
Acceptance Criteria
- Enter delivery details
- Select time window
- View total with delivery fee
- Confirmation summary
Database Schema Design
Elementary Facts (Sample)
Diagram Legend
Entity Type Value TypeText Reference Mode
Click to Expand
Figure 1: Conceptual Schema Diagram (ORM)