Final CS

Download as pdf or txt
Download as pdf or txt
You are on page 1of 34

MAHARISHI VIDYA MANDIR SR. SEC.

SCHOOL
(Affiliated to CBSE (No. 1930954) New Delhi)

MELPAKKAM, AVADI, CHENNAI -600 077.

ACADEMIC SESSION - 2024-2025

083 – XII COMPUTER SCIENCE

PROJECT REPORT

NAME : ..................................................

CLASS & SECTION : ..................................................

ROLL NUMBER : ..................................................

TITLE OF THE PROJECT : ..................................................

TEAM MEMBERS : ………………………………..

……………………………….

1
BONAFIDE CERTICATE

REGISTER NO. :.........................................

Certified to be the bonafide project work done by

................................................................. of Std .......................in

the subject of ............................................................................ of

Maharishi Vidya Mandir Senior Secondary School, Melpakkam, Avadi,

Chennai -600 077, during the year 2024 -2025.

Date : Teacher-in-charge

Submitted for the Seniors Secondary Certificate Examination held in

the year 2024-2025 at Maharishi Vidya Mandir Sr. Sec. School, Melpakkam,

Chennai -600 077.

Internal Examiner External Examiner Principal

2
ACKNOWLEDGEMENT

First and foremost my grateful thanks to almighty for divine blessing and grace in making

this project successful. I acknowledge my sincere thanks to The Chairman and The

Correspondent of Maharishi Vidya Mandir Educational Trust for providing me this

opportunity and necessary facilities for completing this study.

My deepest appreciation goes to, Mr.T.C Perumal, Secretary, Mr.C.Ramalingam, Chief

Academic Advisor, and Mrs.Premalatha Bhoopathy , Chief Education Officer, for

motivating us. Thank you for your precious time and for the kind help and support

throughout the study.

My profound gratitude and heartfelt thanks to, Ms. Dr. M.SARAH SELVAKUMARI, M.Sc.,

M.Phil ., B.Ed.,D.Litt., Principal, Maharishi Vidya Mandir Sr. Sec. School, Melpakkam,

Avadi. Thank you mam for your expertise, enthusiasm and for the kind help in all

situations throughout the academic year.

We, would like to express our heartfelt gratitude to Vice Principal E MENAKA, M.Sc.,

M.Phil., B.Ed for giving us the opportunity to work on such an interesting project.

I extend my gratitude to Ms. D. VISHNU PRIYA , M.sc, M.E., and our Computer Science

teacher who guided me to the successful completion of this project.

I take this opportunity to express my deep sense of gratitude to all the subject teachers

for their invaluable guidance on going encouragement, enormous motivation, which has

sustained my efforts at all stages of project development.

I would like to thank my parents and all other family members for their timely

encouragements, and love during the course of the project development. Lastly, I would

like to thank my classmates and friends for their cooperation and support throughout the

year.

3
INDEX PAGE
SL.NO TOPICS PAGE NUMBER

1 ABSTRACT 5

2 INTRODUCTION ABOUT THE PROJECT 7

3 OBJECTIVES OF THE PROJECT 10

4 EXISTING SYSTEM 11

5 PROPOSED SYSTEM 12

6 HARDWARE AND SOFTWARE REQUIREMENTS 13

7 E-R DIAGRAM 14

8 ABOUT PYTHON 15

9 ABOUT DATABASE 18

10 MODULES USED IN THE PROJECT 21

11 CODING 22

12 OUTPUT SCREEN 24

13 FURTHER DEVELOPMENT & CONCLUSION 32

14 BIBILOGRAPHY 33

4
ABSTRACT: AIRLINE MANAGEMENT SYSTEM
The Airline Management System (AMS) is a software application
designed to manage the multifaceted operations of an airline. This
project aims to provide an efficient platform that integrates various
functionalities, including flight scheduling, ticket reservations,
passenger management, and operational reporting.

Objectives:

1. Streamlined Operations: To enhance the efficiency of flight


operations, scheduling, and management.
2. User-Friendly Booking: To create an intuitive ticket booking
system for customers, enabling easy flight search and
reservation.
3. Data Management: To maintain a secure and organized
database of passenger details, flight information, and financial
transactions.
4. Enhanced Customer Experience: To offer tools for customer
service, including handling inquiries and complaints effectively.
5. Analytics and Reporting: To provide analytical insights into
operations, helping management make informed decisions.

