Free Essay

Airline Reservation System

In:

Submitted By soni90
Words 4969
Pages 20
Project on AIRLINE RESERVATION SYSTEM

[pic]

ACKNOWLEDGEMENT

I would like to take this opportunity to express my gratitude towards all the people who have in various ways, helped in the successful completion of my project.

I must convey my gratitude to Ms. …………… for giving me the constant source of inspiration and help in preparing the project, personally correcting my work and providing encouragement throughout the project.

I also thank all my faculty members for steering me through the tough as well as easy phases of the project in a result oriented manner with concern attention.

[pic]

CERTIFICATE

This is to certify that this is a bona fide record to the project work done satisfactorily at JIMS by …….. .of... Vth Semester.

This report or the similar report on this topic has not been submitted for any other examination and does not form part of any other course undergone by the candidate.

Signature of Project Guide

Name: Sunita Bawari

CONTENTS

PROBLEM DEFINATION [pic]

2. FEASIBILITY STUDY

o ECONOMIC FEASIBIITY

o TECHNICAL FEASIBILITY

o OPERATIONAL FEASIBILITY.

3. SYSTEM ANALYSIS

4. BLOCK DIAGRAM

5. DATA COLLECTION

6. SYSTEM DESIGN

o E-R DIAGRAM o DATA FLOW DIAGRAM o INPUT SCREEN o REPORTS o TABLES.

7. Coding

8. SYSTEM IMPLEMENTATION

9. TESTING AND DEBUGGING

10. CONCLUTION

11.SCOPE OF IMPROVEMENT

PROBLEM DEFINITION

The definition of our problem lies in manual system and a fully automated system.

Manual system : The system is very time consuming and lazy. This system is more prone to errors and sometimes the approach to various problems is unstructured.

Technical system : With the advent of latest technology if we do not update our system then our business result in losses gradually with time. The technical systems contains the tools of latest trend i.e. computers printers, fax, Internet etc. The systems with this technology are very fast, accurate, user-friendly and reliable.

.

Need of Airlines system

A few factors that directs us to develop a new system are given below -:
1) Faster System
2) Accuracy
3) Reliability
4) Informative
5) Reservations and cancellations from any where to any place

FEASIBILITY STUDY

Feasibility study is to check the viability of the project under consideration. Theoretically various types of feasibilities are conducted, but we have conducted three type of feasibilities explained as under.

ECONOMIC FEASIBILITY
With the manual system the operating cost of the system is about 60 Lacks P.A.. This cost comprises salary of 25 people, stationary, building rent, electricity, water, telephone etc. But with the new system this reoccurring cost comes out to be about 20 Lacks P.A. Hence the new system is economically feasible.

TECHNICAL FEASIBILITY
The new system requires only 6 trained person to work with the system and in overall 10 people per office are sufficient. So we will identify 6 best people from existing system and train them.

As our existing system is purely manual, so we need a one time investment of Rs 4 Laks for the purchase of 7 computers, 5 Ticket printers, a laser printer, AC and networking etc. It requires 20 Lacks PA as a operating cost.

With the above details our system is technically feasible as after investing 24 Lacks in a year, the company is still saving Rs 25 Lacks PA.

OPERATIONAL FEASIBILITY

The new solution is feasible in all sence but operationally it is not. The new system demands the expulsion of at least 15 people from the company. It creates an environment of joblessness and fear among the employees. It can lead to an indefinite strike in the company also. So the management must take corrective actions prior in advance in order to start the further proceedings.

SYSTEM ANALYSIS

This was the most important phase of my project life cycle .It had connected my maximum time .The block diagram given bellow depict various fact which were understood by one during the analysis phase.

BLOCKDIAGRAM

In that phase initially I had observed the system by visiting to Indiragandhi Airport(domestic terminal) and a few airline reservation agency.
Pardes Airline agencies , Lotus Airline agencies.

The above block diagram is an implementation of this observation .

In the next phase I had various quiries in my mind ,Which I tried to ask from appropriate authorities A sample of my quires is enclosed as Annex 1.

Q.1 Tick mark the features to be included in the new system? • Enquiry • Reservation • Cancellation • Report • Edit • Other specify

Q2. Tick mark that the system should be ?

• Multi-user • Single user

Q3. Tick marks the total time required for the implementation of the project? • 3 months • 6 months • 9 months • Others specify

Q4. Tick mark the reports to be Incorporated? • List of all passenger • List of all flights • List of passenger(date wise) • List of passenger(flight wise) • Any other

After getting solution my queries I started studying database structure used in the existing system . In this connection I had come to know about various master files as

In passenger list : Passenger name,Address , tel_no , d_o_b, profession father name,

Fleet info: No aircraft, club_pre_capacity, economic capacity, engine type,cruisespeed,air length,

Flight info: f_name, f_code, c_code,t_exeseat no, t_economic seat no.

Concession: concession name , concession code , class , discount , v_o_t , baggage allowance , fare.

Move of payment: Passenger code ,Date of paid ,Current date, cash, Debit,cheque,credit.

Fare: route , destination place ,source place ,Departure time, Arrival time,Flight code,class,Fare.

Reservation: Ticket report, PNR, flight code, destination place, source place, departure time arrival time , Class, number of passenger, Age, sex, Fare, seat .

Enquiry: Ticket no, seat number , pnr.

Cancellation : Pnr, ticket no, Days left, Basic amount, Cancel amount .

Various categories of flight code are display here CD455,IC548,IC7896,IC567,CD445
Flight schedule - gau to del 12.33 pm to2.33 pm

In this process further I had visited the air port again in order to INTER VIEW people to know more about the system The main purpose was To analyses the method of calculating daily in come reservation cost generation methods, and few concern things. Duty schedule .

4.SYSTEM DESIGN

In this phase initially I had designed E-R diagram of the processes , in order to identify various entities and relation ship set ,entity set ,attributers, link attributes The Diagram of this process as under. After this step We had tried design the data base for the new system and normalized it
The tables motivated in data dictionaries enclosed as annex II is an out come of this step

The symbol of entities are shown bellow

E-R DIAGRAM FOR BOOKING DEPARTMENT

E-R DIAGRAM FOR CANCELLATION

DATA FLOW DIAGRAM

In order to design a better solution. I had designed the DFD for system including all technical processing details is given bellow

LEVEL 0 DATA FLOW DIAGRAM

LEVEL 1 DATA FLOW DIAGRAM OF GENERAL ENQUIRY SYSTEM

LEVEL 1 DATA FLOW DIAGRAM OF PASSENGER ENQUIRY

SECTION

LEVEL 2 DFD OF BOOKING

LEVEL 2 DFD OF CANCELLATION

ALGORITHM

In this phase further I had designed algorithms for various technical sub problem a few than are enclosed here with.
RESERVATION

• A PERSON COME TO RESERVED ATICKET.

• THEN HE GIVES HIS FULL DETAILS

• IN CUSTOMER FORM THOSE DETAILS WERE WRITTEN.

• THEN COMPUTER CHEQUE THE DATE WHAT DATE THE PERSON RESER VED

• DATE WISE IT CHEQUE THE FLIGHTS

