Flight Booking & Management System powered by Supabase (Backend as a Service) and PostgreSQL, including an iOS Mobile Application for Customers and a Web-based Dashboard for Admins.

https://admin-dashboard-demo.onrender.com/

• Open Admin Dashboard

• Download Flexair demo video

• Course: CMPE344 - Database Management Systems and Programming II
• Institution: Cyprus International University
• Instructor: Prof Dr Melike Şah Direkoğlu
• Due Date: December 21, 2025

• Mahan Mizani
• Nikolai Piatnov
• Maksim Kalmykov
• Marcel Tshidibi Ngoyi

• Flight search by route and date
• Passenger management
• Booking creation and cancellation
• Booking history
• Management analytics queries

1. auth.users - User authentication
2. profiles - User profiles with roles
3. airlines - Airline information
4. airports - Airport details
5. flights - Flight schedules and pricing
6. passengers - Passenger information
7. bookings - Booking records

• Database: PostgreSQL, SQL and PL/pgSQL
• Backend as a Service (BaaS): Supabase (Auth, Realtime, PostgREST, Functions, Storage)
• Authentication: Supabase Auth
• Mobile Application: iOS App (Swift, SwiftUI, MVVM)
• Admin Interface: Web-based Dashboard (Python, Flask, Render Cloud)
• Version Control: Git

• search_flights() - Search flights
• add_passenger() - Add passenger
• get_passengers() - Get user passengers
• update_passenger() - Update passenger
• create_booking() - Create booking
• get_user_bookings() - Get bookings
• cancel_booking() - Cancel booking

• Auto-update timestamps
• Prevent overbooking
• Restore seats on cancellation

• Available flights
• User bookings
• Flight statistics

1. Revenue by airline
2. Popular routes
3. Customer spending
4. Flight occupancy
5. Monthly revenue trends
6. Available seats (subquery)
7. Passenger demographics

1. Create Supabase project at https://supabase.com
2. Run scripts in SQL Editor:
   • schema.sql
   • seed-data.sql
   • functions.sql
   • triggers.sql
   • views.sql

1. Clone the repository
2. Open flexair project in XCode 16 or later
3. Add Supabase-Swift dependencies in the Project - Packages
4. Copy Secrets.template.xcconfig to Secrets.xcconfig
5. Add your API keys to Secrets.xcconfig
6. Build and run!

• Supabase URL: Open your Supabase project/Project Settings/Data API - Project URL
• Supabase Key: Open your Supabase project/Project Settings/API Keys - Publishable key

• ✅ 6+ tables with proper Relationships
• ✅ User Authentication and Role-based Access
• ✅ Foreign keys and Constraints
• ✅ 7 PL/SQL Functions
• ✅ 3 Database Triggers
• ✅ 3 Database Views
• ✅ 7 Management queries (JOIN, subquery, GROUP BY, etc.)
• ✅ Mobile Application for Customers
• ✅ Web-based Dashboard for Admins
• ✅ Backend as a Service (Supabase)
• ✅ Cloud deployment (Render)
• ✅ GitHub Repository

Academic Project - CMPE344 Database Management Systems, Cyprus International University (Fall 2025)