Key Features:

• Flight Scheduling: Manage flight schedules, including arrivals,


departures, and gate assignments in real-time.

5
• Reservation System: Allow passengers to book, modify, and
cancel tickets online with a secure payment process.
• Passenger Profiles: Store and manage detailed profiles for
passengers, including preferences and travel history..
• Administrative Controls: Provide a backend interface for
airline staff to manage operations, view reports, and handle
customer requests.

Technologies Used:

• Frontend: Python
• Backend: Python (Flask/Django)
• Database: My SQL
• APIs: Integration with external services for payment processing
and flight data retrieval.

The Airline Management System serves as a vital tool for modern


airlines, aiming to optimize operational workflows and elevate the
customer experience. By integrating various functions into a single
platform, AMS minimizes manual intervention, reduces errors, and
enhances communication between airline staff and passengers. The
implementation of this system not only demonstrates technical
capabilities but also addresses pressing challenges within the
aviation industry, leading to improved efficiency, customer
satisfaction, and ultimately, increased profitability. This project is
poised to make a significant impact on airline operations, making
air travel more accessible and enjoyable for everyone involved.
6
INTRODUCTION
The Airline Management System (AMS) is a sophisticated software
application designed to enhance the operational efficiency of airlines
through a centralized platform. By leveraging Python for backend
development and MySQL for database management, this project aims
to streamline various processes essential to airline operations,
ensuring a seamless experience for both airline staff and passengers.

Context and Importance

In an industry where timely operations and customer satisfaction are


paramount, managing flights, ticketing, and passenger information
can be complex and challenging. Traditional methods often involve
manual processes, leading to inefficiencies, errors, and ultimately,
dissatisfied customers. The AMS seeks to mitigate these issues by
providing a digital solution that automates and integrates core
functions of airline management, thus facilitating a more responsive
and organized approach to airline operations.

Key Features of the Airline Management System

1. Flight Management:
o Real-Time Scheduling: The AMS allows airline staff to
schedule and manage flights dynamically. Staff can add
new flights, modify existing schedules, and monitor flight
statuses (e.g., on-time, delayed, or canceled).

7
o Gate Assignments: The system includes functionalities
for assigning gates to flights and managing boarding
processes, contributing to improved airport efficiency.
2. Passenger Management:
o Comprehensive Database: The MySQL database stores
essential passenger information, including personal details,
travel history, and preferences. This enables airlines to
provide tailored services and track frequent flyer activity.
o Check-In and Boarding: The system facilitates online
check-in for passengers, reducing wait times at the airport
and enhancing the overall travel experience.
3. Cabin crew Management:
o This follows the details about the staff members in the
cabin crew their name , age , shift time , work experience
etc

Technological Framework

• Programming Language: Python is chosen for its simplicity


and versatility enables rapid development and deployment of the
application.
• Database Management: MySQL serves as the relational
database management system, offering robust data storage,

8
efficient querying capabilities, and transaction management. Its
structured nature ensures data integrity and security.
• Connectivity: The AMS uses libraries like MySQL Connector
for seamless interaction between the Python application and
MySQL database, enabling smooth data operations.

Project Goals

The primary goal of the AMS is to improve operational efficiency in


airline management while enhancing the passenger experience. By
automating key processes and integrating functionalities into a single
platform, the system aims to reduce manual errors, improve response
times, and foster customer loyalty.

Additionally, the project provides a valuable learning opportunity in


software development, database management, and user experience
design, preparing developers to tackle real-world challenges in the
aviation industry.

9
OBJECTIVES

The Airline Management System (AMS) is designed with several key


objectives aimed at enhancing the operational capabilities of airlines
and improving customer service. Here are the detailed objectives:

1. Optimize Flight Scheduling and Management:


o Automate flight scheduling processes to minimize human
error and improve efficiency in real-time flight tracking.
o Allow airline staff to easily modify flight details, manage
gate assignments, and respond to changes in schedules.
2. Simplify the Booking Process:
o Create an intuitive online booking interface for passengers
to easily search for flights, view availability, and make
reservations.
o Integrate a secure payment gateway to ensure safe and
seamless transactions during ticket purchases.
3. Enhance Passenger Experience:
o Develop a passenger management system that maintains
comprehensive profiles, including travel history,
preferences, and loyalty program information.
o Facilitate online check-in and boarding processes to reduce
wait times and enhance convenience for travelers.