• IF THE FLIGHT IS FLING THAT DAY

• THEN SYSTEM JUSTIFY THE SPECIFIC FLIGHT ID

• IT CHEQUE ITS SEAT CLASS.

• IF THE PASSENGER WANT TO ECONOMIC CLASS AND WINDOW SIDE SEAT

• THEN SYSTEM CHEQUE IF THERE ANY SEAT IN ECONOMIC CLASS WHICH IS INSIDE THE WINDOW

• IF SEAT IS EMPTY THEN SYSTEM RESERVED THE SEAT .

• THEN TICKET IS GENERATED.

• THE TICKET IS CONFIRMED.

• IF THE CONDITION IS NOT APPLIED THEN IT CHEQUE NEXT SEAT

• AND JUSTIFIED IT .

• IF IT IS NOT ALSO EMPTY THEN IT CHEQUE NEXT BY NEXT.

• IF THERE IS NO SEAT THEN SYSTEM TAKE TICKET WHICH IS NOT CONFIRMED

• THEN IT GIVE WAITING LIST.

• END.
CANCELLATION

• A PASSENGER COME TO CANCEL THE TICKET

• THEN THE SYSTEM OPEN THE DELET FORM

• THEN CLICK SHOE COMMAND

• IT DISPLAY ALL THE PASSENGER LIST

• THEN SELECT THE PNR NUMBER AND CLICK DELET OPTION

• THE SYSTEM SHOW RECORD IS DELETED.

WHEN PASSENGER COME TO RESERVED A TICKET THEN SYSTEM FIND OUT THE FLIGHT DETAILS.

SYSTEM CLICK FLIGHT DETAILS OPTION THEN THE FLIGHT DETAILS FORM OPEN

THOSE SYSTEM ARE FOLLOWED .

FLIGHT_DETALS:-

• . IN FLIGHT DEAILS WE FIRST CREATE A FORM.

• . THEN WE MAKE ALL TEXT BOX.

• . WE CREATE COMMAN BOX.. • . IN THIS FORM WE ARE USE VARIOUS COMMAND BOX THOSE ARE

• PREVIOUS,FIRST,NEXT, ADD,NEW,UPDATE, DELETE, SAVE

• . IN THIS FORM WE ADD NEW FLIGHT RECORD AND UPDATE IT THEN THE

• VALU IS GO TO THE DATABASE.

• .WHEN WE CLICK NEXT , LAST , PREVIOUS, FIRST COMMAND BUTTON

• THEN IT SHOW VARIOUS THING SERIALLY.

• A PERSON COME TO KNOW THE TIMMINGS FOR THE FLIGHT WHICH IS GO

FROM DELHI TO GAU.

• THEN WE CLICK SHOW COMMAND BUTTON.

CONCESSION

• FIRST IT CLICK THE CONCESSION BOX.

• CONCESSION BOX OPEN

• IT SELCT THE CETEGORI.

• THEN IT IS CALCULATE.

• AND THE FARE IS CALCULATE.

• THEN FINAL FARE IS GENERATE IN TICKET.

INPUT SCREEN

As a last step in design phase I had designed various Input and out put inter phase screen .The sample format of this screens is enclosed in annex III..

THIS IS A PICTURE OF THE MAIN MENU.

[pic]

In this picture there are three parts . Those are master file, ticket , report,
When we click in master file then it show six forms those are custodial , concession
Flight info , fleet info, fare ,payment . when we click any one of this then the form is
Open. Now we open each file one by one.

THIS IS A FORM OF CUSTOMER DETAIL

[pic]

In this form we enter the customer detail. When we enter the new name then we click add button and then update .Then it is automatically update .This is under master file. In this form first button work for show first record ,next button work for show next record. Preview show the just preview record.

THIS IS A FORM OF CONCESSION

[pic]

In this form there are several concession type are shown.
Those concessions are 1.Student 2.Senior citizen. 3.Cancer patient. 4. Blind passenger. 5. Armed force. 6.Youth fare. 7. Locomotor When we click any one of them the relevant condition are open. In this form when we click locomotor category then it show its conditions • code ………..7 • class………….economic • discount………50% • v_o_t………….1 year • baggage allowance..20kg • fare basis ………….service concerned.

THIS IS A FORM OF FLIGHT INFORMATION

[pic]

In this form we are watching the flight information .It has several fields those are • Flight name • Flight code • Class code • Class name • Total seat number.

In this form we enter the flight detail .When we enter the new flight then we click add button and then update .Then it is automatically update .This is under master file.
In this form first button work for show first record ,next button work for show next record. Preview show the just preview record

THIS IS A FORM OF FLEET INFORMATION.

[pic]

Fleet information is a special type of form in this form there are some field are include .In db como1 list of flight are coming when we click in run time. In fleet information there are basic type of flights those are

737-400 737-500 Clube pre capacity……….00 737-700 Economic capacity…………62 737-800 Engine type…………………PW127F 900. Cruisespeed…………………511km/hr Air length……………………27.17N Wing spam………………….27.0 N

THIS IS A FORM OF THE ROUTE BASIS FARE.

[pic]

This is a form of fare in this fare form there are various fields those are • Route • S_place • D_place • Via • D_time • A_time • Stoppage • Flight_code • Class_code • Fare
In this form we enter the fare detail .When we enter the new fare then we click add button and then update .Then it is automatically update .This is under master file.In this form first button work for show first record ,next button work for show next record. Preview show the just preview record

THIS IS A FORM OF RESERVATION.

[pic]

This is reservation form or ticket .PNR number are generated automatically .When click passenger age then fare is coming by the route based. When we click total button then total fare is shown. When we click in Print command button then the ticket is print. And when we click in exit button then the form is closed.

THIS FORM IS ENQUIRY.

[pic]

This is a form of ENQUIRY . If any person come to AIRPOART want to know that its seat reserved or not Then system open the enquiry form and put the value of ticket no and click confirm box .If it is confirmed then it show value of the all concerning data . Either show not confirmed.

THIS IS A CANCELLATION FORM.

[pic]

This is a form of cancellation .When a person come to cancel his ticket then ,in the form the passenger code are put and click the show button system will show the value of data and refund amount. Then click on the cancel command. Then automatically the record is deleted.

CONCESSION REPORT ARE SHOWN BELLOW.

[pic]

This is report of concession .Various type of concession category are shown upper.

THIS IS A REPORT OF CUST DETAIL.

[pic]

When we put passenger detail in passenger record then it is automatically set in report list.

THIS IS FLEET INFORMATION REPORT.

[pic]

THIS IS A REPOT OF ALL FLIGHT.

[pic]

TABLES
THE LIST OF TABLE ARE WRITTEN HERE WHICH ARE USED IN DATABASE.
CUST_DETAIL

