[Link].

CONTTEXT Page
no.
2
1. Introduction
1.1 Project Profile
4
2.
Development Environment
2.1 Hardware / Software Specification
2.2 Front End
2.3 Back End
7
3. Objective & Scope
3.1 Scope Of The Current System
3.2 Current System
9
4. Requirement Analysis
4.1 E-R Diagram
4.2 DFD
4.3 Process Specification
4.4 Data Dictionary
18
5. User’s Manual
5.1 Screen Layout
5.2 Testing
25
6. Future Scope
6.1 Future Scope
6.2 Bibliography

51-ZIEEL R. GUJJAR Page 1

 Introduction
1.1 Project Profile

51-ZIEEL R. GUJJAR Page 2

 1. Introduction
1.1 Project Profile

The Airline Ticket Booking System

(My Flying) is a web-based application that allows
passengers to:
 Search available flights.
 Register and log in securely.
 Book flights by selecting seats and passengers.
 Make payments online.
 View general information such as contact details
and about the airline.
This system is built using PHP, MySQL,
HTML, CSS, Bootstrap, and JavaScript (with
AJAX/JSON support) for dynamic operations.

51-ZIEEL R. GUJJAR Page 3

 Development
Environment
2.1 Hardware / Software Specification
2.2 Front End
2.3 Back End

51-ZIEEL R. GUJJAR Page 4

 Development Environment
2.1 Hardware / Software Specification
 Hardware:
o Processor 12th Gen Intel i5
o RAM: 8 GB
o Storage: 20 GB free space
 Software:
o Operating System: Windows
o Web Server: Apache (via XAMPP)
o Database: MySQL
o Language: PHP , JavaScript
o Tools: VS Code
2.2 Front End
 HTML5, CSS3
 Bootstrap 5 for responsive design
 JavaScript for interactivity
51-ZIEEL R. GUJJAR Page 5
 AJAX + JSON for flight search and booking data
exchange
2.3 Back End
 PHP for server-side scripting
 MySQL for database storage and retrieval

51-ZIEEL R. GUJJAR Page 6

 Objective &
Scope
3.1 Scope Of The Current System
3.2 Current System

51-ZIEEL R. GUJJAR Page 7

 Objective & Scope
3.1 Scope of Current System
 Secure user registration and login.
 Search flights by source, destination,
and date.
 Book flights and manage passenger
details.
 Payment simulation with confirmation.
 Static information pages (About Us,
Contact).
3.2 Limitations (Excluded Scope)
 Admin management system (flight
CRUD).
 Real payment gateway integration
(currently simulated).
 Ticket cancellation and refund process.

51-ZIEEL R. GUJJAR Page 8

 Requirement
Analysis
4.1 E-R Diagram
4.2 DFD
4.3 Process Specification
4.4 Data Dictionary

51-ZIEEL R. GUJJAR Page 9

 Requirement Analysis
4.1 E-R Diagram
Requirement Analysis is the most critical
phase of software development. It identifies
what the system should do, how users
interact, and what data is processed. The
Flying Airline Ticket System is analyzed using
ERD, DFDs, process specifications, and a
complete data dictionary.

51-ZIEEL R. GUJJAR Page 10

Entities:
 Users (id, username, password, email, etc.)
Column Data type key Descripti
on
Id INT UNSIGNED PK Unique
AI user ID
Username VARCHAR(50) UNIQ Login
UE username
Password_hash VARCHAR(255) Hashed
password
Full_name VARCHAR(120) Full
name of
user
Email VARCHAR(150) UNIQ User
UE email
Phone VARCHAR(30) Phone
number
City VARCHAR(80) City
state VARCHAR(80) state

51-ZIEEL R. GUJJAR Page 11

 Flights (id, airline, flight_no, from_city,
to_city, depart, arrive, price, seats)
Column Date type key Description
Id INT PK Unique flight
UNSIGNED ID
AI
Airline VARCHAR(10 Airline name
0)
Flight_no VARCHAR(50 Flight number
)
From_city VARCHAR(12 Departure city
0)
To_city VARCHAR(12 Arrival city
0)
Depart DATETIME Departure date
& time
Arrive DATETIME Arrival date &
time
INT INT Duration in
UNSIGNED (Generated) minutes
Price DECIMAL(10, Ticket price
2)
seats_total INT Total seats
UNSIGNED
seats_availabl INT Remaining
e UNSIGNED seats