10
EXISTING SYSTEM

The current systems used in airline management often rely on


outdated technologies and manual processes, leading to several
challenges:

1. Manual Booking Processes: Many airlines still utilize manual


entry for ticket bookings, resulting in errors and inefficiencies.
Passengers often face long wait times when booking through
customer service.
2. Disparate Systems: Airlines typically use multiple,
unintegrated applications for different functions (e.g., booking,
flight scheduling, customer service). This fragmentation creates
data silos and complicates operations.
3. Limited Data Analytics: Existing systems may lack robust
reporting tools, making it difficult for airlines to track
performance metrics and make data-driven decisions.
4. Inefficient Customer Service: Customer service often relies on
manual ticketing systems, leading to delays in response times
and decreased satisfaction for passengers.
5. Flight Management Challenges: Manual scheduling can lead
to discrepancies in flight statuses and inefficient gate
management, resulting in operational confusion.
6. Security Concerns: Legacy systems may not comply with the
latest security standards, increasing vulnerability to data
breaches.

11
PROPOSED SYSTEM

The proposed Airline Management System (AMS) is designed to


modernize and streamline airline operations through an integrated,
user-friendly platform. Key features include:

1. Integrated Booking System: A seamless online interface for


passengers to search for flights, make reservations, and process
secure payments.
2. Dynamic Flight Management: Real-time scheduling and
monitoring of flights, including automated notifications for
delays and gate changes.
3. Passenger Management: Comprehensive profiles for
personalized service, along with online check-in to enhance
convenience.
4. Customer Support: A ticketing system for managing inquiries
and complaints, coupled with feedback collection for service
improvement.
5. Reporting and Analytics: Tools for generating detailed reports
on sales and performance metrics, enabling data-driven
decision-making.
6. Security and Compliance: Robust data protection measures
and role-based access controls to safeguard sensitive
information.

12
HARDWARE REQUIREMENTS

Device name: lab34 Processor Intel(R) Core(TM) i5-10400 CPU @


2.90GHz 2.90 GHz
Installed RAM :8.00 GB (7.84 GB usable)
Device ID: D079782B-67EF-4F50-84DA-F87B0F686696
Product ID: 00331-10000-00001-AA707
System type :64-bit operating system, x64-based processor
Pen and touch: No pen or touch input is available for this display
SOFTWARE REQUIREMENTS
1. System Requirements

• Operating System:
o Windows, macOS, or Linux (depending on server
deployment preferences).

2. Programming Language:

• Python (using Flask or Django) or Java (using Spring Boot) for


server-side development.

3. Database Requirements

• Database Management System:


o MySQL: For relational data storage.
o Alternatively, PostgreSQL can be used for advanced data
handling.

13
E-R DIAGRAM

14
ABOUT PYTHON

Python is a high-level, interpreted programming language that


emphasizes code readability and simplicity. It was created by Guido
van Rossum and first released in 1991. Python has gained immense
popularity due to its versatility and ease of use, making it suitable for
a wide range of applications.

Key Features of Python

1. Simple Syntax:
o Python’s syntax is designed to be intuitive and
straightforward, allowing developers to express concepts
in fewer lines of code compared to other languages. This
readability makes it an excellent choice for beginners.
2. Interpreted Language:
o Python is an interpreted language, meaning code is
executed line-by-line at runtime. This allows for
immediate feedback and makes debugging easier.
3. Dynamic Typing:
o Python uses dynamic typing, which means variables do not
require explicit declaration. This flexibility speeds up
development but can lead to runtime errors if not carefully
managed.
4. Rich Standard Library:

15
o Python comes with a comprehensive standard library that
provides modules and functions for various tasks, such as
file I/O, system calls, and web programming, reducing the
need for external libraries.
5. Object-Oriented:
o Python supports object-oriented programming (OOP)
principles, allowing developers to create reusable code
through classes and objects.
6. Extensive Ecosystem:
o Python boasts a vast ecosystem of third-party libraries and
frameworks, including:
▪ Web Development: Django, Flask, FastAPI
▪ Data Science and Analysis: Pandas, NumPy, SciPy
▪ Machine Learning and AI: TensorFlow, Keras,
scikit-learn
▪ Game Development: Pygame
▪ Automation: Selenium, Beautiful Soup
7. Cross-Platform Compatibility:
o Python is platform-independent, meaning code can run on
various operating systems, such as Windows, macOS, and
Linux, without modification.
8. Community and Support:
o Python has a large and active community that contributes
to a wealth of tutorials, documentation, and forums. This

