Skip to content

readme.md

Latest commit

 

History

History
116 lines (85 loc) · 4.09 KB

readme.md

File metadata and controls

116 lines (85 loc) · 4.09 KB
Raw

Typing SVG

📚 About The Project

This **Airline Management System** is a comprehensive solution that helps manage flights, passengers, pilots, planes, and ticket bookings. It features a backend built using MySQL (MariaDB) and a frontend developed with JavaFX. The system allows airline operators to manage flight details, book tickets, manage passengers, pilots, and airplanes, and keep track of all transactions.

💻 Technologies Used:

  • Backend: MySQL (MariaDB)
  • Frontend: JavaFX
  • Database Management: MySQL (MariaDB)

💡 Core Features:

  • Manage Flights: Add, edit, or delete flight details.
  • Passenger Management: Store passenger information and associate them with booked tickets.
  • Ticket Booking: Issue, track, and cancel tickets with details of class, amount, source, and destination.
  • Pilot Management: Add pilot details and assign pilots to flights.
  • Plane Management: Track and manage details of all planes, including their names and capacities.

🔧 Languages & Tools
Java Java Java


🖼 Entity Relationship Diagram (ERD)

ERD Diagram

⚙️ Setup & Installation

Prerequisites:

  • MySQL (MariaDB) installed.
  • Java installed along with JavaFX setup.
  • You will also need an IDE like IntelliJ IDEA or Eclipse to run the JavaFX application.

Steps to Run:

  1. Set Up Database:
    • Create a database in MySQL:
    CREATE DATABASE airline;
USE airline;
  2. Import SQL Dump:
    • Import the provided SQL file to create the necessary tables and insert sample data into the database.
  3. Run JavaFX Application:
    • Open the project in an IDE like IntelliJ IDEA or Eclipse.
    • Ensure that your MySQL connection credentials are properly configured in the JavaFX app.
    • Run the project to start managing flights, passengers, and tickets.

📈 Database Structure

Tables:

  • flighttable: Contains flight details such as name, plane name, source, destination, departure, and arrival time.
  • passengertable: Holds passenger information, linked to ticket details.
  • pilottable: Stores pilot details such as name, contact, and address.
  • planetable: Contains airplane details including plane name and capacity.
  • tickettable: Manages ticket details, including flight information, class, and fare.

Example Data:

  • Flight: "smith flight", "mumbai", "delhi", Economy Fare: 400, Business Fare: 600.
  • Passenger: Arnold, Mark, Age: 50, Gender: Male.
  • Ticket: Source: Mumbai, Destination: Delhi, Amount: 800.

🔮 Future Improvements
  • Implement User Authentication for Admin.
  • Add Real-time Flight Tracking functionality.
  • Extend the system to allow for Flight Cancellations and Reservation Modifications.

📬 Contact

 Feel free to reach out for any inquiries or suggestions related to the project!

LinkedIn: Vrukshal Patel