Flight Occupancy Report for Web Application

Objective

The Flight Occupancy Report provides detailed insights into the occupancy status of flights in a web application developed using PHP, Bootstrap, and MySQL as the database. It aims to analyze the flight occupancy trends, identify the top occupied flights, and provide user statistics for the web application. Additionally, the report highlights the key features and design aspects of the web application, including the database structure.

Database Structure

The web application utilizes a MySQL database with the following tables:

• aircraft: Stores information about aircraft, including the maximum weight, number of seats, manufacture date, name, and model.
• flight: Contains details about flights, such as departure and arrival locations, departure and arrival times, price, aircraft ID, and airline.
• seat: Represents seats available on aircraft, linked to the corresponding aircraft ID.
• user: Stores user information, including first name, last name, email, phone, address, password, and role.
• reservation: Manages reservations made by users, including the user ID, flight ID, seat ID, and date.
• payment: Stores payment details for reservations, including the reservation ID, payment date, amount, and payment method.

Key Features of the Web Application

1. User Interface: The web application provides separate interfaces for users and administrators.
2. User Management: Users can sign up, log in, and edit their profile details.
3. Flight Management: Administrators can add and update aircraft and flight details.
4. Flight Search: Users can search for available flights based on criteria such as date, source, destination, and required number of seats.
5. Flight Operations: Users can book, cancel, and change flight class for their reservations.
6. Impressive Welcome Page: The web application features a visually appealing welcome page with a carousel showcasing modern and epic aircraft.
7. Admin Privileges: Administrators have the ability to delete flights, and users can delete seats.
8. Neumorphic Design: The web application follows an eye-comfortable design approach using neumorphism for the user interface.

Conclusion

The Flight Occupancy Report highlights the key functionalities and design elements of the web application developed using PHP, Bootstrap, and MySQL. The report provides insights into the occupancy status of flights, user statistics, and database structure. The web application aims to deliver a user-friendly experience with efficient flight management and reservation capabilities. With its visually appealing design and robust features, the web application offers a seamless flight booking experience for users and effective administration for managing flights and aircraft.