2026

Full Stack Development

Architecture & System Design

SeatSphere was engineered to solve data fragmentation and static state limitations common in traditional movie booking systems. By utilizing a decoupled full-stack architecture, the platform cleanly separates backend transaction processing from frontend user interaction.

Key Technical Highlights

  • Decoupled Full-Stack Architecture: Built with a Java Spring Boot REST API, Node.js/Express web layer, and a structured MySQL database.

  • Dynamic Relational Engine: Replaced static state flags with automated SQL-driven logic to calculate real-time seat availability, map ADA accessibility, and process multi-table transactions.

  • Security & Management: Features Role-Based Access Control (RBAC) to manage customer and administrative user permissions.

  • Ticketing & Real-Time Sync: Automated QR code ticket generation upon purchase confirmation with real-time synchronization between customer bookings and administrative analytics.


Live Demo: https://iu.mediaspace.kaltura.com/media/t/1_jov5jta3

Additional Live Demo: https://iu.mediaspace.kaltura.com/media/t/1_defw1v02

GitHub: https://github.com/daniellexkemp/SeatSphere

Mission

Mission

To eliminate manual data fragmentation in venue ticketing by engineering a dynamic, relational database architecture capable of processing transactional bookings, mapping accessibility features, and syncing live analytics in real time.

To eliminate manual data fragmentation in venue ticketing by engineering a dynamic, relational database architecture capable of processing transactional bookings, mapping accessibility features, and syncing live analytics in real time.

Challenge

Challenge

Traditional booking systems often rely on static state flags and manual data handling, leading to data fragmentation, double-booking errors, and poor synchronization between customer interfaces and administrative dashboards. Designing a platform that accurately calculates live seat availability and ADA accessibility across concurrent transactions required a robust, relational approach.

Traditional booking systems often rely on static state flags and manual data handling, leading to data fragmentation, double-booking errors, and poor synchronization between customer interfaces and administrative dashboards. Designing a platform that accurately calculates live seat availability and ADA accessibility across concurrent transactions required a robust, relational approach.

Solution

Solution

Built a decoupled system leveraging a Spring Boot REST API and normalized MySQL schema to handle multi-table transactional logic. The engine automatically calculates live seat availability, processes booking transactions, generates QR codes, and synchronizes reservation data directly with an administrative analytics dashboard.

Built a decoupled system leveraging a Spring Boot REST API and normalized MySQL schema to handle multi-table transactional logic. The engine automatically calculates live seat availability, processes booking transactions, generates QR codes, and synchronizes reservation data directly with an administrative analytics dashboard.

Result

Result

Engineered a full-stack cinema management platform utilizing a decoupled architecture with a Java Spring Boot REST API, a Node.js/Express frontend, and a relational MySQL backend. The platform replaces static state flags with a dynamic relational engine to calculate real-time seat availability, map ADA accessibility, and process multi-table booking transactions with live admin analytics synchronization.

Engineered a full-stack cinema management platform utilizing a decoupled architecture with a Java Spring Boot REST API, a Node.js/Express frontend, and a relational MySQL backend. The platform replaces static state flags with a dynamic relational engine to calculate real-time seat availability, map ADA accessibility, and process multi-table booking transactions with live admin analytics synchronization.