|FIELD TYPE |TYPE |DESCRIPTION |
|T _DATE |TEXT |TRAVEL DAT |
|CUST_NAME |TEXT |CUSTOMER NAME |
|FATHER _NAME |TEXT |CUSTOMER FATHER NAME |
|GENDER |TEXT |GENDER OF CUSTOMER |
|D_O_B |DATE/TIME |DATE OF BIRTHOFCUCTOMER |
|ADDRESS |TEXT |ADDRESS OF CUSTOMER |
|TEL_NO |NUMBER |CUSTOMER TELPHONE NUMBER |
|PROFESSION |TEXT |PROFESSION OF CUSTOMER |
|SECURITY |TEXT |SECURITY OF CUSTOMER |
|CONCESSION |TEXT |CONCESSION OF SECURITY |
|F_NAME |TEXT |FLIGHT NAME |
|F_CODE |NUMBER |FLIGHT CODE |
|C_CODE |TEXT |CLASS CODE |
|T_EXE SEATNO |NUMBER |TOTAL EXECUTIVE SEATNUM,BER |
|T_ECO SEATNO |NUMBER |TOTAL ECONOMIC SEAT NUMBER |

FLIGHT INFORMATION

FLEET INFORMATION
|FIELD NAME |DATATYPE |DESCRIPTION |
|NO_AIRCRAFT |TEXT |NUMBER OF AIRCRAFT |
|CLUB_PRE_CAPACITY |TEXT |CLUB PRE CAPACITY |
|ECO_CAPACITY |TEXT |ECONOMIC CAPACITY |
|ENGINE_TYPE |TEXT |ENGINE TYPE |
|CRUISESPEED |TEXT |CRUISESPEED |
|AIR_LENGTH |TEXT |LENGTH OF AIR |
|WING_SPAM |TEXT |WING_SPAM |

CONCESSION
|CONCE_NAME |TEXT |CONCESSION NAME |
|CONCE_CODE |NUMBER |CODE OF CONCESSION |
|CLASS |TEXT |CLASS OF CONCESSION |
|DISCOUNT |TEXT |DISCOUNT CONCESSION BASIS |
|V_O_T |TEXT |VALIDITY OF TICKET |
|BAG_ALLOW |TEXT |BAGGAGE ALLOWANCE |
|FARE_BASIC |TEXT |FARE BASIC FIXED |

FARE
|FIELD NAME |DATATYPE | DESCRIPTION |
|ROUTE_CODE |TEXT |CODE NUMBER OF ROUTE |
|S_PLACE |TEXT |SOURCE PLACE |
|VIA |TEXT |VIA |
|D_PLACE |TEXT |DESTINATION PLACE |
|D_TIME |DATE/TIME |DEPARTUE TIME |
|A_TIME |DATE/TIME |ARRIVAL TIME |
|F_CODE |TEXT |FLIGHT CODE |
|C_CODE |TEXT |CLASS CODE |
|FARE |TEXT |FARE OF CLASS |

TICKET REPORT
|TICKET NO |NUMBER |TICKET NUMBER |
|PNR |NUMBER |PASSENGER NUMBER |
|F_ID |TEXT |FLIGHT ID |
|S_PLACE |TEXT |SOURCE PLACE |
|D_PLACE |TEXT |DESTINATION PLACE |
|T_DATE |TEXT |TRAVEL DATE |
|D_TIME |DATE/TIME |DEPARTURE TIME |
|A_TIME |DATE/TIME |ARIVAL TIME |
|FARE 1 |NUMBER |FARE OF FIRSTPASSENGER |
|FARE 2 |NUMBER |FARE OF SECOND PASSENGER |
|FARE 3 |NUMBER |FARE OF HIRDPASSENGER |
|FARE 4 |NUMBER |FARE OF FOURTH PASSENGER |
|FARE 5 |NUMBER |FARE OF FIFTHPASSENGER |
|FARE 6 |NUMBER |FARE OF SIXTHPASSENGER |
|SEAT_NO 1 |NUMBER |SEAT NUMBER OF 1ST PASSENGER |
|SEAT_NO 2 |NUMBER |SEAT NUMBER OF 2ND PASSENGER |
|SEAT_NO 3 |NUMBER |SEAT NUMBER OF 3RD PASSENGER |
|SEAT_NO 4 |NUMBER |SEAT NUMBER OF 4TH PASSENGER |
|SEAT_NO 5 |NUMBER |SEAT NUMBER OF 5TH PASSENGER |
|SEAT_NO 6 |NUMBER |SEAT NUMBER OF 6TH PASSENGER |
|AGE 1 |NUMBER |AGE OF 1ST PASSENGER |
|AGE 2 |NUMBER |AGE OF2ND PASSENGER |
|AGE 3 |NUMBER |AGE OF 3RD PASSENGER |
|AGE 4 |NUMBER |AGE OF 4TH PASSENGER |
|AGE 5 |NUMBER |AGE OF 5TH PASSENGER |
|AGE 6 |NUMBER |AGE OF 6TH PASSENGER |
|CLASS |TEXT |CLASS |
|PASSENGER |NUMBER |TOTAL PASSENGER |

ENQUIRY
|T_NO |TEXT |TICKET NUMBER |
|F_NAME |TEXT |FLIGHT NAME |
|F_CODE |NUMBER |FLIGHT CODE |
|C_SEATNO |NUMBER |CLASS SEAT NUMBER |
|C_FARE |NUMBER |CLASS FARE |
|CUST_CODE |NUMBER |CUSTOMER CODE |
|T_DATE |TEXT |TRAVEL DATE |
|T_TIME |DATE/TIME |TRAVEL TIME |

CANCELLATION
|CUST_CODE |TEXT |CUSTOMER CODE |
|CLASS |TEXT |CLASS |
|S_NO |NUMBER |SEAT NUMBER |
|DAYS LEFT |DATE/TIME |DAYS LEFT |
|HOURS LEFT |DATE/TIME |HOURS LEFT |
|BASIC AMMOUNT |TEXT |BASIC AMMOUNT |
|CANCELAMMOUNE |NUMBER |CANCEL AMMOUNT |

RULES
|DATE FROM DEP |TEXT |DATE FROM DEPARTURE |
|PERCENTAGE |TEXT |PERCENTAGE OF CANCEL |
|REFUND |NUMBER |REFUND AMMOUNT |

TERMS
|AGE |TEXT |AGE OF PASSENGER |
|SEX |TEXT |SEX OF PASSENGER |
|FARE |NUMBER |FARE OF PASSENGER |

RESERVED SEAT
|F_CODE |TEXT |FLIGHT CODE |
|T_RES_ECO_SEAT |NUMBER |TOTAL RESERVED ECONOMIC SEAT |
|T_RES_EXE_SEAT |TEXT |TOTAL RESERVED EXECUTIVE SEAT |
|T_DATE |TEXT |TRAVEL DATE |
|WAITING_NO |NUMBER |WAOTING LIST |
CODINGS

The coding of the project under consideration is enclosed in annex - IV

Coding for Reservation

Option Explicit Dim adors As Recordset Dim adors1 As Recordset Dim ADORS2 As Recordset

