Database System For Eticketing In Airlines Computer Science Essay

Published:

E-ticketing in Airlines is a method of booking tickets for different airlines services available through online. Booking tickets through existing system is the manual system where the user information is recorded manually.

Database maintenance became difficult for the large data storage and it is time consuming. And loss of data is unavoidable due to manual maintenance.

To overcome problems in the manual method E-Ticketing is introduced. It came with solutions that have created in manual method. It is also a kind of E-Business where both business sectors and users are getting their benefit.

1.1 E-Ticketing In Airlines Aim

Replacing manual methods to computerised or automatic method.

To provide anytime anyplace service for the customer.

Minimizing the requirement of the human resources.

Promoting the Airlines in large scale.

Ensuring secured way in maintaining the user information.

Providing more options in booking ticket which reduces time wastage and money wastage.

1.2 E-Ticketing Crucial Achievement Issues

Lady using a tablet
Lady using a tablet

Professional

Essay Writers

Lady Using Tablet

Get your grade
or your money back

using our Essay Writing Service!

Essay Writing Service

Acquiring statistical information from the booking record.

Inviting more customers by providing easy usage of the website and attractive, reliable offers.

Maintaining the good standards which will result in good relation between agents, customer and the Airlines system.

A good technical support which provides quick solution for the upcoming problems and clarifications.

1.3 Existing E-Ticket System For Airlines

Existing method for booking tickets is manual method. Here all the user information is recorded by manual method .Manual method has its own limitations comparing to the online method.

Limitations Of The Manual Method

Manual method is time consuming as it is holding fewer options for the users.

In this method user have to directly got to service providers for the ticket reservation.

The backup for the user information is not safe due to the manual recording method.

Loss of data is non-retrievable.

1.4 Online E-Ticket System For Airlines

In this system all the manual methods are replaced by the computerised database system. It provides better solutions for the issues in the manual method. When comparing to the manual method the online method has its advantage in higher level.

Advantages in Online E-Ticket System For Airlines

A website will be developed relevant to the information of the database and with the better understanding of customer need.

Website will be designed in way which provides easy usage to customers.

Storage and retrieving of the data is fully computerised (Computerised database).

Security and safety for the user data is available with the help of the backup options.

Loss of data is very rare and retrieving the lost data is possible.

Facility to create a membership with the airlines is possible with the higher preference.

1.5 SOFT SYSTEM METHODOLOGY (SSM)

Steps involved in the SSM

Intervention.

Social System.

Political System.

These steps are used to identify the problematic situation which can be investigable and gives a clearway to resolve the problem.

1.5.1 Intervention

It is a process clearly defined using three major roles.

Client: Airline system, Agents or user.

Problem owner: Airline system, agents or users, Technical supporters.

Problem solver: Airline system, Technical supporters and Agents.

1.5.2 Social System

In this system terms such as Roles, Norms and Values are defined

Airline System

Roles: Creates and provides the model system to develop the webpage to the technical supporters

Norms: Providing standard guidelines for the developers.

Values: Gives a clear, detailed idea and necessity.

Technical Supporters

Roles: Designs and develops the website with zero defect and provides solution for the upcoming problems and queries.

Norms: Updating the developed web and maintaining the website.

Value: provides good and standard database.

Agents (or) Users:

Roles: Searching for airline tickets through online search engine.

Norms: Booking the air ticket and making the payments via credit or debit card.

Values: Causing zero damage to the website.

1.5.3 Political System

This system clearly explains about the power of the members involved in the E-Ticket process.

Lady using a tablet
Lady using a tablet

Comprehensive

Writing Services

Lady Using Tablet

Plagiarism-free
Always on Time

Marked to Standard

Order Now

Airways System: Decides whether to provide E-Ticket or not after verification.

Technical Supporters: Has the power to change the technical process in providing tickets.

Users: Avoiding E-tickets process of the Airlines system.

1.6 RICH PICTURE

Problem in sending and receiving signals SATILLETE SERVER

No knowledge about web page or pc

User

Insufficient funds

Problem with the server

WEB

Problem with PC

Improper maintenance of bank details PRINTER

PC

C:\Program Files\Microsoft Office\MEDIA\CAGCAT10\j0292982.wmf

