React + Express + PostgreSQL Schema

TravelDost

Full-Stack Web Companion & Relational Itinerary Engine

DOMAINFull-Stack Web & Relational Database Systems

ROLELead Full-Stack Engineer & Database Architect

YEAR2026

CASE STUDY IDPROJECT_02

Project Overview

TravelDost is a full-stack companion web platform featuring 3NF normalized relational database schemas, multi-tier API routing architectures, and responsive component UI layouts.

React.jsNode.jsExpress.jsPostgreSQLTailwind CSSRESTful APIs

// THE CHALLENGE & PROBLEM SPACE

Standard travel planning tools rely on unstructured documents or flat lists, causing synchronization friction when tracking multi-destination itineraries across travel companions. The objective was engineering an atomic relational database schema with sub-50ms API lookups.

// SYSTEM ARCHITECTURE & METHODOLOGY

Normalized PostgreSQL database tables down to 3NF atomic schemas to ensure strict relational integrity constraints between User Accounts, Trip Itineraries, and Stop Coordinates. Built RESTful Express API routes with parameterized SQL queries and deployed a responsive React frontend.

Validation Metrics & Key Deliverables

Database EnginePostgreSQL

API RoutingRESTful Express

Query Speed<45ms Index Lookups

Schema ModelAtomic 3NF Standard

KEY TECHNICAL HIGHLIGHTS

Engineered 3NF database schema guaranteeing zero redundant data duplicates across multi-day itineraries.

Achieved sub-45ms SQL query execution using indexing strategy on trip lookup keys.

Built custom React state engine linking interactive maps with step-by-step travel schedules.