Private Sub Combo1_Click() If Val(Combo1.Text) = 1 Then Text3(1).Visible = False Text3(2).Visible = False Text3(3).Visible = False Text3(4).Visible = False Text3(5).Visible = False Text3(0).Visible = True Combo3(1).Visible = False Combo3(2).Visible = False Combo3(3).Visible = False Combo3(4).Visible = False Combo3(5).Visible = False Combo3(0).Visible = True Text4(1).Visible = False Text4(2).Visible = False Text4(3).Visible = False Text4(4).Visible = False Text4(5).Visible = False Text4(0).Visible = True Text6(1).Visible = False Text6(2).Visible = False Text6(3).Visible = False Text6(4).Visible = False Text6(5).Visible = False Text6(0).Visible = True End If If Val(Combo1.Text) = 2 Then Text3(1).Visible = True Text3(2).Visible = False Text3(3).Visible = False Text3(4).Visible = False Text3(5).Visible = False Text3(0).Visible = True Combo3(1).Visible = True Combo3(2).Visible = False Combo3(3).Visible = False Combo3(4).Visible = False Combo3(5).Visible = False Combo3(0).Visible = True Text4(1).Visible = True Text4(2).Visible = False Text4(3).Visible = False Text4(4).Visible = False Text4(5).Visible = False Text4(0).Visible = True Text6(1).Visible = True Text6(2).Visible = False Text6(3).Visible = False Text6(4).Visible = False Text6(5).Visible = False Text6(0).Visible = True End If If Val(Combo1.Text) = 3 Then Text3(1).Visible = True Text3(2).Visible = True Text3(3).Visible = False Text3(4).Visible = False Text3(5).Visible = False Text3(0).Visible = True Combo3(1).Visible = True Combo3(2).Visible = True Combo3(3).Visible = False Combo3(4).Visible = False Combo3(5).Visible = False Combo3(0).Visible = True Text4(1).Visible = True Text4(2).Visible = True Text4(3).Visible = False Text4(4).Visible = False Text4(5).Visible = False Text4(0).Visible = True Text6(1).Visible = True Text6(2).Visible = True Text6(3).Visible = False Text6(4).Visible = False Text6(5).Visible = False Text6(0).Visible = True End If

If Val(Combo1.Text) = 4 Then Text3(1).Visible = True Text3(2).Visible = True Text3(3).Visible = True Text3(4).Visible = False Text3(5).Visible = False Text3(0).Visible = True Combo3(1).Visible = True Combo3(2).Visible = True Combo3(3).Visible = True Combo3(4).Visible = False Combo3(5).Visible = False Combo3(0).Visible = True Text4(1).Visible = True Text4(2).Visible = True Text4(3).Visible = True Text4(4).Visible = False Text4(5).Visible = False Text4(0).Visible = True Text6(1).Visible = True Text6(2).Visible = True Text6(3).Visible = True Text6(4).Visible = False Text6(5).Visible = False Text6(0).Visible = True End If If Val(Combo1.Text) = 5 Then Text3(1).Visible = True Text3(2).Visible = True Text3(3).Visible = True Text3(4).Visible = True Text3(5).Visible = False Text3(0).Visible = True Combo3(1).Visible = True Combo3(2).Visible = True Combo3(3).Visible = True Combo3(4).Visible = True Combo3(5).Visible = False Combo3(0).Visible = True Text4(1).Visible = True Text4(2).Visible = True Text4(3).Visible = True Text4(4).Visible = True Text4(5).Visible = False Text4(0).Visible = True Text6(1).Visible = True Text6(2).Visible = True Text6(3).Visible = True Text6(4).Visible = True Text6(5).Visible = False Text6(0).Visible = True End If If Val(Combo1.Text) = 6 Then Text3(1).Visible = True Text3(2).Visible = True Text3(3).Visible = True Text3(4).Visible = True Text3(5).Visible = True Text3(0).Visible = True Combo3(1).Visible = True Combo3(2).Visible = True Combo3(3).Visible = True Combo3(4).Visible = True Combo3(5).Visible = True Combo3(0).Visible = True Text4(1).Visible = True Text4(2).Visible = True Text4(3).Visible = True Text4(4).Visible = True Text4(5).Visible = True Text4(0).Visible = True Text6(1).Visible = True Text6(2).Visible = True Text6(3).Visible = True Text6(4).Visible = True Text6(5).Visible = True Text6(0).Visible = True End If End Sub

Private Sub Combo3_Click(Index As Integer) Dim ADORS2 As ADODB.Recordset Dim var2 As Integer Dim var3 As Integer Dim db As Connection Set db = New Connection db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=NATH" Set ADORS2 = New ADODB.Recordset Adodc1.RecordSource = "select * from fixed where f_code ='" & RTrim(LTrim(DBCombo1.Text)) & "' and tdate = '" & RTrim(LTrim(Text8.Text)) & "'" Adodc1.Refresh ADORS2.Open "select * from fixed", db, adOpenStatic, adLockOptimistic var2 = ADORS2.Fields!t_res_eco_seat Text6(Index).Text = var2 + 1

End Sub

Private Sub Command1_Click() Text2.Text = Val(Text4(0).Text) + Val(Text4(1).Text) + Val(Text4(2).Text) + Val(Text4(3).Text) + Val(Text4(4).Text) + Val(Text4(5).Text) End Sub

Private Sub DBCombo1_Change() On Error Resume Next MSRDC1.Resultset.Bookmark = DBCombo1.SelectedItem End Sub

Private Sub DBCombo1_Click(Area As Integer) On Error Resume Next MSRDC1.Resultset.Bookmark = DBCombo1.SelectedItem End Sub

Private Sub Form_Load() Dim db As Connection Set db = New Connection db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=NATH" Set adors = New Recordset ADORS2.Open "select ticket_no,pnr,flight_id,source,destination,t_date,d_time,a_time,fare1,fare2,fare3,fare4,fare5,fare6,class,age1,sex1,seat1,age1,sex1,seat1,age2,sex2,seat2,age3,sex3,seat3,age4,sex4,seat4,age5,sex5,seat5,age6,sex6,seat6,passenger from ticket_report", db, adOpenStatic, adLockOptimistic Dim otext As TextBox For Each otext In Me.Text1

Set otext.DataSource = adors Next db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=NATH" Set adors = New Recordset Set adors1 = New Recordset Set ADORS2 = New Recordset adors1.Open "select max(TICKET_NO)from ticket_report", db, adOpenStatic, adLockOptimistic ADORS2.Open "select max(pnr) from ticket_report", db, adOpenStatic, adLockOptimistic var1 = adors1.Fields(0) var2 = ADORS2.Fields(0) Text1(0) = var1 + 1 Text1(17) = var2 + 1 adors.Open "select * FROM FARE", db, adOpenStatic, adLockOptimistic Set Text1(1).DataSource = adors Set Text1(2).DataSource = adors Set Text1(3).DataSource = adors Set Text1(4).DataSource = adors

End Sub

Private Sub PRINT_Click() Ticket_report.Print End Sub

Private Sub save_Click() adors.UpdateBatch adAffectAllChapters End Sub

Text3_LostFocus(Index As Integer) Dim temp As Double If Val(Text3(Index).Text) > 60 Then temp = (5 * Val(Text5.Text) / 100) MsgBox (temp) Text4(Index).Text = temp Else temp = Val(Text5.Text) End If

Text4(Index).Text = temp End Sub

Coding for Cencellation

Option Explicit Dim adors As Recordset

