Airlines Reservation DBMS Laboratory with Mini-project
ABSTRACT
Airlines reservation system allows the passengers to enquire and book flights which are
available based on the source, destination, meal preferences and date allotments. This system
will be able to generate report regarding the booking operation. For example, the bookings
done and the booking details of each passenger are maintained in records. This system also
allows us to keep a track of other details regarding the flight through the admin profile. The
main focus of this system are the aeroplane details, bookings and its details along with its
management.
Prototyping approach is applied while developing this system. This will involve an iterative
process to make this system is usable and easy to use by the user. The design will involve
entity relationship diagram (ERD) and Data Flow Diagram (DFD) to show the logical flow for
the system. For the implementation, Apache2 is used as a web server, MySQL as a database,
PHP as a scripting language. The main important while developing any system is to make the
system usable. Overall this system provides a user-friendly environment for airlines booking
management and helps in smooth functioning of the system.
Department of CSE, VVCE Page 1
Airlines Reservation DBMS Laboratory with Mini-project
TABLE OF CONTENTS
CHAPTERS Page No
1. INTRODUCTION
1.1 Overview 04
1.2
1.2 Objective 04
1.3 Existing System 05
1.4 Proposed System 05
2. SYSTEM SPECIFICATION
2.1 Hardware Requirements 06
2.2 Software Requirements 06
3. DESIGN AND IMPLEMENTATION
3.1 Schema Diagram 07
3.2 Entity Relationship Diagram 08
3.3 Introduction to Apache Web Server 09
3.4 Introduction to SQL Server 09
3.5 Introduction to PHP 10
3.6 Functional Requirements 10
4. RESULT
4.1 Snapshots 11
CONCLUSION & FUTURE ENHANCEMENTS 18
REFERENCES 19
Department of CSE, VVCE Page 2
Airlines Reservation DBMS Laboratory with Mini-project
LIST OF TABLES AND FIGURES
TABLE NO./FIGURE NO. Page No
3.1: Schema Diagram 07
3.2: ER Diagram 08
4.1.1 Home Page 11
4.1.2 Customer page 11
4.1.3 Reservation page 12
4.1.4 Flight search page 12
4.1.5 Flight Details Page 13
4.1.6 Admin Loin Page 13
4.1.7 Admin Home Page 14
4.1.8 Aeroplane Details Page 14
4.1.9 Co-Pilot Details Page 15
4.1.10 Hostess Details Page 15
4.1.11: Pilot Details Page 16
4.1.12: Records Page 16
4.1.13: Pilot Records 16
4.1.14: Co-Pilot records 17
4.1.15: Hostess Records 17
4.1.16: Customer Records 18
4.1.17: Aeroplane Records 18
Department of CSE, VVCE Page 3
Airlines Reservation DBMS Laboratory with Mini-project
CHAPTER 1
INTRODUCTION
1.1 OVERVIEW
The main aim of the project is the management of the database of the airlines system for
bookings by creating a database of the flights and their routes. The database is then connected
to the main program by using the interconnection of the PHP program and the database already
created in MySQL.
Every organization, whether big or small, has challenges to overcome and manage the
information of aeroplane details, bookings, pilot details or any other details. “The Airlines
Reservation System” has been developed to over-ride the problems in practising in normal
systems. The software developed is supported to eliminate or reduce the hardships faced in the
existing system.
The Airline Reservation System project is an implementation of general Airline ticketing
website, which helps the customers to search the availability and other preferences of various
Airline tickets with the different packages available. This project also covers various features
like online registration with users, updating the details by the administrator of the website, by
adding the Airline details, co-pilot details, hostess details, pilot details.
1.2 OBJECTIVE
To develop a airlines reservation system which supports the daily booking operation
and for easier data record and retrieval process.
To develop a software which simplifies the communication process between the
customer and the airlines booking counter.
To maintain and reduce complexity in maintain airline records with its bookings
.
Department of CSE, VVCE Page 4
Airlines Reservation DBMS Laboratory with Mini-project
1.3 EXISTING SYSTEM:
The existing system is very complex, waste of time & many more Real-life problem.
There are no valid records of the customers maintained.
It is a more expensive process.
Immediate responses to the queries are difficult.
Lot of time taken for manual reservations
1.4 PROPOSED SYSTEM
To provide a system that the customers find user-friendly and efficient.
This system helps to solve the time-related problem which simplifies the
communication process.
To store the details of not only the flights but also the pilot, co-pilot and hostess details.
The customers can get information about the flights at any time.
This system reduces all the paperwork.
Department of CSE, VVCE Page 5
Airlines Reservation DBMS Laboratory with Mini-project
CHAPTER 2
SYSTEM SPECIFICATION
2.1 HARDWARE REQUIREMENTS
Processor: x64 processor with1.70GHz clock speed.
Hard disc: Minimum 20GB capacity.
RAM: Minimum 512 Mb.
Monitor: VGA or SVGA or higher.
Keyboard: Any keyboard with support for OS
Mouse: Any mouse with support for OS
2.2 SOFTWARE REQUIREMENTS
Database: Microsoft SQL.
Administration tool: Microsoft SQL server management tools.
Editor: Visual Studio Code.
OS: Windows XP or Higher.
Front-end Application: HTML, CSS, Bootstrap.
Back-end: PHP and MYSQL Server 2008 or higher.
Department of CSE, VVCE Page 6
Airlines Reservation DBMS Laboratory with Mini-project
CHAPTER 3
DESIGN & IMPLEMENTATION
3.1 SCHEMA DIAGRAM
aeroplanedetails
AirID City City1 airline reg_date
airlinedetails
CID name age gender Meal class bdate AirID reg_date
pilotdetails
name PID age gender2 airline AirID reg_date
copilotdetails
CPid name age gender PID AirID reg_date
hostessdetails
Hid name age PID AirID reg_date
pilotdetails_bacukup
Name PID age gender2 airline AirID reg_date
Figure 3.1: Schema Diagram
The figure 3.1 shows the schema of the project. It shows the primary key and the foreign key
constraints of the tables.
Department of CSE, VVCE Page 7
Airlines Reservation DBMS Laboratory with Mini-project
3.2 ENTITY RELATION DIAGRAM
Figure 3.2: ER Diagram
The figure 3.2 shows the tables, attributes and the relations between them. It gives overall view
of the tables used in the project.
Department of CSE, VVCE Page 8
Airlines Reservation DBMS Laboratory with Mini-project
3.3 INTRODUCTION TO APACHE WEB SERVER
Apache is a freely available Web server that is distributed under an "open source" license.
Version 2.0 runs on most Unix-based operating systems (such as Linux, Solaris, Digital UNIX,
and AIX), on other UNIX/POSIX-derived systems (such as Rhapsody, BeOS, and
BS2000/OSD), on AmigaOS, and on Windows 2000. Apache has been shown to be substantially
faster, more stable, and more feature-full than many web servers. The most important thing is
apache is able to incorporate with PHP/ MySQL.
3.4 INTRODUCTION TO SQL SERVER
Microsoft SQL Server is a full-featured relational database management system (RDBMS) that
offers a variety of administrative tools to ease the burdens of database development, maintenance
and administration. In this article, we'll cover six of the more frequently used tools: Enterprise
Manager, Query Analyzer, SQL Profiler, Service Manager, Data Transformation Services and
Books Online.
Many database-driven websites that use MySQL use a Web scripting language like PHP to
access information from the database. MySQL commands can be incorporated into the PHP
code, allowing part or all of a Web page to be generated from database information. Because
both MySQL and PHP are both open source, the PHP/MySQL combination has become a
popular choice for database-driven websites.
Department of CSE, VVCE Page 9
Airlines Reservation DBMS Laboratory with Mini-project
3.5 INTRODUCTION TO PHP
PHP (recursive acronym for "PHP: Hypertext Pre-processor") is an Open Source general-
purpose scripting language that suited for Web development and can be embedded into HTML.
The PHP code is executed on the server different from the other side. PHP is focused on server-
side scripting. It can collect form data, generate dynamic page content, or send and receive
cookies.
PHP can be used on all major operating systems. The most important things are PHP is able to
run in Microsoft Windows. PHP has also support for most of the web servers today. Since the
system using Apache as the web server, so it is suitable to choose PHP as the scripting language.
PHP also able to connect to any major database and MySQL is the database for the clinic
management system. PHP and MySQL are able to operate in any operating system. The
communication can be done using common Structured Query Language (SQL).
3.6 FUNCTIONAL REQUIREMENTS
1. Customer:
Ticket booking: Through this module, the user can book the details according to his/her
preferences for the flights.
Ticket details: This module gives the customer an option to print his/her ticket along with
a list of all other customers ticket details.
2. Administrator:
Login module: Through this module, the admin at the airlines company management can
login to register flights.
Flight details: The administrator can input the new flight records in this section.
Pilot and Co-Pilot details: The admin can insert the details of the pilots and the co-pilot in
this slot
Hostess details: Here the details of the hostess are added to the record
Airlines record: The records of the flights, the booked tickets , pilot, co-pilot, hostess and
other records can be viewed.
Department of CSE, VVCE Page 10
Airlines Reservation DBMS Laboratory with Mini-project
CHAPTER 4
RESULTS
4.1 SNAPSHOTS
Home page
Figure 4.1.1: Home Page
Figure 4.1.1 shows the main page of the project
Customer page
Figure 4.1.2: Customer page
Figure 4.1.2 shows the customer page
Department of CSE, VVCE Page 11
Airlines Reservation DBMS Laboratory with Mini-project
Reservation page
Figure 4.1.3: Reservation page
Figure 4.1.3 shows the page for booking flights for customer
Flight search page
Figure 4.1.4: Flight search page
Figure 4.1.4 shows the page where the customer can search for their flights
Department of CSE, VVCE Page 12
Airlines Reservation DBMS Laboratory with Mini-project
Flight Details page
Figure 4.1.5 Flight Details Page
Figure 4.1.5 gives the details about the flight requested to the customer
Admin Login Page
Figure 4.1.6 Admin Loin Page
Figure 4.1.6 shows the login page for the admin with the username and password
Department of CSE, VVCE Page 13
Airlines Reservation DBMS Laboratory with Mini-project
Admin Home Page
Figure 4.1.7 Admin Home Page
Figure 4.1.7 Shows the admin home page with its options
Aeroplane Details Page
Figure 4.1.8 Aeroplane Details Page
Figure 4.1.8 shows the page where the admin can create flight records
Department of CSE, VVCE Page 14
Airlines Reservation DBMS Laboratory with Mini-project
Co-Pilot Details Page
Figure 4.1.9 Co-Pilot Details Page
Figure 4.1.9 Shows the age for the admin to insert co-pilot details to the records
Hostess Details Page
Figure 4.1.10 Hostess Details Page
Figure 4.1.10: Shows the page for the admin to insert Hostess details to record
Department of CSE, VVCE Page 15
Airlines Reservation DBMS Laboratory with Mini-project
Pilot Record
Figure 4.1.13: Pilot Records
Figure 4.1.13 shows the records stored under the pilot details
Co-Pilot Records
Figure 4.1.14: Co-Pilot records
Figure 4.1.14 shows the records stored under the co-pilot details
Hostess Records
Figure 4.1.15: Hostess Records
Figure 4.1.15 shows the records stored under the hostess details
Department of CSE, VVCE Page 16
Airlines Reservation DBMS Laboratory with Mini-project
Customer Details
Figure 4.1.16: Customer Records
Figure 4.1.17 shows the records stored about the customer bookings
Aeroplane Records
Figure 4.1.17: Aeroplane Records
Figure 4.1.17 shows the records stored under the aeroplane details
Department of CSE, VVCE Page 17
Airlines Reservation DBMS Laboratory with Mini-project
CONCLUSION AND FUTURE ENHANCEMENT
CONCLUSION
This system can be implemented in any of the airlines across the world without any problem.
This user-friendly system interface does not need any training for the employees to use. The
system is self-explanatory.
LIMITATIONS OF PROJECT
Any errors during insertion will be stored as it is if the user is ignorant.
Without the system it is not possible to use the project.
Backup is required.
FUTURE ENHANCEMENTS
Due to specific time for the project, the current project has limited information and can be developed and
enhanced for the further use. The various enhancements that can be made in the software are as below:
We can add the facility for help in the software
We can add a SMS notification for the bookings made
Department of CSE, VVCE Page 18
Airlines Reservation DBMS Laboratory with Mini-project
REFERENCES
1. Database Management Systems, McGraw Hill
2. www.w3school.com
3. www.mysqltutorial.org
4. programmerblog.net
Department of CSE, VVCE Page 19
Airlines Reservation DBMS Laboratory with Mini-project
Department of CSE, VVCE Page 20