16
support makes it easier for new learners to find help and
resources.
9. Integration Capabilities:
o Python can easily integrate with other programming
languages like C, C++, and Java, allowing developers to
use existing libraries and tools within Python applications.
10. Growing Popularity:
o Python's popularity is continuously increasing, especially
in fields like data science, machine learning, web
development, and automation. It is widely taught in
educational institutions and is often the first language
introduced to programming students.

Conclusion

Python is a versatile and powerful language that caters to both


beginners and experienced developers. Its focus on readability,
combined with a rich ecosystem of libraries and frameworks, makes it
suitable for a broad range of applications, from web development to
data analysis and machine learning. As Python continues to grow in
popularity, it remains a valuable tool for anyone looking to engage in
software development or data science.

17
ABOUT DATABASE

A database is a systematic collection of data that enables efficient


storage, retrieval, and management of information. Databases are
essential for applications that handle large amounts of data, providing
a structured way to organize and manipulate that data.

Key Concepts

1. Data Models:
o Relational Model: Organizes data into tables (relations)
that can be linked or related based on data common to
each. Uses SQL for querying.
o NoSQL Models: Includes document (e.g., MongoDB),
key-value (e.g., Redis), wide-column (e.g., Cassandra),
and graph databases (e.g., Neo4j), each optimized for
different types of data and use cases.
2. Database Management Systems (DBMS):
o Software that facilitates the creation, manipulation, and
administration of databases. Examples include:
▪ Relational DBMS: MySQL, PostgreSQL, Oracle.
▪ NoSQL DBMS: MongoDB, Couchbase, Cassandra.
3. SQL (Structured Query Language):
o The standard language for interacting with relational
databases. SQL allows users to perform querying data,
updating records, and managing database schemas.

18
4. Transactions:
o A series of operations performed as a single unit.
Transactions ensure data integrity, adhering to the ACID
properties (Atomicity, Consistency, Isolation, Durability).
5. Data Integrity and Constraints:
o Mechanisms to ensure the accuracy and consistency of
data, including:
▪ Primary Keys: Unique identifiers for records.
▪ Foreign Keys: Establish relationships between
tables.
▪ Check Constraints: Rules that enforce data validity.
6. Indexes:
o Data structures that improve the speed of data retrieval
operations. They allow databases to quickly locate and
access specific rows in a table.
7. Backup and Recovery:
o Strategies for preserving data integrity and availability.
Regular backups protect against data loss, while recovery
plans ensure quick restoration in case of failures.

Types of Databases

1. Relational Databases:
o Store data in structured tables and use SQL for operations.
Ideal for structured data with complex relationships.
2. NoSQL Databases:

19
o Designed for unstructured or semi-structured data. They
provide flexibility in data models and are suited for large-
scale applications. Examples include:
▪ Document Stores: Store data in documents (e.g.,
MongoDB).
▪ Key-Value Stores: Use key-value pairs (e.g., Redis).
▪ Wide-Column Stores: Store data in rows and
columns but allow dynamic columns (e.g.,
Cassandra).
▪ Graph Databases: Optimize for relationships
between data points (e.g., Neo4j).
3. In-Memory Databases:
o Store data in RAM for fast access, ideal for real-time
applications. Example: Redis.
4. Time-Series Databases:
o Specialize in handling time-stamped data, commonly used
for monitoring and analytics. Example: InfluxDB.

Conclusion

Databases are foundational to modern applications, enabling efficient


management and utilization of data. By understanding the various
types of databases and their features, organizations can choose the
right solutions to meet their data needs, enhance operational
efficiency, and drive informed decision-making.

20
MODULES USED IN THE PROJECT
MODULE 1:

The module one is about the airline details. It contains details about
the aircraft number, type of flight, boarding point etc.

Programming language: Python, Mysql connector and Mysql.

Methods used: csv file, functions, for loop

MODULE 2:

The module 2 is about the passengers details. It contains passenger id,


name, age, gender, boarding point and nationality

Programming language: Python, Mysql connector and Mysql.

Methods used: functions, stack, for loop

MODULE 3:

The module 3 is about cabin crew details. It contains staff id,


staff name, shift time, salary etc

Programming language: Python, Mysql connector and Mysql.

Methods used: functions, python interface, for loop

21
CODING

MODULE 1:
def c():
import csv
l=[]
f=open("D:\\e.csv","r")
a=csv.reader(f)
for i in a:
l.append(i)
f.close()
return l
def m(x):
import mysql.connector as m
con1=m.connect(host="localhost",user="root",passwd="1234",database="air")
cur=con1.cursor()
for i in x:
print(i)
cur.execute("insert into stu values('{}','{}','{}')".format(i[0],i[1],i[2]))
con1.commit()
x=c()
m(x)
MODULE 2:
def database():
import mysql.connector as m
con1=m.connect(host="localhost",user="root",passwd="1234",database="air")
cur=con1.cursor()
a="create table Passengers(Pid varchar(10),PName varchar(10),AGE
varchar(20),Gendervarchar(10),Nationality varchar(30),Destination varchar(100),Class(20))"
cur.execute(a)
ans='yes'
while ans=='yes':
Pid=input("Enter the Pid:")
PName=input("name")
AGE=int(input("enter your age"))
gender=input("M/F")
Nationality=input("enter natioanlity")
class=input("eco/busi")
d1=[]
print("1.Mumbai, Chhatrapati Shivaji International Airport (BOM)")
print("2.Delhi, Indira Gandhi International Airport (DEL)")
print("3.Bengaluru, Kempegowda International Airport (BLR)")
print("4.Hyderabad, Rajiv Gandhi International Airport (HYD)")
print("5.Kolkata, Netaji Subhas Chandra Bose Airport (CCU)")
print("6.Chennai, Chennai Airport (MAA)")
choice=int(input("enter your destination"))
m="Mumbai, Chhatrapati Shivaji International Airport (BOM)"
d="Delhi, Indira Gandhi International Airport (DEL)"
b="Bengaluru, Kempegowda International Airport (BLR)"

22
h="Hyderabad, Rajiv Gandhi International Airport (HYD)"
k="Kolkata, Netaji Subhas Chandra Bose Airport (CCU)"
c="Chennai, Chennai Airport (MAA)"
if choice==1:
d1.append(m)
elif choice==2:
d1.append(d)
elif choice==3:
d1.append(b)
elif choice==4:
d1.append(h)
elif choice==5:
d1.append(k)
elif choice==6:
d1.append(c)
cur.execute("insert into
Passengersvalues('{}','{}',{},'{}','{}','{}’,’{}')".format(Pid,PName,AGE,gender,Nationality,d1[0],class))
d1.pop()
ans=input("Enter yes or no")
cur.execute("select * from Passengers")
data=cur.fetchall()
print(data)
con1.commit()
con1.close()
database()
MODULE 3:
def database():
import mysql.connector as m
con1=m.connect(host="localhost",user="root",passwd="1234",database="air")
cur=con1.cursor()
a="create table Cabin_crew12(cid varchar(10),Name varchar(10),shift
varchar(20),airidvarchar(10))"
cur.execute(a)
ans='y'
while ans=='y':
cid=input("Enter the cid:")
Name=input("name")
sf=input("shift")
airid=input("air id:")
cur.execute("insert into Cabin_crew12values('{}','{}','{}','{}')".format(cid,Name,sf,airid))
ans=input("Enter y or n")
cur.execute("select * from Cabin_crew12")
data=cur.fetchall()
print(data)
con1.commit()
con1.close()
database()