Private Sub CANCEL_Click() Dim SQL As String Dim db As Connection Set db = New Connection db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=NATH" SQL = "DELETE FROM TICKET_REPORT WHERE PNR='" & txtfields(0).Text & "'" db.Execute SQL End Sub

Private Sub Command3_Click() Unload Me End Sub

Private Sub Form_Load() Dim db As Connection Set db = New Connection db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=NATH" Set adors = New Recordset adors.Open "select CUST_CODE,CLASS,SEAT_NO,DAYS_LEFT,HOURS_LEFT,BASIC_AMMOUNT,CANCEL_AMMOUNT FROM REFUND_AMMOUNT", db, adOpenStatic, adLockOptimistic Dim otext As TextBox For Each otext In Me.txtfields Set otext.DataSource = adors Next End Sub

Private Sub SHOW_Click() Dim ADORS2 As Recordset Dim db As Connection Set db = New Connection db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=NATH" Set ADORS2 = New Recordset ADORS2.Open "select * from TICKET_REPORT WHERE PNR = ' " & txtfields(0).Text & " ' ", db, adOpenStatic, adLockOptimistic 'txtfields(0) = (ADORS2.Fields(1))

txtfields(1) = (ADORS2.Fields(8)) txtfields(2) = (ADORS2.Fields(7)) txt_basic_ammount.Text = (ADORS2.Fields(9))

End Sub

Private Sub txtfields_LostFocus(Index As Integer) Dim db As Connection If Index = 0 Then Set db = New Connection db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=NATH" Set adors = New Recordset adors.Open "select CUST_CODE,CLASS,SEAT_NO,DAYS_LEFT,HOURS_LEFT,BASIC_AMMOUNT,CANCEL_AMMOUNT FROM REFUND_AMMOUNT where cust_code = ('" & txtfields(0).Text & "')", db, adOpenStatic, adLockOptimistic Dim otext As TextBox For Each otext In Me.txtfields Set otext.DataSource = adors Next End If End Sub

Private Sub txtsub_Click() txtresult(7).Text = Val(txt_basic_ammount.Text) - Val(txt_cancel_ammount(6).Text) End Sub Coding for Enquiry

Option Explicit Dim adors As Recordset

Private Sub add_Click(Index As Integer) With adors .AddNew End With End Sub

Private Sub cl_Click(Index As Integer) Unload Me End Sub

Private Sub CONFIRM_Click() Dim ADORS2 As Recordset Dim db As Connection Set db = New Connection db.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=NATH" Set ADORS2 = New Recordset ADORS2.Open "select * from TICKET_REPORT WHERE TICKET_NO ='" & txtfields(7).Text & "'", db, adOpenStatic, adLockOptimistic txtfields(4) = (ADORS2.Fields(1)) txtfields(1) = (ADORS2.Fields(2)) txtfields(2) = (ADORS2.Fields(9)) txtfields(3) = (ADORS2.Fields(7)) txtfields(5) = (ADORS2.Fields(5)) txtfields(6) = (ADORS2.Fields(6)) End Sub TESTING DEBUGGING AND VALIDATION

In this phases I had tried to check all the modules separately for there proper formatting.

After this step I had performed a unit test to check the functionality of the whole system.

Further I had come to know to add certain validation in project as given bellow

1) Table name- Customer information Field name –Customer name Data type -Text.

When we enter number in the form then it show wrong .Because it is not number type It is a character. So it show wrong value.

2) Table name _Customer information Field name- Departure time, Arrival time Data type- Date/Time.

When we enter 12.33 then it automatically show 12.33pm. When we enter 11.33 then it automatically show 11.33am.

3) Table name –Flight information Field name- Flight-code Data type- number

When we Put any other value or character then it ask validity check.

IMPLEMENTATION

For the implementation of my project the mirror H/W & S/W requirements as under

Steps implementation

Steps of implementation are : • First load VB in system • Make a software .In this s/w The airlines Reservation system is stored. • First make all form. • Make Main menu. Join every form with Main menu . • Main menu open .It show all forms heading. • Now choose what form will be open then click. • If Reservation form is open then it show new pnr and ticket number. • After put various value we click save bottom. • It automatically go to report. CONCLUSION

Though the system still containing lot of scope of improvement in it. But its overall look and feel gives rough picture of on existing automation system.

I have take MS-Access at backhand but it has a limitation of 1 GB size .It over data size approaches this 1gb some other database the SQL server ,oracle, can be used with OBBC to break this barrier.

***************THE END******************
-----------------------
[pic]

AIRLINES SYSTEM

CANCELLATION

RESERVATION

UPDATION

TECHNICAL SYSTEM

DISCOUNT

database

AIRLINE RESERVATION SYSTEM

PASSENGER

UPDATE

BOOKING

DEVIT

PASSENGER

PASSENGER

FARE

FLIGHT

I

R

R

I

I

Relation ship set

HARDWARE SOFTWARE

Pentium II to IV Window-9x,2000,2000server
Attempt 200 MHz MS-Access
Ram –32MB MS-Excel
H.D .space-4xGB MS-Word
FDD-
CD ROM DRIVE-52x

line

obal

Entity sets

R

INFORMATION

TEL_NO

D_O_B

PNR

NAME

TEL_NO

FLIGHT NUM

_NUM

DATE OF DEP

ROUTE

ADDRESS

STATUS

PASSENGER

CONFIRM

VALID ?

WAITING

BOOKING 1
(ON THE SPOT)

NAME

PNR

MODE OF PAYMENT

CASH

CHEQUE

DEBIT

CREDIT

PNR

FARE

CASH PAID

STATUS

PNR

FARE

STATUS

PAID

PNR

FARE

D NO

STATUS

STATUS

FARE

C NO

PNR

BOOKING 2
(ON THE SPOT)

STAND
BY DATE

BOOKING
DATE

PNR

NAME

ADDRESS

NAME

Passenger

PNR

TEL_NUM

D_O_B

FLIGHT_ID

T_DATE

ROUTE

STATUS

SEAT
AVAILABLE
?

FLIGHTS

ARRIVAL

DEPARTURE

SEAT

FLIGHT_NUM

COST_ECO

COST_EXE

SEATS_ECO

SEATS_EXE

CANCEL ?

CANCEL

PNR

NAME

T_DATE

D_CANCEL

STATUS

PASSENGER

1.0
GENERAL
ENQUIRY

2.0
PASSENGER
ENQUIRY

3.0
BOOKING
COUNTER

4.0
CANCELLATION

BOOKING
ENQUIRY

NEW PNR INFORMATION

RESERVATION REQUEST

TICKET CONFIRMATION &STATUS

CANCELLATION REQUEST

ACKNOWLEGMENT

REQUEST FOR INFORMATIONFLIGHT/FARE/DISCOUNT

PASSENGER

REQUIRED INFOR MATION

REQUEST FOR INFOR MATION

1.0 GENERAL ENQUIRY

R
E
Q
U
E
S
T

1.3
DISCOUNT

I
N
F
O
R
M
A
T
I
O
M

1.2
FARE
ENQUIRY

1.1
FLIGHT
ENQUIRY

R
E
Q
U
E
S
T

I
N
F
O
R
M
A
T
I
O
N

