AIRLINE

RESERVATION
SYSTEM

Roll no. …………………………

A Project Report
On

AIRLINE RESERVATION SYSTEM

For
AISSCE 2020 Examination
[As a part of the COMPUTER SCIENCE Course(new) (083)]

BY
SAURAV SHIWAL

Under the Guidance of:

Mrs.NidhiGoelPGT (CS)
CERTIFICATE
This is to certify that the Project entitled AIRLINE RESERVATION

SYSTEM is a bonafide work done by SAURAV SHIWALof class XII

Session 2019-20 in partial fulfillment of CBSE’s AISSCE Examination 2020

and has been carried out under my direct supervision and guidance. This

report or a similar report on the topic has not been submitted for any other

examination and does not form a part of any other course undergone by

the candidate.

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

Signature of Student Signature of Teacher

{SAURAV SHIWAL} {Mrs. Nidhi Goel
}

Designation: PGT – CS

………………………………………………

{Signature of Principal}

Date………….……

Roll no. …………..

ACKNOWLEDGEMENT

I undertook this Project work, as the part of my XII-

Computer Science (new). I had tried to apply my best of
knowledge and experience, gained during the study and class
work experience. However, developing software system is
generally a quite complex and time-consuming process. It
requires a systematic study, insight vision and professional
approach during the design and development. Moreover, the
developer always feels the need, the help and good wishes of the
people near you, who have considerable experience and idea.

I would like to extend my sincere thanks and gratitude to our

Principal .I am very much thankful to my teacher
Mrs.NidhiGoel. For giving valuable time and moral support to
develop this software.

SAURAV SHIWAL
Class XII [ COMPUTER SCIENCE]
CONTENTS

1. Introduction ------------------------------------------------

2. Objective & Scope of the Project -----------------

3. Problem Definition & Analysis ---------------------

4. Source Code-------------------------------------------------

5. Output Produced------------------------------------------

6. Bibliography ------------------------------------------------
1. Introduction

This software project is developed to automate the functionalities of

Airline Reservation System. The purpose of the software is to develop a

Management Information System (MIS) to automate the process of

reservation in airlines, from registering customers to final billing.

This software, being simple in design and working, does not require

much of training to users, and can be used as a powerful tool for

automating a Big Airline System.

During coding and design of the software Project, Python Spyder IDE, a

powerful front-end tool is used for getting integrated platform and

coding simplicity. As a back-end a powerful, open source RDBMS,

MySQL is used as per requirement of the CBSE curriculum of Computer

Science Course (New).

2.Objective & Scope of the
Project
The objective of the software project is to develop a
computerized MIS to automate the functions of a Airline
reservation system and to save our time .This software project is
also aimed to enhance the current record keeping system, which
will help managers to retrieve the up-to-date information at right
time in right shape.
The proposed software system is expected to do the following
functionality-
 To provide a user friendly integrated and centralized
environment for MIS activities.
 The proposed system should maintain all the records and
transactions, and should generate the required reports and
information when required.
 To provide user-friendly interface to interact with a
centralized database based on client-server architecture.
 To identify the critical operation procedure and possibilities
of simplification using modern IT tools and practices.
 .
During the development of airline management project, Python
Spyder IDE, a powerful, open source event-driven form-based
development environment is used for modular design and future
expandability of the system.
Despite of the best effort of the developer, the following
limitations and functional boundaries are visible, which limits the
scope of this application software.
1. This software can store records and produce reports in pre-
designed format in soft copy. There is no facility yet to
produce customized reports. Only specified reports are
covered.
2. So far as future scope of the project is concerned, firstly it is
open to any modular expansion i.e. other modules or
functions can be designed and embedded to handle the user
need in future. Any part of the software and reports can be
modified independently without much effort.
3. Problem Definition &
Analysis

The hardest part of building a software system is deciding precisely

what to build. No other part of the conceptual work is so difficult as
establishing the detailed technical requirement. Defining and
applying good, complete requirements are hard to work, and success
in this endeavor has eluded many of us. Yet, we continue to make
progress.

Problem definition describes the What of a system, not How. The

quality of a software product is only as good as the process that
creates it. Problem definition is one of the most crucial steps in this
creation process. Without defining a problem, developers do not
know what to build, customers do not know what to expect, and there
is no way to validate that the built system satisfies the requirement.

Problem definition and Analysis is the activity that encompasses

learning about the problem to be solved, understanding the needs of
customer and users, trying to find out who the user really is, and
understanding all the constraints on the solution. It includes all
activities related to the following:

 Identification and documentation of customer’s or user’s needs.

 Creation of a document that describes the external behavior and
the association constraints that will satisfies those needs.
 Analysis and validation of the requirements documents to