51-ZIEEL R. GUJJAR Page 12

 Bookings (id, user_id, flight_id, passengers,
total_price, status)
Column Date type key Description
Id INT PK Unique
UNSIGNED booking ID
AI
User_id INT FK → User who
UNSIGNED users(id) made booking
Fight_id INT FK → Flight booked
UNSIGNED flights(id)
Passengers SMALLINT Number of
UNSIGNED passengers
total_price DECIMAL(10 Total booking
,2) amount
booking_sta ENUM pending,
tus confirmed,
cancelled
created_at TIMESTAMP DEFAULT Booking
NOW creation time
updated_at TIMESTAMP NULL Updated when
modified

51-ZIEEL R. GUJJAR Page 13

 Payments (id, booking_id, user_id, amount,
method, status, transaction_id)
Column Data type key Description
Id INT UNSIGNED PK Unique
AI payment ID
Booking_id INT UNSIGNED FK → Related
book_flig booking
ht(id)
User_id INT UNSIGNED FK → Payer
users(id)
Amount DECIMAL( 0,2) Amount paid
Payment_metho VARCHAR( 50) e.g., card,
d UPI,
netbanking
Payment_status ENUM pending,
success,
failed
Transaction_id VARCHAR(120) Payment
gateway
transacti on
reference
Paid_at TIMESTAMP NULL When
payment
completed

51-ZIEEL R. GUJJAR Page 14

Relationships:
 One user → Many bookings
 One flight → Many bookings
 One booking → One payment
4.2 Data Flow Diagram (DFD)
 Level 0: User interacts with system (Login,
Search, Book, Pay).

51-ZIEEL R. GUJJAR Page 15

 Level 1:
o Login/Register → Users Table
o Search Flights → Flights Table
o Book Flight → Bookings Table
o Payment → Payment Table

4.3 Process Specification

[Link]/Registration: User authentication with
password hashing.
51-ZIEEL R. GUJJAR Page 16
[Link] Search: Query flights table based on
source, destination, and date.
[Link]: Store passenger count, calculate
price, update seat availability.
[Link]: Insert record into Payment table,
update booking status.
4.4 Data Dictionary
 Users: Stores registered passenger details.
 Flights: Stores flight schedule and pricing.
 Bookings: Stores flight reservations made by
users.
 Payments: Stores payment confirmations for
bookings.

51-ZIEEL R. GUJJAR Page 17

 User’s
Manual

51-ZIEEL R. GUJJAR Page 18

 User’s Manual
5.1 Screen Layout (Main Pages)
[Link]/Home Page: Flight search form

[Link] Page: Create new account.

51-ZIEEL R. GUJJAR Page 19

[Link] Page: Access account with credentials.

[Link] Search Page: Search results with

booking options.

51-ZIEEL R. GUJJAR Page 20

[Link] Page: Select passengers and proceed
to payment.

[Link] Page: Payment method selection

(simulated).

51-ZIEEL R. GUJJAR Page 21

[Link] Us Page: Submit message form.

[Link] Us Page: Information about the airline.

51-ZIEEL R. GUJJAR Page 22

9. My Ticket Page: Showing your Booking
Ticket

5.2 Testing
 Unit Testing:
o Registration validation, login authentication.
o Flight search queries returning correct results.
o Booking updates reducing available seats.
o Payment updates booking status to confirmed.

51-ZIEEL R. GUJJAR Page 23

 Integration Testing:
o Register → Login → Search → Book → Pay
→ Confirm flow tested end-to-end.
 Security Testing:
o Passwords hashed using password_hash().
o Prepared statements to prevent SQL injection.

51-ZIEEL R. GUJJAR Page 24

 Future Scope
6.1 Future Scope
6.2 Bibliography

51-ZIEEL R. GUJJAR Page 25

 Future Scope
6.1 Future Scope
 Add Admin Panel for flight schedule
management.
 Integrate real payment gateway
(Stripe/PayPal/Razorpay).
 Enable e-ticket generation (PDF with QR
code).
 Add cancellation and refund module.
 Provide multi-language support for global
users.
6.2 Bibliography
 PHP Official
Documentation([Link]
 MySQL Documentation
([Link]

51-ZIEEL R. GUJJAR Page 26

 Bootstrap 5 Documentation
([Link]
 W3Schools, GeeksforGeeks (for tutorials and
references)
 Chatgpt

51-ZIEEL R. GUJJAR Page 27