R
E
Q
U
E
S
T

I
N
F
O
R
M
A
T
I
O
N

PASSENGER

NEW PNR OR REQUIRED INFORMATION

ENTRY OF NEW RECORD OR EXISTING
PASSENGER ENQUIRY

PASSENGER
ENQUIRY

2.2
PASSENGER
ENQUIRY

NEW
PASSENGER

R

UNIQUE
PNR

R

INFORMATION

R
E
Q
U
E
S
T

U
N
I
Q
U
E
P
N
R

R
E
Q
U
E
S
T

I
N
F
O

PASSENGER

3.0
BOOKING
COUNTER

BOOKING NOW

ACKNOWLEDGEMENT
BOOKING
LATERUPDATE

PASSENGER
REQUEST

TICKET(ON THE SPOT)
ACKNOLEDGEMENT(STAND BY)

3.1
ON THE SPOT

3.2
STAND BY
BOOKING

BOOKING

SET STATUS TO CONFIRM/WAITING

CASH
PAYMENT
STATUS

3.1.1
MODE OF
PAYMENT

STATUS(PAID OR NOT)

CHOOSE MODE OF PAYMENT

ENTRY STAND BY DATE

ACKNOLEDGE

DEVIT NUMBER

STATUS

CREDIT NUMBER

S
T
A
T
U
S

CREDIT

CHEQUE

CASH

PAY CASH

S
T
A
T
U
S

C-
NO

PASSENGER

ACKNOWLEDGEMENT

REQUEST FORCANCELLATION

4.0
CANCELLATION
SECTION

CANCELLATION

UPDATE

ACKNOLEDGEMENT

VALIDITY CHEQUE

4.3
VALIDITY
CHEQUE

4.1
CANCEL
TICKET

4.2
RESHEDULE

A
C
K
N
O
L
E
D
G
E

REQUEST
FOR
CANCEL

PASSENGER

A
C
K

NEW
DATE

PASSENGER

PASSENGER

STATUS

CHEQUE
VALID

WAITING LIST
CANCELLATION

PASSENGER
LIST
CONFIRMED
LIST

DATA ACCESS

DATA STIRAGE

RECEIVE
CUSTOMER
REQUEST

Flight MAINTENANCE,
Booking, cancellation

BOOKING
DEPARTMENT

PASSENGER

Passenger list,
Fleet info concession Flight information,
Fare details,

Ticket reservation
Cancellation,
Request for enquiry

REPORTS

Similar Documents

Premium Essay

Online Ticketing Systems

...Online Ticketing Systems of Airlines Operators in Nigeria: History, Challenges and Prospects. March 2016. Name: Byron, Queen Omasirichi. Matric No: PG. 2015/00819 Option: Human Resources Management (M.Sc) Department: Management Faculty: Management Sciences Course Code: MGT 851 Course Title: Management Information Systems Lecturer: Dr. Justin .O. Gabriel ABSTRACT Unit: Port Harcourt Date September 2016 Author Pooja Gautam Degree Program Information Technology Name of thesis ONLINE AIRLINE TICKETING SYSTEM Instructor Kauko Kolehmainen Pages 44 Supervisor Kauko Kolehmainen The aim of this thesis was to explain the system of online ticketing used by airlines by explaining the mechanism and presenting a sample application. The thesis describes the evolution and working of airline reservation system. Various aspects related to online flight booking are explained in the thesis. The main focus of the thesis was developing a working application. A basic application similar to the models used by airlines companies today was developed with the use of various software and programs. Research in sources such as e-books, web articles, documentations and tutorial was completed for the development. The thesis describes how the online ticket booking works with the help of different diagrams...

Words: 2047 - Pages: 9

Premium Essay

Sdm Aviation Channel

...Airline Distribution Air Transport Management Seminar Universidade Lusofona Lisbon 7th - 11th January 2008 Dr Keith Mason Director Business Travel Research Centre www.businesstravelresearch.com Dept of Air Transport K.Mason@cranfield.ac.uk Distribution - Factors affecting distribution strategy • Airlines drive to reduce costs • Distribution has been around 20% of operating costs • Airlines wishing to have more direct contact with their clients • Technology has provided the possibility of a direct channel between the airline and its customers • Disintermediation - as airlines doubt the ability of agents to influence customers’ choice • GDSs fees • Large corporates are more professional in the way they purchase travel products Star Alliance Carriers collective spend over USD $11bn on distribution Description Total Mainline reservations, sales, advertising and promotional cost, by category 2004 est. 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% Sources: Form 41 4Q03, Star Alliance Cost Q3 03 8% 2% 2% 7% 18% Advertising & Promotions 20% Media Personnel Loyalty Programs Other CRS / GDS Fees Other Reservations & Sales 60% Credit Card Fees 18% Salesforce /Reservations Benefits Management & staff 5% 6% 3% 8% 19% 1% Cargo Comm. 1% Other Pax Comm. 19% Passenger commissions Cargo commissions The distribution value chain • Airlines spend $5bn per annum on GDS fees • Cost as % of ticket prices • GDS 8 - 11% • Travel...

Words: 2086 - Pages: 9

Free Essay

Mayflower

...Total Travel Service Specialist Mayflower Group Corporate Profile Cor orporate ofile e CAR RENTAL & AUTO LEASING AIRLINE TICKETING CORPORATE INCENTIVE TRAVEL MICE COACH HIRE CHAUFFEUR SERVICES HOLIDAY PACKAGES MM2H HOTEL RESERVATIONS About Mayflower Group Established since 1960, Mayflower today is a total travel service specialist and transportation solutions provider in Malaysia, offering a diverse range of products and services for individuals and corporations on leisure and business travel. As the pioneer in the Malaysia car rental industry and the first to introduce luxurious air-conditioned coaches in the country, Mayflower has since grown to become one of the largest fleet owner for ground transportation with a nationwide fleet size of over 2800 vehicles comprising of sedan cars, MPVs, tour vans and air-conditioned coaches. With a wide network of branches and support from foreign and local partners, coupled with a work force of over 550 dedicated employees throughout the country, Mayflower is committed to fulfil its vision of being the market leader and strives to surpass the needs of clients and business partners. We are? h0 Mayflower is a subsidiary of Warisan TC Holdings Berhad, a public listed company on the main board of Bursa Malaysia. The Group consists of the following companies: • Mayflower Acme Tours Sdn Bhd • Mayflower Holidays Sdn Bhd • Discovery Tours (Sabah) Sdn Bhd (Managed and operated by Mayflower Acme Tours Sdn Bhd) •...

Words: 1895 - Pages: 8

Premium Essay

Course Project