Improper communication

Insufficient fund

AgentC:\Program Files\Microsoft Office\MEDIA\CAGCAT10\j0292020.wmf BankC:\Program Files\Microsoft Office\MEDIA\CAGCAT10\j0283209.gif

ROOT DEFINITION

This is online ticketing process that deals with selling of tickets(X) through online (Y) to provide high level business profit to the Airline system and customer satisfaction and (Z).

CATWOE

CLIENTS- Middleman and Airline system.

ACTORS- Users, Airline system.

TRANSFORMATION- To provide a standard website with more convenient options in booking tickets for users also with quick solutions for the occurring issues. Ensuring safe and security in every step for the users.

WORLDVIEW- Increasing the sales value and ensuring customer satisfaction.

ENVIRONMENTAL CONSTRAINTS- Terms and condition of the company which make less option for customer satisfaction.

UNIFIED MODELLING LANGUAGE (UML)

ACTORS:

Users.

Airline System.

USER E-TICKET BOOKING

START

USER LOGIN

DISPLAYING WEBPAGE

AIRLINES SEARCH

NO AVAILABILITY

IF OK

BOOKINGAND GETTING THE TICKET

CHECKING FLIGHT BY TIME AND DATE

LOGOUT

NO

YES

ADMINISTRATOR PROCESS

START

END

IF ACCEPT

NOT AVAILABLE

ISSUE TICKET

ACCEPT OR REJECT BOOKING

VERIFICATION OF USER DATA

ADMINISTRATOR LOGIN

NO YES

USE CASE DIAGRAM FOR USER

RETURN TICKET

CHECK BOUGHT TICKET

CHECK MEMBER DATA

LOGIN

CHECK BY CLASS

CHECK BY DATE AND TIME

CHECK BY FLIGHT

CHECK BY AIRLINES

REGISTRATION

CHECK AIR TICKETS

BUY TICKETUSER

UPDATE PERSONAL DATA

USE CASE DIAGRAM FOR ADMINISTRATOR

ADMIN LOGIN

DELETE E-TICKET DATA

UPDATE E-TICKET DATA

UPLOAD AIRLINES E-TICKET DATA

ADMINISTRATOR

USECASE DIAGRAM FOR BUYING AIR E-TICKET

CHOOSE PAYMENT METHOD

INPUT CREDIT CARD DATA

OLDER CITIZENS

ADULT

CHILD

CHOOSE TICKET TYPE

CHOOSE CLASS

CHOOSE SEAT

CHOOSE BY DATE

CHOOSE BY AIRLINES

CHOOSE BY TIME

CHOOSE TICKET

USER

BY CREDIT CARD

CONFIRM TRANSACTION

BUY REMAINED MONEY FROM RETURN TICKET

SEQUENCE DIAGRAM

TIMINGS

AIRLINES

TICKET

DATA

INPUT FORM

CLASS

USERS

Login

Insert ticket details

Choose Airlines

Get more detail

Choose Timings

Get more details

Choose Class

Get Status

Insert Booking Details

Get Booking Details

Validation

Make Data Record

Insert data record

1.8.3 USE CASE DOCUMENTATION

Pre Conditions: Knowledge about how to attract users through the page, offers, maintenance of web page for effective website, how to make it as easy usage page for the users.

Post Conditions:

Effective steps for the proper function of the webpage.

Providing more options for the users to choose the online way of booking tickets.

Enables to search for the desired airlines system.

Implementing easy steps to reduce time wastage in both sides.

Effective cost management for users and airline system.

Securing the obtained data by means of the backup facility.

Flow Of Events:

User logs in the website.

Searches for the airlines system.

Checks for the flight details.

Choosing by the availability of the flights according to their need.

Booking the ticket in the selected airline system.

Getting the E-tickets.

Printing the Ticket.

Logs out of the Page.

SELECTION:

Lady using a tablet
Lady using a tablet

This Essay is

a Student's Work

Lady Using Tablet

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Examples of our work

Air system rejects or accepts the booking according to the rules.

Users choose the mode of booking.

Users choose the mode of payment.

Error:

If users provide wrong data in the form.

Faults created due to the improper design of the webpage by the technical supporters.

Improper updating of the page at required time.