Water Buddy
A streamlined utility portal and automated water bill calculation system. Designed to simplify water meter reading submissions, compute tier-based utility costs instantly, and present clear consumption trends for domestic consumers.
Project Overview
Water Buddy addresses the common challenge of manual billing errors and lack of consumption awareness. The application delivers an intuitive dashboard where users input their water meter units to get instant billing updates based on official tiered tariff logic, allowing households to monitor and manage their water footprint effectively.
Live interaction showcase of the Water Buddy utility calculation portal
Tariff Tier Engine
Processes total water unit readings and splits the cost across official government tariff categories dynamically.
Usage History Tracking
Stores historical user logs to display seasonal trends, alerting users to sudden hikes or spikes in consumption.
Key Features
Account Management
Customers register their accounts to save calculations, track multiple premises, and personalize profiles.
Secure Admin Controls
Provides administrators with tools to override tariff values, manage users, and export monthly statements.
Dynamic Bill Preview
Renders a printable invoice outline highlighting base charges, unit prices, and final grand totals.
Database Design & ER Diagram
The project is backed by a structured MySQL relational schema that records user credentials, readings, and payment templates efficiently:
MySQL Database Entity-Relationship (ER) Diagram
Details
- Type Academic Project
- Category Web Application
- Status Demo & Source Available
- Role Lead Developer