...business. Priceline was established in 1998 and inaugurated its first television commercial a year later in 1999. Priceline is an online entity that helps customers find favorable travel deals. Priceline collects commissions on user reservations. They use social media like Facebook, Twitter, YouTube, and Google+ to advertise specials that may not be listed on Priceline.com (2014). Although Priceline uses social media, they make it known that they do not need certain sites. Priceline.com provides vacation packages, rental cars, airline tickets, cruises, and hotel rooms all over the world. They have recently added restaurant reservations to their list of specialties. There are thousands of destinations and hundreds of countries to choose to travel or visit when booking with Priceline. Priceline uses three ways for customers to book travel: lowest retail rate, express deals, and name your own price. These options give travelers a little flexibility so they are able to get what they actually want. Priceline can broaden their business by giving customers more option on mobile applications and the name your price option. Current Use of the Web According to Anderson (2008), "Priceline.com is an Internet-based corporation offering services (airline tickets, hotel rooms, rental cars, and home mortgages) with the option for consumers to dictate prices" (p. 37). Priceline has used the internet to develop ways for customers to book and negotiate travel by using the worldwide web...

Words: 2421 - Pages: 10

Premium Essay

Outline of E Business Plan

...success factors to compete effectively in this industry. In addition, the paper will provide a market analysis to understand the target market and segmentation, and provide strategies for market positioning and market entry. Background The online travel distribution industry has evolved from the initial development of computerized reservation systems (CRS) by the airlines to manage airline seat reservations, with the first major system Sabre developed by American Airlines with the help of IBM in the early 1960’s, and followed shortly by United Airlines development of the Apollo system (PhoCusWright, 2009) Services offered by the company Online travel agencies are companies who provide travel reservations primarily on the internet. These companies acquire blocks of airline and hotel inventory at discounted prices and make them available to consumers on the internet. Tripkichen.com is a new start up online travel company looking to capitalize by offering an online travel reservation services by providing competitive priced travel products in real time booking capability, entire facility of travel services through internet. Addition to airline booking Tripkitchen offers hotel booking holiday packages car rentals, train, and cruises. The company intends to offer an efficient, informative, and...

Words: 1594 - Pages: 7

Premium Essay

E-Commerce

...use of Information Communication Technology (ICT) and E-Commerce has produced competitive advantage to Hospitality Industry Done by: Jane Lim Chiew Ping Submitted on: 19th November 2009 Table of Contents Page 1.0 Introduction……………………………………….. ………03 2.0 E-Commerce Applications for Hospitality Organizations…05 3. Lodging……………………………………………….........06 4.0 Food Industry………………………………………………12 5.0 Meetings and Events………………….……………………14 6. Entertainment/Recreation………………………………….15 7. Airlines………………………………. ……………………16 8. Travel Agents……………………………………………....19 9. Cruise Lines ………………………………………………..21 10. Conclusion……………………………………………….. ..24 11. References………………………………………………….25 [pic] Introduction When most people think about hospitality industry, they have visions of hotels, airlines, cruise ships, restaurants, health spas, and the like, based on their personal experiences. All aspects of the industry are involved in business processes at the operations level. Business processes consist of transactions and interactions with guests or customers, employees and even other businesses. A transaction is an activity such as checking in to a hotel or placing an order in a restaurant. Interactions include the relationships that take place during each transaction. A desk agent at the hotel takes the opportunity to create a positive first impression with a guest...

Words: 3132 - Pages: 13

Free Essay

Diagnosis of Change

...Rewards: Is there an incentive for doing all that needs doing? 5. Leadership: Is someone keeping the boxes in balance? 6. Helpful mechanisms: Have we adequate coordinating technologies? This model is useful to maintain awareness of all areas for consideration even though one variable may be identified as the main area for attention. I chose this model because I believe that both organizations used these components while trying to implement technical changes within their organizations. Both JetBlue and WestJet knew that the airline business was very competitive and in order to stay relevant, and better serve their customer base, they would need to upgrade the current reservation system they used. Due to JetBlue and WestJet’s growth, it was hard for the outdated system to perform. Sabre Holdings is one of the most widely used airline IT providers, so both JetBlue and WestJet decided they would be the best option for implementing the new system. WestJet was the first out of the two to implement this change and found out first hand that building a working relationship with the engineers from Sabre would have been essential in question asking in order to ensure that both parties are on the same page and WestJet gets exactly what is...

Words: 1122 - Pages: 5

Premium Essay

Customer Relationship Management

...and provides advertisers the opportunity to reach a highly valuable audience of in-market travel consumers, in addition to powering bookings for some of the world’s leading airlines and hotels, top consumer brands, high traffic websites, and thousands of active affiliates. The company is headquartered in Bellevue, Washington, with additional operations in nearly 70 offices across the globe. For additional corporate industry news and views, follow us on Twitter @expediainc. Expedia, Inc. is a publicly-traded company listed under the ticker symbol EXPE on the NASDAQ Global Market. Expedia is an Internet-based travel website company headquartered in Bellevue, WA, Austria, Belgium, Canada, Denmark, France, Germany, Indonesia, India, Ireland, Italy, Japan, SouthKorea, Malaysia, Mexico,Netherlands, NewZealand, Norway, Philippines, Singapore, Spain, Sweden, Thailand, UK, US). Created by Rich Barton and Lloyd Frink. It books airline tickets, hotel reservations, car rentals, cruises, vacation packages and various attractions and services via theWorld Wide Web and telephone travel agents. The site uses multiple global distribution systems like Amadeus or the Sabre reservation systems for flights and for hotels, Worldspan and Pegasus, along with its own hotel reservation system for contracted, bulk-rate reservations. This last is shared with other Expedia, Inc. sites. In December 2010, listings for AMR Corporation,...

Words: 3141 - Pages: 13

Free Essay

Westjet and Jetblue

...Airlines such as WestJet and JetBlue promote low-cost and high-efficiency carriers by giving extremely competitive fares and outstanding customer service. Reservation system for these airlines are so important that when these companies need to make sweeping IT upgrades, their relationships with customers and their brands can be tarnished if things go awry. This can be seen when in 2009, both airlines upgraded their airline reservation systems, SabreSonic CSS was launch, customers struggled to place reservations, and the WestJet Web Site crashed repeatedly. WestJet’s call centers were also overwhelmed, and customers experienced slowdowns at airports. This delay provoked a deluge of customer dissatisfaction. In addition to the increase in customer complaint calls, customers also took to the Internet to express their displeasure. Angry flyers expressed outrage on Facebook and flooded WestJet’s site, causing the repeated crashes. These problems impact both of the airlines operational activities and decision making to change their initial carrier which had started out as a system designed for smaller start-up airlines to a better carrier. Other than that, both airlines needed more processing power to deal with a far greater volume of customers. They also needed features like the ability to link prices and seat inventories to other airlines with whom they cooperated. Both JetBlue and WestJet contracted with Sabre Holdings to upgrade their airline reservation systems. The differences...

Words: 1983 - Pages: 8

Premium Essay

Week 8 Checkpoint Jetblue and Westjet

...past years, customers have been heavily relying on airline reservation systems to book their tickets, reserve seats, pay for the tickets and also check-in online. For customers, this has been a very convenient method and they are able to easily plan their trips. For the Airline companies, these systems have the whole flight inventory managed. They have all the flight information stored and records are maintained. It also provides a platform for communication between other airline companies for their “code-sharing plans” and agents or other ticketing offices can see real time information about the bookings and availability of seats. Since both parties rely on these systems they are of big importance to airline companies. For example, we see in the case of WestJet, the amount of chaos created after a delay of switch to another version of the system. Airline reservation systems have impacted operational activities and decision making. They have made it easier to maintain accounts with other airlines and internal processes between departments are more efficient since the “minus, plus” is done online. There has also been growth in faster service times which leads to increased customer satisfaction since customers can plan, book and pay online. Airline companies are able to make good strategic decisions on which route to monopolize on and how to improve their service by accessing past records about their customers stored by the system. However, on the flip side of the coin, customers’...