23
OUTPUT SCREEN
MODULE1:
IN PYTHON:
['Arunachal Pradesh', '2', 'NULL']
['Assam', '5', '1']
['Bihar', '1', 'NULL']
['Chhattisgarh', '1', 'NULL']
['Goa', 'NULL', '2']
['Gujarat', '7', '4']
['Haryana', 'NULL', '1']
['Himachal Pradesh', '3', 'NULL']
['Jharkhand', '2', 'NULL']
['Karnataka', '4', '2']
['Kerala', '2', '4']
['Madhya Pradesh', '4', '1']
['Maharashtra', '5', '5']
['Manipur', 'NULL', '1']
['Meghalaya', '1', 'NULL']
['Mizoram', 'NULL', 'NULL']
['Nagaland', '1', 'NULL']
['Odisha', '3', '1']
['Punjab', '4', '1']
['Rajasthan', '5', '1']
['Sikkim', '1', 'NULL']
['Tamil Nadu', '3', '3']
['Telangana', '1', '1']
['Tripura', '1', 'NULL']
['Uttarakhand', '2', 'NULL']
['Uttar Pradesh', '11', '4']
['West Bengal', '3', '2']

24
IN MYSQL:

25
MODULE 2:
IN PYTHON
Enter the Pid:Jk12hL
nameShankar
enter your age30
M/FM
enter natioanlityIndia
eco/busibusi
1.Mumbai, Chhatrapati Shivaji International Airport (BOM)
2.Delhi, Indira Gandhi International Airport (DEL)
3.Bengaluru, Kempegowda International Airport (BLR)
4.Hyderabad, Rajiv Gandhi International Airport (HYD)
5.Kolkata, Netaji Subhas Chandra Bose Airport (CCU)
6.Chennai, Chennai Airport (MAA)
enter your destination3
Enter yes or noyes
Enter the Pid:Abk7h1
NameJames
enter your age21
M/FM
enter natioanlityRussia
eco/busibusi
1.Mumbai, Chhatrapati Shivaji International Airport (BOM)
2.Delhi, Indira Gandhi International Airport (DEL)
3.Bengaluru, Kempegowda International Airport (BLR)
4.Hyderabad, Rajiv Gandhi International Airport (HYD)
5.Kolkata, Netaji Subhas Chandra Bose Airport (CCU)
6.Chennai, Chennai Airport (MAA)
enter your destination2
Enter yes or noyes
Enter the Pid:Xxdy5r
nameCeline
enter your age42
M/FF
enter natioanlityUS
eco/busieco
1.Mumbai, Chhatrapati Shivaji International Airport (BOM)

26
2.Delhi, Indira Gandhi International Airport (DEL)
3.Bengaluru, Kempegowda International Airport (BLR)
4.Hyderabad, Rajiv Gandhi International Airport (HYD)
5.Kolkata, Netaji Subhas Chandra Bose Airport (CCU)
6.Chennai, Chennai Airport (MAA)
enter your destination6
Enter yes or noyes
Enter the Pid:DHI89h
nameVijay
enter your age50
M/FM
enter natioanlityIndia
eco/busieco
1.Mumbai, Chhatrapati Shivaji International Airport (BOM)
2.Delhi, Indira Gandhi International Airport (DEL)
3.Bengaluru, Kempegowda International Airport (BLR)
4.Hyderabad, Rajiv Gandhi International Airport (HYD)
5.Kolkata, Netaji Subhas Chandra Bose Airport (CCU)
6.Chennai, Chennai Airport (MAA)
enter your destination4
Enter yes or noyes
Enter the Pid:Rgj7kj
nameRose
enter your age27
M/FF
enter natioanlityKorea
eco/busibusi
1.Mumbai, Chhatrapati Shivaji International Airport (BOM)
2.Delhi, Indira Gandhi International Airport (DEL)
3.Bengaluru, Kempegowda International Airport (BLR)
4.Hyderabad, Rajiv Gandhi International Airport (HYD)
5.Kolkata, Netaji Subhas Chandra Bose Airport (CCU)
6.Chennai, Chennai Airport (MAA)
enter your destination1
Enter yes or noyes
Enter the Pid:Aj8kUk
nameAbinithi

