Smart Flight Booking & Management System

Maddipudi Janakiram, Muppavarapu Vishnu Ram Sai, Govindu Lvn Sridhar,

Paleru Satwika Chowdary, Gayathri Ramasamy and Gurupriya M.

Department of Computer Science and Engineering, Amrita School of Computing, Amrita Vishwa Vidyapeetham 560035,

Bengaluru, Karnataka, India

Keywords: Frequent Flyer Program, Jet Details, SQL, Data Integrity, User Interface (UI), Database Normalization.

Abstract: Smart Flight Booking & Management System is a complete database management system with the purpose

of enabling airline flight reservations, customer management, and other airline functions. The system is able

to arrange and man- age structured flight information, passengers, transactions, and frequent flyers, and the

system enables smooth reservation operations. Admin, Customer, Flight Details, Frequent Flyer Program, Jet

Details, Passenger Information, Payment Processing, and Ticketing are the major modules. The system is

designed to optimize flight scheduling, data consistency, and maximize the customer experience. The system

uses a relational database model with SQL that ensures data integrity and minimizes redundancy. This paper

presents the design, development, and implementation of an efficient and scalable airline reservation system.

1 INTRODUCTION

Smart Flight Booking & Management System is an

advanced and very main tool for simplifying airline

business, providing a safe, reliable, and accessible

platform for managing flight bookings and client

data. In the internet age transformation, the tourism

sector, especially the airlines, has have undergone

numerous changes, and such systems like the Airline

Reservation System have a vital role to play in

improving customer experience, enhancing operating

performance, and securing smooth transaction

processes. This project is aimed at create an end-to-

end and holistic solution that processes all phases of

the airline reservation process from flight scheduling

and ticket reservation through to payment processing

and passenger management. The system will be

utilized to manage large volumes of data and to offer

a centralized platform to customers and

administrators. The customer can easily search for

available flights, buy tickets, and confirm their

booking status. For administrators, the system will

pro- vide them with options to manage flight

schedules and frequent flyer data, in bulk with

payment processing and handling different

transactions histories. The system is structured in a

manner that it reduces complexity of traditional

booking systems by the integration of different

elements, such as Flight Details, Passenger

Information, Payment Details, Ticket Details, and

Frequent Flyer Information. The system thus can

automate most tasks, thus lowering the manual steps

taken in the past. Providing a recent update on flight

availability, ticket prices, and seat bookings along

with a booking confirmation is one of the inherent

characteristics of this system. The Admin Interface of

the airline is an opportunity to oversee the whole

process - from creating new flight services to

handling customer’s information. It supports the GUI,

so that easy, intuitive work for customers who have

little knowledge and high technical ones can perform

in the most simple and friendly ways possible. This

system addresses a key aspect of operating airlines

nowadays-the Frequent Flyer Program-and accounts

for tracking of customer status, rewards, and loyalty

points level. This factor increases customer loyalty by

providing incentives to frequent travelers on

discounts, upgrades, or priority boarding. This

element of the system, therefore, is particularly

capable of tracking and monitoring rewards when

pertaining to different customers, hence facilitating

the ease of the airlines to offer specialized services.

Further, the Jet Details module is used to track

significant details about the aircrafts which are in use,

such as model, capacity, and the maintenance

schedules, on notification of the customers as regards

750

Janakiram, M., Sai, M. V. R., Sridhar, G. L., Chowdary, P. S., Ramasamy, G. and M., G.

Smart Flight Booking & Management System.

DOI: 10.5220/0013920200004919

Paper published under CC license (CC BY-NC-ND 4.0)

In Proceedings of the 1st International Conference on Research and Development in Information, Communication, and Computing Technologies (ICRDICCT‘25 2025) - Volume 4, pages

750-753

ISBN: 978-989-758-777-1

their own flights. This increases openness and

bettering the decision made regarding operating. The

core one benefit of this Airline Reservation System is

that its information structure is relational and supports

by a RDBMS of SQL. Its database, in this regard,

offers consistency, data integrity, and information

access. Moreover, by making such information

streamlined, the likelihood of repetition is low and it

is highly efficiently. The system is also scalable, that

is, it can transport an increasing number of travelers,

flights, and transactions when the airline grows.

2 LITERATURE SURVEY

Airline Reservation System. It is a simple goal, since

this is accomplished at stream- lining flight

reservation procedures. Facilitates easy access in the

acquisition of flight related information and tickets,

for customer airline relationship improvement.

Extensive flight lists to provide a snapshot of, for i.e.,

time tabled routes and flights except class of economy

and business classes; facilitates selecting and

comparison. The system enables the users to verify

flight availability and seat status by providing the

details needed. It minimizes manual work and

significantly reduces errors. (N. Durga Devi, 2023).

The project creates a” multifunctional tourism

information service website” based on MySQL

technology. For the dynamic web page designing, it

uses ASP.NET and ADO.NET for database

operations and business logic. Client/server

architectures, like JSP, JDBC, and MySQL 2005, are

used in the Java web application development

framework. This paper considers into the system’s