Words: 549 - Pages: 3

Premium Essay

Assignment Economics

...What is a Reservations Sales Agent? A Reservations Sales Agent processes customer enquiries and bookings for travel arrangements including airline tickets, coach bookings, accommodation, day tours, car-hire, transfers and travel insurance. They usually work over the telephone or on-line and occasionally face to face depending on the company. What does a Reservations Sales Agent do? The agent processes customer bookings and answers customer enquiries over the phone and on-line. All bookings (or reservations) then go into a computer reservations system. A Reservations Sales Agent needs to ask and answer questions to ensure their customers get what they are looking for. It is important that a Reservations Sales Agent has comprehensive product information about what they are selling in order to answer customer enquiries accurately. What does it take to be successful? A love of dealing with people, good listening skills, attention to detail and accuracy. The Reservations Sales Agent needs to be able to work at a fast pace as they will often find reservations roles are located in call centres with large numbers of phone calls on hold with clients awaiting your help. What is the Travel Agencies Industry? This industry includes businesses that sell, book and arrange travel, tour and accommodation services for the general public and commercial clients. The industry also encompasses companies primarily engaged in providing travel arrangement and reservation services, including...

Words: 6521 - Pages: 27

Premium Essay

Dissertation

... 1.1. Background of the study 3 1.2. Hypothesis 4 1.3. Aim 4 1.4. Objectives 5 1.5. Structure of the dissertation 5 1.6. Summary 7 2. LITERATURE REVIEW 8 2.1. Introduction 8 2.2. Comparison of traditional and online sales 8 2.2.1. The individual businessman segment 9 2.2.2. The business group segment's sales channels 10 2.2.3. Individual travellers' sales channels 10 2.2.4. Sales channels of leisure group travellers 11 2.3. Sales and sales tools in the hotel industry and their development 12 2.4. Distribution channels 16 2.4.1. Types of distribution channels 17 2.4.2. Participants of the distribution channels 18 2.5. Development of distribution and the appearance of e-reservations 19 2.5.1. Early stages 19 2.5.2. Internet Distribution System 20 2.5.3. Online Travel Agents 21 2.5.4. Latest tendencies 23 2.5.5. Social Media 24 2.5.6. Consumer Generated Media 25 2.5.7. Meta Search Engines 25 2.6. Travel, booking and research behaviour among Hungarian travellers 26 2.6.1. Travel behaviour 26 2.6.2. Booking behaviour 27 2.6.3. Research behaviour 29 2.7. Summary 30 3. METHODOLOGY 31 3.1. Introduction 31 3.2. Secondary Research 31 3.3. Primary Research 32 3.4. Data Analysis Methods 33 3.5. Summary 33 4. EVALUATION OF RESULTS 34 4.1. Introduction 34 4.2. Interviews with intermediaries 35 4.2.1. Mr. Mate Hegedus, Revenue Specialist of Expedia Lodging Partner Services 35 4.2.2. Mr. Zoltan Katona, Marketing coordinator...

Words: 18021 - Pages: 73

Premium Essay

Speeding Ticket Internet Distribution and the Travel Industry

...Emergence of Global Distribution Systems (GDS): By 1950s, American Airline’s growth outpaced its ability to manage its inventory of seats using manual methods. IBM and American Airline developed SABER for this purpose. This system eventually became control center for American Airlines. Witnessing the success of Sabre system, IBM developed a scaled down version called PARS, targeting medium sized airlines and by 1972, 9 out of 10 major airlines operating in US were operating on IBM PARS system. Winner: IBM is the winner of this stage as it profited the most by starting a technology race for Distribution system and capturing major market Stage: GDS companies Dominance The airlines that owned GDS enjoyed oligopoly with only 4 GDS operators providing flight schedule searching and booking capability for almost all travel agents in United States.They deployed various methods to bias the results of searches performed on their systems e.g Display bias, Architectural bias as well as booking fees charging higher booking fees from more threatening competitors. Winner: Airlines Owning the GDS systems. Due to lack of government regulations, GDS owning airlines enjoyed dominance by deploying various bias methods, these were particularly effective against new, small competitors. Stage: Government Intervention and Deregulation Competing airlines rushed to expand their reach by installing GDS systems at travel agencies. Following deregulation in 1978, airlines competed for attention of agents...

Words: 706 - Pages: 3

Premium Essay

Mis Refernce China Tour Industry

...With reductions in the cost of processing power, new algorithms for database searches and the advent of the World Wide Web, competitors to the established global distribution system (GDS) companies emerged. By 2002, traditional GDS operators competed with each other as well as with airline websites, some Web-based travel agencies and a new entrant called Orbitz, an online travel agency owned by a group of airlines. In 1996, less than one percent of airline tickets were sold online. By 2001, 20 percent of airline flights in the United States were booked online, and the percentage was expected to grow to 25 percent by 2004. Seemingly overnight, forty years of comparative stasis in the business models governing airline reservation and ticket distribution turned into a dogfight as airlines, brick and mortar travel agents, online travel agents and GDS operators clashed over the approximately $180 billion market for airline travel. With ticket distribution costs comprising the third largest expense at some airlines, the battle promised to be fierce. The rapidly growing tourism sector in China has provided a good market environment for tourism enterprises, including travel agencies. In the five years through 2012, revenue for the Travel Agencies industry in China has increased at an annualized rate of 11.3% to $47.5 billion. With increasing demand for diversified tourism products such as luxury and high quality products, travel agencies have been developing new tourism products in...

Words: 1989 - Pages: 8

Premium Essay

Outage and Downtime

...Information Security Instructor: Mr. Dwight Robinson December 10, 2015 Abstract An outage or downtime at the online reservation system Sabre caused difficulties for many airlines, hotels and other hospitality industries all around the world. It affects business credibility, causes loss in revenue and legal procedures. Because of the recent delays Southwest, AirTran, American Airlines, US Airways, and United Airlines, who use Sabre global distribution system, topped the list of worst airlines in the US (Tooley, 2015). Background Sabre is one the leading provider of global distribution system to the travel and tourism industry. The Sabre GDS enables companies such as American Airlines, BCD Travel, Expedia, JetBlue, and Travelocity to search, price, book, and ticket travel services provided by airlines, hotels, car rental companies, rail providers and tour operators worldwide. It headquarters in Texas and employs over 10,000 employees in 60 countries with revenues of approximately $3 billion. Sabre service is using worldwide by 400 airlines in more than 700 airports, by more than 125,000 hotel properties, 27 car rental brands, 50 rail providers, 16 cruise lines and other global travel suppliers around the world generating more than $5.85 billion in revenue each year for its customers. More than 600 million people make purchases through that system annually (Sabre Authors, 2014). Sabre offers the industry’s broadest range of technology solutions including, data-driven...

Words: 1509 - Pages: 7