27
enter your age18
M/FF
enter natioanlityIndia
eco/busibusi
1.Mumbai, Chhatrapati Shivaji International Airport (BOM)
2.Delhi, Indira Gandhi International Airport (DEL)
3.Bengaluru, Kempegowda International Airport (BLR)
4.Hyderabad, Rajiv Gandhi International Airport (HYD)
5.Kolkata, Netaji Subhas Chandra Bose Airport (CCU)
6.Chennai, Chennai Airport (MAA)
enter your destination1Enter yes or noyes
Enter the Pid:Bjh9rk
nameSarah
enter your age65
M/FF
enter natioanlityAUS
eco/busieco
1.Mumbai, Chhatrapati Shivaji International Airport (BOM)
2.Delhi, Indira Gandhi International Airport (DEL)
3.Bengaluru, Kempegowda International Airport (BLR)
4.Hyderabad, Rajiv Gandhi International Airport (HYD)
5.Kolkata, Netaji Subhas Chandra Bose Airport (CCU)
6.Chennai, Chennai Airport (MAA)
enter your destination2
Enter yes or nono
[('Jk12hL', 'Shankar', '30', 'M', 'India', 'Bengaluru, Kempegowda
International Airport (BLR)',’busi’), ('Abk7h1','James', '21', 'M',
'Russia', 'Delhi, Indira Gandhi International Airport (DEL)',’busi’),
('Xxdy5r', 'Celine', '42', 'F','US', 'Chennai, Chennai Airport
(MAA)',’eco’), ('DHI89h', 'Vijay', '50', 'M', 'India', 'Hyderabad, Rajiv
Gandhi International Airport (HYD)',’eco’), ('Rgj7kj', 'Rose', '27', 'F',
'Korea', 'Mumbai, Chhatrapati Shivaji InternationalAirport
(BOM)',’busi’), ('Aj8kUk', 'Abinithi', '18', 'F', 'India', 'Mumbai,
Chhatrapati Shivaji International
Airport(BOM)',’busi’), ('Bjh9rk', 'Sarah', '65', 'F', 'AUS', 'Delhi, Indira
Gandhi International Airport (DEL)',’eco’)]

28
IN MYSQL:

MODULE 3:
IN PYTHON:
Enter the cid:0034h9678
nameRobin
shift15
air id:N904DE
Enter y or ny
Enter the cid:2300GH678
nameHarshini
shift30
air id:JA8089
Enter y or ny
Enter the cid:6789fh5679
nameShamita
shift12
air id:N8642E
Enter y or ny
Enter the cid:231256jk909
nameSimran
shift13

29
air id:N425HB
Enter y or ny
Enter the cid:1234hg7754
nameRavi
shift15
air id:N721AF
Enter y or ny
Enter the cid:1234GH898
nameSahana
shift20
air id:N721EB
Enter y or ny
Enter the cid:5647JK909
nameAbi
shift15
air id:N930NN
Enter y or ny
Enter the cid:5679KI8890
nameAshwath
shift18
air id:N236MJ
Enter y or nn
[('0034h9678', 'Robin', '15', 'N904DE'), ('2300GH678', 'Harshini', '30',
'JA8089'), ('6789fh5679', 'Shamita','12', 'N8642E'), ('231256jk909',
'Simran', '13', 'N425HB'), ('1234hg7754', 'Ravi', '15',
'N721AF'),('1234GH898', 'Sahana', '20', 'N721EB'), ('5647JK909',
'Abi', '15', 'N930NN'), ('5679KI8890', 'Ashwath','18', 'N236MJ')]

30
IN MYSQL:

31
FURTHER DEVELOPMENT & CONCLUSION

FURTHER DEVELOPMENT:

To enhance the airline management system, future development


could focus on integrating advanced data analytics and machine
learning algorithms to optimize operations. By analyzing passenger
data and flight patterns, airlines could improve scheduling efficiency
and enhance customer experience through personalised services.
Additionally, incorporating real-time tracking and predictive
maintenance for aircraft would minimize delays and increase safety.
Expanding the system to include mobile applications could also
facilitate seamless check-ins and customer support, fostering a more
user-friendly interface.

CONCLUSION:

In conclusion, an effective airline management system is


crucial for optimizing operations and improving customer
satisfaction. By leveraging technology and data analytics, airlines can
streamline their processes, enhance safety, and provide a more
personalised experience for travelers. Continued development in these
areas will not only improve operational efficiency but also position
airlines to better adapt to the evolving landscape of the aviation
industry. Emphasizing innovation and customer-centric solutions will
be key to achieving long-term success in airline management.
32
BIBLOGRAPHY

https://www.python.org/doc/essays/blurb/?external_link=true

https://www.python.org/doc/essays/blurb/?external_link=true

https://en.wikipedia.org/wiki/List_of_airports_in_India

https://github.com/AAdewunmi/Airline-Management-System

https://www.kaggle.com

33
.

34

You might also like