NAVIERO is a flight booking platform that pulls real-time live flight data — actual departures, arrivals, statuses, and aircraft info — instead of static dummy listings. Users can search live flights, pick a cabin class and seat, and complete a booking with payment, all backed by a MySQL database.
Backend
- Node.js — Runtime environment
- Express.js — Web framework for building APIs
Database
- MySQL — Relational database
- mysql2 — Node.js MySQL driver
- Travel_Agent
- Passenger
- Flight
- Seat
- Bookings
- Booking_Passenger
- Payment
- Sign up / login
- Live flight search by origin and destination
- Domestic flights skip the First Class option
- Cabin class and seat selection
- Passenger details with meal, wheelchair, and medical preferences
- Payment with a printable e-ticket receipt
- Flight booking and cancellation
- Seat availability tracking
- Payment and refund management
schema.sql– Database table creationsample_data.sql– Sample recordsqueries.sql– Important SQL queries
Aleena Benny
Erine Anna Binu
Gayathry S
Parvathy KK