This project was developed as part of my Class 12 Computer Science coursework using Python and MySQL.
The system handles basic airport operations by allowing administrators to manage flights, seat records, and passenger information, while passengers can search for flights, make bookings, and view their booking details.
- Add new flight records
- Update flight details
- Delete flight records
- Manage seat availability
- View passenger records
- Verify passenger passport status
- View flight and seat details
- View available flights
- Book flight tickets
- Cancel bookings
- Check booking details
- Track passport verification status
- PDF Boarding Pass Generation
- PDF Flight Receipt Generation
- Automatic seat availability updates
- MySQL database integration
- Menu-driven interface
- Python
- MySQL
- PyMySQL
- ReportLab
- Tabulate
- pymysql
- tabulate
- reportlab
- datetime
- os
- webbrowser
- CRUD Operations
- SQL Joins
- Relational Database Design
- Database Connectivity
- Connecting Python with MySQL databases
- Writing SQL queries for data management
- Working with multiple related tables
- Implementing a booking workflow
- Generating PDF documents using Python
- Building a menu-driven application
The MySQL database was created on the school laboratory system and is not currently included in this repository.