demand analysis, design goals, business processes,

and performance requirements.

This strategy enhances system performance by

9.7% (L. Ling,2022). Travel agency management

system based on Flask and MySQL is an operation

that simplifies various activities such as managing

packages, guide assignments, and customer

registrations. MySQL database supports effective

data management integrity through foreign key

constraints, although Flask does provide dynamic

routes for important functionality like user

authentication and package management. Future- like

real-time updates, secure payment gateways, and

analytics for increased efficiency and customer

experience, illustrating the platform’s ability to drive

growth and development of the tourism industry (J.

D. B. K., 2024). This article formulates a user-

centered flight search and booking system for better

usability and responsiveness. Challenges which are

advertised in connection with reserving low-cost

flights, handling multiple tabs, among others, have

been incorporated via user testing, wireframes, and

prototypes. The system was developed with

Bubble.io and MySQL to emphasize features such as

pickers for locations and dates, accessibility, and

usability to deliver a great booking experience (S.

Pokhrel, et al., 2024). This paper suggests a web-

based bus reservation system to streamline ticketing

and reduce the efforts and time of manual bookings.

Referring to Bombay Electric Supply Transport

(BEST) case study, the system enables users to check

for bus availability, buy, and pay for tickets online.

Built by technologies like XHTML, PHP, SQL, Ajax,

CSS, and JavaScript, the system follows the

Structured Systems Analysis and Design

Methodology (SSADM) for guaranteeing an efficient

and user- friendly design. [5]. This paper proposes an

online event management system, which unites event

managers and clients in a seamless business booking

and negotiation. The system is to allow remote buyers

to view what packages, items, and simple web-based

reservation services. Built on Bootstrap, MySQL, and

PHP, it is flexible and efficient, saves time and cost,

and enhances the event management process. This is

a web application that builds an efficient bus ticketing

system where the users can book tick- ets by

employing laptops or smartphones, and they can store

it securely in the cloud database. The system is not

required any physical tickets like in the conventional

systems but it has a ticket checker application to

validate the number of tickets or details of the users.

The service provides secure storage of tickets and

provides an alternative means of verification in cases

such as damage to a device or battery failure, making

it easier and more reliable. This is regarding

microservices for designing and building the

distributed database for the online travel portal on

cloud service. It is designed to process large amounts

of data, manage load balancing, and build live data

for world- wide access. Microservices break up large

applications into little stand-alone services enhancing

scalability and dependability. Techniques for

fragmentation, allocation, and integration relational

algebra are explored in the research. It also depicts

how a dis- tributed database can handle the data of its

users in other countries by establishing local

databases and helps in the facilitation of proper

supervision of data also prevents failure in systems

(Ramasamy, G., et al., 2025).

Smart Flight Booking & Management System

751

3 METHODOLOGY

3.1 Requirement Analysis

The initial step in the system design is collecting and

reviewing the needs. This is the phase where needs of

the stakeholders are understood. These stakeholders

involve administrators, passengers, and the airline

organization. Functional and non-functional

requirements were discovered in a bid to make the

system function characteristics of air transport

requirements. The prominent features that have been

identified are:

• Customer Profile Management: User account

creation, personal details, and flying history.

• Flight Reservation System: It must enable

customers to book flights, book tickets,

• and receive booking confirmations.

• Payment Integration: Secure payment

management transactions

• Admin Interface: This aspect should enable

administrators to reserve flights, customer

information, and payment processing

• Frequent Flyer Program: Measuring customer

loyalty points and offering rewards

• Reports and Analytics: Admins must be able to

see comprehensive payment reports, booking

reports, and customer reports activity

3.2 System Design

This is the architecture design phase where a system,

including its interface and database, would be created.

Database Design: The core of the Airline

Reservation System is the database, containing the

required information for bookings and reservations,

customer data management, payment accounts, and

other transactional records. An RDBMS, SQL is

employed for data storage as well as handling

database. The following was in the process of

designing a database:

Entity-Relationship (ER) Diagram: ER

diagram was intended to cover all the entities within

the system and their social interactions. Therefore,

institutions like customers, flights, tickets, payments,

admin, the frequent flyer program, and jet details

were defined.

Normalization: The database must be normalized to

atleast the third normalform (3NF) so that there is no

redundancy as well as data integrity. That means

tables should reduce redundant data; therefore, the

integrity of relationships.

Tables: The tables below were constructed:

Admin: Holds admin login credentials and privileges.

Customer: Has customer information, such as name,

flight history, and contact.

Flight Details: Stores flight details such as departure

time, arrival time, and fare.

Frequent Flyer Information: Stores customer loyalty

points, reward status, and benefits.

Jet Details: Holds details of the aircraft, like jet type,

capacity, and maintenance

schedules.

Passenger: Stores information about passengers on

each flight, such as name, phone number, and special

requests.

Payment Details: Includes payment method details,

transaction ID, amount paid,

and the status of payment.

Ticket Details: Holds the information about the ticket

with ticket ID, flight ID, passenger ID, and booking

status.

User Interface (UI) Design: It is designed with