ensure consistency, completeness, and feasibility
 Evolution of needs.
After the analysis of the functioning of a AIRLINE RESERATION
SYSTEM, the proposed System is expected to do the following: -

 To provide a user friendly based integrated and centralized

environment for an Airline.

 The proposed system should maintain all the records and

transactions, and should generate the required reports and
information when required.

 To provide efficient and secured Information storage, flow and

retrieval system, ensuring the integrity and validity of records.

 To provide user-friendly interface to interact with a centralized

database based on client-server architecture.
To identify the critical operation procedure and possibilities of
simplification using modern IT tools and practices
4.SOURCE CODE
import os

import platform

import mysql.connector

global z

global s

global userinput

db=mysql.connector.connect(user='root',passwd='root',host='localhost',
database='airline')

mycursor=db.cursor()

try:

mycursor.execute("CREATE TABLE IF NOT EXISTS pdata (custname

varchar(20),addrvarchar(30),jrdatedate,sourcevarchar(10),destin
ation varchar(10))" )

except:

pass

try:

mycursor.execute("CREATE TABLE IF NOT EXISTS

classtype(snovarchar(5),classtype varchar(10),price
integer(10))")

except:

pass
try:

mycursor.execute("CREATE TABLE IF NOT EXISTS food

(sno integer(10),itemname varchar(10),rate integer(10))")

except:

pass

try:

mycursor.execute("CREATE TABLE IF NOT EXISTS luggage

(sno integer(10),weight varchar(10),rate integer(10))")

except:

pass

def insertclasstype(sno, classtype, price):

mySql_insert_query = """INSERT INTO classtype (sno, classtype,

price)VALUES (%s, %s, %s) """

classtypetuple = (sno, classtype, price)

mycursor.execute(mySql_insert_query, classtypetuple)

db.commit()

insertclasstype('1','Firstclass',6000)

insertclasstype('2','Busiclass',4000)

insertclasstype('3','Ecoclass',2000)

definsertfood(sno, itemname, rate):

mySql_insert_query = """INSERT INTO food (sno, itemname, rate)

VALUES (%s, %s, %s) """

foodtuple = (sno, itemname, rate)

mycursor.execute(mySql_insert_query, foodtuple)

db.commit()

insert food(1,"tea",10)

insert food(2,"coffee",10)

insert food(3,"colddrink",20)

insert food(4,"samosa",10)

insert food(5,"sandwich",50)

insert food(6,"Dhokla",30)

insert food(7,"kachori",10)

insert food(8,"milk",20)

insert food(9,"noodles",50)

insert food(10,"pasta",50)

def insert luggage(sno, weight, rate):

mySql_insert_query = """INSERT INTO luggage (sno, weight, rate)

VALUES (%s, %s, %s) """

Luggage tuple = (sno, weight, rate)

mycursor.execute(mySql_insert_query, luggagetuple)

db.commit()

insert luggage(1,"0kg",0)
insert luggage(2,"20kg",1000)

insert luggage(3,"25kg",1250)

insert luggage(4,"30kg",1500)

insert luggage(5,"50kg",2500)

def registercust():

L=[]

name=input("Enter Name:")

L.append(name)

addr=input("Enter Address:")

L.append(addr)

jr_date=input("Enter Date of Journey:")

L.append(jr_date)

source=input("Enter Source:")

L.append(source)

destination=input("Enter Destination:")

L.append(destination)

cust=(L)

sql="insert into
pdata(custname,addr,jrdate,source,destination)values(%s,%s,%s,
%s,%s)"

mycursor.execute(sql,cust)
db.commit()

def classtypeview():

print("Do you want to see classs types available? (Enter 1 for

Yes)")

ch=int(input("Enter Your Choice:"))

if ch==1:

sql="select * from classtype"

mycursor.execute(sql)

rows=mycursor.fetchall()

for x in rows:

print(x)

def ticketprice():

print("We have the following Classes for you:-")

print("1.Type First Class----> Rs6000\-")

print("2.Type Business Class----> Rs4000\-")

print("3.Type Economy Class----> Rs2000\-")

x=int(input("Please Enter Your Choice:"))

n=int(input("No. of passengers:"))

if(x==1):

print("You have opted First Class")

s=6000*n

elif(x==2):
print("You have opted Business Class")

s=4000*n

elif(x==3):

print("You have opted Economy Class")

s=2000*n

else:

print("Please choose a Class Type")

print("Your room rent is=",s,"\n")

def menuview():

print("Do you want to see the Menu available? (Enter 1 for Yes)")

ch=int(input("Enter your choice:"))

if ch==1:

sql="select * from food"

mycursor.execute(sql)

rows=mycursor.fetchall()

for x in rows:

print(x)

def orderitem():

global s

print("Do you want to see Menu available? (Enter 1 for Yes):")

ch=int(input("Enter your choice:"))

if ch==1:

sql="select * from food"

mycursor.execute(sql)

rows=mycursor.fetchall()

for x in rows:

print(x)

print("Do you want to purchase from above list? (Enter your

choice):")

d=int(input("Enter your choice:"))

if(d==1):

print("You have ordered Tea")

a=int(input("Enter quantity:"))

s=10*a

print("Your amount for Tea is:",s,"\n")

elif(d==2):

print("You have ordered Coffee")

a=int(input("Enter quantity:"))

s=10*a

print("Your amount for Coffee is:",s,"\n")

elif(d==3):

print("You have ordered Cold drink")

a=int(input("Enter quantity:"))

s=20*a

print("Your amount for Cold drink is:",s,"\n")

elif(d==4):

print("You have ordered Samosa")

a=int(input("Enter quantity:"))

s=10*a

print("Your amount for Samosa is:",s,"\n")

elif(d==5):

print("You have ordered Sandwich")

a=int(input("Enter quantity:"))

s=50*a

print("Your amount for Sandwich is:",s,"\n")

elif(d==6):

print("You have ordered Dhokla")

a=int(input("Enter quantity:"))

s=30*a

print("Your amount for Dhoklais:",s,"\n")

elif(d==7):

print("You have ordered Kachori")

a=int(input("Enter quantity:"))

s=10*a
print("Your amount for Kachoriis:",s,"\n")

elif(d==8):

print("You have ordered Milk")

a=int(input("Enter quantity:"))

s=20*a

print("Your amount for Milk is:",s,"\n")

elif(d==9):

print("You have ordered Noodles")

a=int(input("Enter quantity:"))

s=50*a

print("Your amount for Noodles is:",s,"\n")

elif(d==10):

print("You have ordered Pasta")

a=int(input("Enter quantity:"))

s=50*a

print("Your amount for Pasta is:",s,"\n")

else:

print("Please enter your choice from the menu")

def luggagebill():

global z

print("Do you want to see rate for luggage? (Enter 1 for Yes)")
ch=int(input("Enter your choice:"))

if ch==1:

sql="select * from luggage"

mycursor.execute(sql)

rows=mycursor.fetchall()

for x in rows:

print(x)

y=int(input("Enter Your weight of extra luggage:"))

z=y*50

print("Your Luggage Bill:",z,"\n")

return z

def lb():

print(z)

def res():

print(s)

def ticketamount():

a=input("Enter Customer Name:")

print("Customer Name:",a,"\n")

print("Luggage Bill:")

print(lb())

print("Food Bill:")

print(res())
print('===================================================
====')

print(" Welcome to the Airline Reservation System ")

print('===================================================
====')

def Menuset():

print("Enter 1:To enter Customer Data")

print("Enter 2:To view Class")

print("Enter 3:For ticket Amount")

print("Enter 4:For viewing Food Menu")

print("Enter 5:For Food Bill")

print("Enter 6:For Luggage Bill")

print("Enter 7:For Complete Amount")

print("Enter 8:To Exit:")

def Main():

global userinput

Menuset()

userinput=int(input("Please select from above options:"))

def choice():

if(userinput==1):

registercust()

elif(userinput==2):
classtypeview()

elif(userinput==3):

ticketprice()

elif(userinput==4):

menuview()

elif(userinput==5):

orderitem()

elif(userinput==6):

luggagebill()

elif(userinput==7):

ticketamount()

elif(userinput==8):

quit()

else:

print("Enter correct Choice")

Main()

try:

Main()

choice()

except ValueError:

exit("\n Hi, that's not a number")

def runagain():
runagn=input("\n Want to run again Y/N:")

while runagn=='Y' or runagn=='y':

if(platform.system()=="windows"):

print(os.system('cls'))

else:

print(os.system('clear'))

Main()

choice()

runagn=input("\n Want to run again Y/N:")

runagain()
OUTPUT
1. Output after running program

2. To enter customer data

3. To view class

4. For ticket amount

5. For viewing food menu
6. For food bill
7. For luggage bill

8. For complete amount

SQL TABLES

1. Data in pdata

2. Data in classtype
3. Data in food

4. Data in luggage
6.Bibliography

In order to work on this project titled AIRLINE RESERVATION SYSTEM,

the following books and literature are referred by me during the various phases of
development of the project.

(1) https://www.python.org/

(2) On-line Help of Spyder.

(3) Computer Science (new) for class XII by Sumita Arora.

(4) Various Websites of Discussion Forum and software development activities.

(5) https://www.mysql.org/

Other than the above-mentioned books, the suggestions and supervision of my

teacher and my class experience also helped me to develop this software project.