BlueOcean Airline Reservation System
Submitted By
L.M.A.D.Wijerathne
Reg No: SEU/IS/14/PS/043
Index No: PS0677
Department of Mathematical Sciences
Faculty of Applied Sciences
South Eastern University of Sri Lanka
March-2019
1
1
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Airline reservation system php, Exercises of Computer Science
Airline reservation system project report
Typology: Exercises
2018/2019
1 / 38
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Airline reservation system php and more Exercises Computer Science in PDF only on Docsity!
BlueOcean Airline Reservation System
Submitted By L.M.A.D.Wijerathne Reg No: SEU/IS/14/PS/ Index No: PS
Department of Mathematical Sciences Faculty of Applied Sciences South Eastern University of Sri Lanka March-
1
BlueOcean Airline Reservation System
Final year project report was submitting in partial fulfilment of the requirement
for the award of the degree of Bachelor of sciences(General)
Supervised By Mr. H.M.M.Naleer Senior Lecturer in Computer Science Department of Mathematical Sciences Faculty of Applied Sciences South Eastern University of Sri Lanka
Department of Mathematical Sciences Faculty of Applied Sciences South Eastern University of Sri Lanka March-
2
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 Mr.H.M.M.Naleer 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.
Table of Content
Declaration………………………………………………………………
4
Acknowledgement………………………………………….………… 4
List of figures……………………………………………………………
Abstract…………………………………………………………………..
Chapter 1: Introduction……………………………………………………………… 8
Chapter 2: Background……………………………………………………………… 11
Chapter 3: System Design…………………………………………………………..............
Chapter 4: Implementation and Testing…………………………………………………………………….
Chapter 5: Results and Discussion ………………………………………………………………………………
Chapter 6: Conclusion and Recommendation………………………………………………………..
References…………………………………………………………………
Appendices………………………………………………………………..
LIST OF FIGURES
Figure 1: Flow diagram for Airline Reservation System
Figure 2: XAMP Installation snap
Figure 3: XAMP Control Panel snap
5
Identification of the drawbacks of the existing system leads to the designing of computerized system that will be compatible to the existing system with the system which is more user friendly and more GUI oriented. We can improve the efficiency of the system, thus overcome the drawbacks of the existing system.
· Less human error
· Efficiency
· High security
· Data redundancy can be avoided to some extent
· Data consistency
· Easy to use
· Easy data updating
· Easy record keeping
CHAPTER ONE:
INTRODUCTION
1.1 Overview
In modern world all the transportation entities have become very developed level. So, the modern people use airlines as a main method of transportation when travelling from one country or state to another. So, they have to go to an airline service center and make reservations. Sometimes people have to find the information about the flights that travel under that airline service. It is not such an effective method when dealing with this modern world. This Is based on “BlueOcean Airline Reservation system”. This system provides complete functionalities that fulfil all the requirements of an airline service. Identification of the drawbacks of the existing system leads to the designing of computerized system that will be compatible to the existing system with the system which is more user friendly
7
and more GUI oriented. We can improve the efficiency of the system, thus overcome the drawbacks of the existing system.
1.2 Problem Statement:
This Airline reservation system is developed for automating the activities of an Airline service. The software will be great relief to the passengers and admin. This software will help user in searching flights information, make reservations, cancel reservations and also it will help admin in adding new flights , updating flight information, view the information about passengers. The aim of the Airline Reservation system is to fulfill the passenger and admin requirements through the internet in an efficient way.
1.3 Existing System:
There is a higher risk of errors in manual work and in case of an error it gets tedious to rectify it manually. The passengers have to depend on the airline authority to get their tickets booked or cancelled and this might introduce unforeseen problems due to wrong interpretation while communicating.
1.4 Proposed System:
Airline reservation system allows passengers to find flights as per their convenience and book them at their own discretion. This reduces the dependence on airlines to get the ticket booked. This software provides passengers with all the required information about flights along with the fares for economic and business class. Both domestic and international flights database can be accessed and the passenger is then able to book the tickets as they want. This mainly reduces manual errors.
1.5 Objectives:
This software helps passengers to look up flights between two points which can be domestic or international. The passengers can find and book tickets for flights through this software. Developed in HTML,PHP & CSS, it is fairly easy to use software having a user-friendly interface. The users can access flight information and book tickets as per their convenience. The main objective is to reduce the mistakes which creep up in manual systems. It provides good level of security so it takes care of the user’s safety concerns as well. Passengers can access the whole list of all the flights available on different routes with their timings and fare both for economy and business classes. One can compare the best deals for them and book a flight accordingly. When the passengers enter all the details the software helps them to find all available flights and also information if there are seats available on that particular flight. The manual work is thus reduced and the chances of errors are reduced to minimum.
8
- Operating System- Windows
- Browsers- Firefox
- (^) Scripting Language – HTML, CSS, php, JavaScript
- Notepad++
- Database -MYSQL
CHAPTER TWO:
BACKGROUND
The web application was developed as a Airline Managemenet system to offer passengers’ convenient access to the User Login. Several tools used during implementation include the following:
- SOFTWARE:
i. MYSQL DBMS- it allows combination, extraction, manipulation and organization of data in the databases. It is platform independent and therefore can be implemented and used across several such as Windows, Linux server and is compatible with various hardware mainframes. It is fast in performance, stable and provides business value at a low cost.
ii. HTML- HTTML is the standard markup language for creating web pages. HTML describes the structure of web pages using markup. HTML elements are building blocks of HTML pages. HTML elements are represented by tags.
10
iii. JavaScript- JavaScript is a high – level, interpreted programming language that conforms to the ECMA Script specification. It is a language that is also characterized as dynamic, Weakly typed, Prototype based and multi paradigm.
iv. CSS – Cascading Style Sheets is a style sheet language used for describing the presentation of a document written in a markup language like HTML. CSS is a cornerstone technology of the World Wide Web, alongside HTML and JavaScript.
v. Bootstrap – Bootstrap is a free and open-source front-end web framework. It contains HTML and CSS based design templates for typography, forms, buttons, navigation and other interface components. As well as optional JavaScript extensions. Unlike many earlier web frameworks, it concerns itself with front-end development only.
vi. Testing is done via WAMP SERVER.
v. Web browsers : Mozilla Firefox, Google chrome, and Internet Explorer.
vi. Reporting Tool i.e. through Data Report
CHAPTER THREE:
System Design
3.1 System Analysis
11
AIRLINE
SYSTEM
CANCELLA TIONS
RESERVATI ONS
UPDATIONS
Passenger Admin
13
Add A FlightUpdate FlightsMake Reservations
Serach for flights
View PassengersView Reservations
Cancel Reservations Airline Reservation
View FlightsData BaseFlight InfoRequest for InquiryTicket Reservations & Cancellations
Passenger InfoAdmin and UsersPaymentsData AccessData StoreShow FlightsStart Home PageSearch FlightsSign UpLogin
3.2 Flow Diagram
Use case Diagram
14
Enter UsernameUserInput DetailsInput DetailsAdmin & password
Enter Username & password
Admin PageAdd New FlightView & UpdateAll Fields correct ?User PageAll fields filled?Signed UpValid password?Valid password?yesyesyesyesnonoNoNo Info
View TicketMake/cancel Reservations
CustomerAdministratorOOBooked/cancelledView InformationFlight UpdatedUpdate Flights^ View FlightsFlight AddedView FlightsShow TicketInput DetailsInput DetailsMake/Input DetailsInput DetailsInput DetailsOO
Cancel Reservation s
Print TicketCancel/ Confirm Reservation s
Delete/Edit Users
Make/ Delete Shedule
Show Ticket
Search Flights
Show Schedule
Login or Register
Home Page
Flight
Field Name Data Type Key
id int(11) Primary
flightNumber varchar(256)
Pnr varchar(256) unique
fname varchar (100)
lname varchar(100)
phone varchar(14)
email varchar(256)
dob timestat
dest int(11) key
depart int(11) key
depDate date
depTime time
retDate date
reTime time
amount int(11)
accept int(11)
user varchar(256)
16
location
Field Name Data Type Key
id int(11) Primary name varchar(255)
retlocation
Field Name Data Type Key
id Int(11) Primary name varchar(255)
17
IMPLEMENTATION AND TESTING
This is the second last stage in SDLC (Software Development Life cycle) the installation of the
software is done.
4.1 Installation Guide
The system runs on a server and does not have an .exe or Executable file. Below is the installation process of the system and how it is setup:
Install the WAMP server
Step One
WAMP installs everything you need to run PHP pages and a MySQL database on
your local machine.
- Double-click the Installer (.exe) file you downloaded from the WAMP website.
- The WAMP installer asks you to specify the directory to install WAMP. It is recommended you leave the default setting specified.
- Click Next.
19
Figure 1: WAMP Installation snap
- Finally, select finish and open the WAMP Control Panel.
Step Two
Start your Server
Once installed, you can use the WAMP Control Panel to start all services for testing server.
20