Skip to main content
Back to Portfolio
Relational Database & Full-Stack

entcarehub

A data-driven health consultant discovery and review platform powered by complex relational SQL aggregations and dynamic React filtering.

Relational SQL & Dynamic Aggregation

The heart of ENT Care Hub is a normalized MySQL database. Complex SQL queries leveraging multi-table JOINs, subqueries, and aggregate functions compute consultant scorecards, verified review averages, and specialization rankings in real time.

Core Features

  • Complex SQL Leaderboards

    Dynamic ranking algorithms utilizing multi-table JOINs, GROUP BY, and mathematical weighting.

  • Instant Search & Filtering

    Client-side React filtering with debounced REST queries across clinical specializations and geographic locations.

  • Verified Review Pipeline

    Structured feedback mechanism calculating multi-dimensional consultant ratings and verified patient reviews.

  • PHP Authentication & RBAC

    Secure session management, password hashing, and role verification separating patients from verified practitioners.

Technology Stack

DatabaseMySQL (Normalized 3NF Schema)
Backend ServicesPHP (REST API & Auth)
Frontend LayerReact, JavaScript, Tailwind CSS
Query EngineRelational SQL (JOINs, Aggregates, Indexes)
SecurityBcrypt Hashing, SQL Injection Parameterization, XSS Sanitization

SQL Optimization Focus

SELECT c.id, c.name, AVG(r.rating) AS avg_score, COUNT(r.id) AS review_count
FROM consultants c
INNER JOIN reviews r ON c.id = r.consultant_id
GROUP BY c.id HAVING review_count >= 5
ORDER BY avg_score DESC;

The Mission

Patients navigating specialized Ear, Nose, and Throat (ENT) healthcare often struggle to find validated consultant ratings, specialization breakdowns, and transparent waiting times. ENT Care Hub was engineered to bridge this gap by delivering a structured, data-driven discovery engine.

Relational Database & Query Optimization

The project prioritizes database normalization, establishing foreign key constraints and composite indexes across tables for consultants, hospital clinics, clinical sub-specialties, and verified patient reviews.

To compute dynamic leaderboards without sacrificing query response times, I wrote complex SQL queries utilizing multi-table JOIN operations, aggregated subqueries, and conditional scoring functions. This ensured that ranking scores accurately reflected both weighted review volume and categorical patient feedback.

Full-Stack Integration & Security

The PHP backend was structured as a secure RESTful service, enforcing prepared statements to eliminate SQL injection vulnerabilities and implementing password hashing via bcrypt for account authentication. The responsive React frontend consumes these endpoints, rendering interactive consultant cards with live search filtering and dynamic review modals.

Explore More Case Studies
Previous Project

Make-It-All

Node.js • Express • React

Next Project

Event Ticket Booking System

Java • Swing (GUI) • OOP Design

All Projects Grid