Faculty of Engineering DB-PROJECT

CPE241SkyVoyage

FLIGHT RESERVATION SYSTEM & DATABASE ARCHITECTURE

01. Project Abstract

SkyVoyage is a database-backed system built to support basic airline operations. The project focuses on organizing flight information, handling seat bookings safely using transactions, and managing structured reservation data. It was developed as part of a database systems course and demonstrates how relational database concepts can be applied in a real, working full-stack application. This deployment marks the completion of the project’s development phase.

02. Pre-Flight Checklist (Status)

  • Conceptual Schema Design (ERD)
  • Relational Mapping & Normalization
  • SQL Query Optimization
  • Full-Stack Implementation
  • Final Documentation Archive

03. Flight Specifications

Course CPE241 Database Systems
System Type Relational (RDBMS)
Designation Term Project
Language SQL / TypeScript
TECH NEXT.js, Prisma (NOT ORM), Elysia.js

Repository Access

Full source code, database schema.

REPOSITORY →