users in mind as considering the various needs of the

users (customers and admins). Two interfaces were

developed:

• Admin Interface: It is a secure and user-

friendly airline administrators’ interface

• to operate the flight schedule, customer

booking, payment, and frequent flyer

records.

• Customer Interface: An easy-to-use,

intuitive interface for passengers to find

• flights, purchase tickets, make payments,

and see their booking history.

Use Case Diagrams: Use cases diagrams were

created to depict functional interactions between

users like the admin and customer and the system.

This involved description of actions taken at different

common activities, like the reservation of an airplane,

processing payments, and updating schedules of

flights.

System Development: The design process was

finalized. This accomplished the development stage

of the system. The system would utilize a

combination of technologies. It comprised based on

the backend:

• SQL Database: MySQL or PostgreSQL was

employed to develop and administer the

relational database.

ICRDICCT‘25 2025 - INTERNATIONAL CONFERENCE ON RESEARCH AND DEVELOPMENT IN INFORMATION,

COMMUNICATION, AND COMPUTING TECHNOLOGIES

752

• Programming Languages: Depending on the

stack chosen, programming languages like Java,

Python (with Flask/Django), or PHP can be

utilized to create the backend elements (process

flight bookings, process transactions, etc.).

• For customer interface, web technologies such

as HTML, CSS, and JavaScript were utilized to

develop an interactive, responsive front-end. •

For the admin inter- face, Bootstrap or React

might be employed to develop contemporary,

user-friendly dashboards

• Tkinter or JavaFX can be employed if the users

are coded to function in a desktop application.

4 CONCLUSIONS

Airline Reservation System is developed while

ensuring all aspects of flight reservation, data

handling, and user experience in mind. The method

followed ensures robustness, scalability, security, and

usability of the system. It is a systematic method of

design and development of such a system, it can

handle effectively a large volume of transactions and

data, thus creating a cost-effective solution. for both

the airline operators and the passengers. The system

offers easy flight booking, payment, and customer

management with administrative support and

providing live updates.

REFERENCES

Barua, et al.,” Designing and Implementing a Distributed

Database for Microservices Cloud-Based Online Travel

Portal,” in Sentiment Analysis and Deep Learning:

Proceedings of ICSADL 2022. Singapore: Springer

Nature Singa- pore, 2023, pp. 295-314.

J. D. B. K.,” TRAVEL MANAGEMENT SYSTEM,” PhD

diss., Davangere University, 2024.

K. R., K. M. K., and S. G. U.,” Cloud Based Online Bus

Ticket Sys- tem,” in 2023 International Conference on

Recent Advances in Science and Engineering

Technology (ICRASET), B G NAGARA, India, 2023,

pp. 1-5, doi: 10.1109/ICRASET59632.2023.10420257.

Kumar Agrahari, S., Kumar Das, A., Yadav, A., &

Ramasamy, G. (2024). Next-Gen Routing and

Scalability Enhancements in Mobile Ad Hoc

Networks. Available at SSRN 5089037.

L. Ling,” Design of Multifunctional Online Travel Service

Management Plat- form and the Implementation of

MySQL,” in 2022 4th International Conference on

Inventive Research in Computing Applications

(ICIRCA), Coimbatore, India, 2022, pp. 1293-1296,

doi: 10.1109/ICIRCA54612.2022.9985607.

M. F. M. Khan, V. Rajbhar, and V. Mahmia,” Development

of An Online and Train Bus Ticket Reservation System

for A Transportation Service in Mumbai (Quick-Bt).”

M. Ganiyu, O. S. Egwuche, and K. O. Adekunle,” Online

Events Booking and Reservation System.”

N. Durga Devi, A Project Report Submitted to, Diss.

Madurai Kamaraj University, 2023.

Ojas, O., Vashishtha, A., Kumar Jha, S., Kumar Shah, V.,

Kumar, R., & Ramasamy, G. (2024). James: Enhancing

Judicial Efficiency with Smart Administration. Availa

ble at SSRN 5091509.

Ramasamy, G., Shaik, B. A., Kancharla, Y., & Manikanta,

A. R. (2025). A Bash-based approach to simulating

multi-process file systems: Design and implementation.

In Challenges in Information, Communication and

Computing Technology (pp. 200-206). CRC Press.

S. Pokhrel, et al.,” Improving Usability, Visibility, and

Responsiveness of an Air- line Reservation System

Using User-Centered Design,” International Journal of

Computer Communication and Informatics, vol. 6, no.

1, pp. 1-15, 2024.

Sai, P. C., Karthik, K., Prasad, K. B., Pranav, V. S., &

Ramasamy, G. (2025). Web-based real time chat

application using MERN stack. In Challenges in

Information, Communication and Computing Technol

ogy (pp. 195-199). CRC Press.

Sai, P. C., Karthik, K., Prasad, K. B., Pranav, V. S., &

Ramasamy, G. (2025). Web-based real time chat

application using MERN stack. In Challenges in

Information, Communication and Computing Technol

ogy (pp. 195-199). CRC Press.

Smart Flight Booking & Management System

753