✈️ Air Ticket Management System (ATMS)

A comprehensive flight booking and management system built with Python and MySQL. This console-based application provides a complete solution for managing airline tickets, destinations, and customer bookings with separate user and admin interfaces.

📋 Table of Contents

Features
Tech Stack
Database Schema
Installation
Usage
Project Structure
User Features
Admin Features
Screenshots
Contributing
License

✨ Features

🔐 Dual Role System

User Portal: Customer registration, login, flight booking, and ticket management
Admin Portal: Flight management, pricing control, and customer data oversight

🎫 Comprehensive Booking System

Multi-passenger booking support
Three travel classes: Economy, Business, First Class
Age-based pricing (Adult, Child, Infant)
Domestic and International flight options
Real-time availability checking

📊 Data Management

Secure user authentication
Profile management and updates
Complete booking history
Flight cancellation capabilities

🛠 Tech Stack

Language: Python 3.x
Database: MySQL
Libraries:
- mysql-connector-python - Database connectivity
- random - User ID generation

🗄 Database Schema

The system uses 4 main tables:

1. Users Table

User_Id (INT, PRIMARY KEY)
User_Name (VARCHAR)
User_Age (INT)
User_Email (VARCHAR, UNIQUE)
User_Pwd (VARCHAR, UNIQUE)
User_Phone (VARCHAR, UNIQUE)

2. Admins Table

Admin_Id (INT, PRIMARY KEY)
Admin_Name (VARCHAR)
Admin_Age (INT)
Admin_Email (VARCHAR, UNIQUE)
Admin_Pwd (VARCHAR, UNIQUE)

3. Destinations Table

Flight_Code (INT, PRIMARY KEY)
Airline (VARCHAR)
FROM_ (VARCHAR)
TO_ (VARCHAR)
Type_Of_Flight (VARCHAR) -- Domestic/International
Airport (VARCHAR)

4. Ticket_Price Table

Flight_Code (INT, PRIMARY KEY)
Adult (INT)
Child (INT)
Infant (VARCHAR) -- "ON LAP"

5. Customers Table

Customer_Id (INT)
Customer_Name (VARCHAR)
Customer_Age (INT)
Customer_Phone (VARCHAR)
Airline (VARCHAR)
FROM_ (VARCHAR)
TO_ (VARCHAR)
Travel_Class (VARCHAR)
Type_Of_Flight (VARCHAR)
Airport (VARCHAR)
Date (VARCHAR)
Time (VARCHAR)
Ticket_Price (INT)

🚀 Installation

Prerequisites

Python 3.6 or higher
MySQL Server 5.7 or higher
pip (Python package installer)

Step-by-Step Setup

Clone or Download the Repository

cd "ATMS (AIR TICKET MANAGEMENT SYSTEM)"

Install Required Python Packages
```
pip install mysql-connector-python
```

Configure MySQL Database

Update the database credentials in Main Program.py:

mycon = mysql.connector.connect(
    host = 'localhost',
    user = 'root',
    password = 'YOUR_PASSWORD',  # Change this
    database = 'ATMS'
)

Create Database and Tables

Run the SQL script to set up the database:
```
mysql -u root -p < "SQL CODE FOR CREATING SAMPLE DATABASE & TABLES.txt"
```
Or manually execute the SQL commands in MySQL Workbench/Command Line.
Verify Database Setup
```
mysql -u root -p
```
```
USE ATMS;
SHOW TABLES;
```
You should see: Admins, Customers, Destinations, Ticket_Price, Users

💻 Usage

Running the Application

python "Main Program.py"

Login Options

As a User:

Option 1: Press 1 at the main menu

Sample User Credentials (from database):

Email: guruji@gmail.com
Password: #7777

Option 2: Create a new account by selecting option 1 when prompted

As an Admin:

Option 1: Press 2 at the main menu

Sample Admin Credentials (from database):

Email: gaurav23@gmail.com
Password: #2323

📁 Project Structure

ATMS (AIR TICKET MANAGEMENT SYSTEM)/
│
├── Main Program.py                              # Main application file
├── SQL CODE FOR CREATING SAMPLE DATABASE & TABLES.txt  # Database setup script
│
├── Admin Table.py                               # Admin table creation utility
├── Destinations.py                              # Destinations table creation utility
├── Ticket_Price.py                              # Ticket price table creation utility
├── User & Customer Table.py                     # User/Customer table creation utility
│
├── ADMINS TABLE.png                             # Database schema screenshot
├── DESTINATIONS TABLE.png                        # Database schema screenshot
├── TICKET PRICE TABLE.png                       # Database schema screenshot
│
├── ATMS PROJECT.docx                            # Project documentation (Word)
├── ATMS PROJECT.pdf                             # Project documentation (PDF)
├── FINAL PROJECT along with SYNOPSIS.pdf        # Complete project with synopsis
├── Synopsis.pdf                                 # Project synopsis
│
└── README.md                                    # This file

👤 User Features

1. Account Management

✅ Create Account: Register with unique email, phone, and password
✅ Login: Secure authentication system
✅ View Profile: Check account details
✅ Update Profile: Modify name, age, email, phone, and password

2. Flight Operations

🔍 Browse Flights: View all available flights
- All flights
- Domestic flights only
- International flights only
🎫 Book Tickets:
- Select origin and destination
- Choose travel class (Economy/Business/First)
- Select date and time
- Multi-passenger booking
- Automatic age-based pricing
📄 View Bookings: Check all tickets booked using your phone number
❌ Cancel Flights:
- Cancel all bookings
- Cancel specific passenger tickets

3. Pricing Structure

Category	Age Range	Base Price
Adult	12+ years	Full price
Child	3-11 years	Reduced price
Infant	0-2 years	Free (On Lap)

Class Multipliers:

Economy: 1x base price
Business: 5x base price
First Class: 10x base price

👨‍💼 Admin Features

1. Flight Management

📋 View Flights: Browse all/domestic/international flights
✏️ Update Flights: Modify airline, route, type, and airport details
➕ Add Destinations: Add new flight routes
🗑️ Delete Destinations: Remove flight routes

2. Pricing Management

💰 View Ticket Prices: Check pricing for all flights
🔄 Update Prices: Modify adult and child ticket prices
➕ Add Price Entries: Add pricing for new flights
🗑️ Delete Price Entries: Remove pricing records

3. Monitoring

📊 Customer Details: View all booking records
👥 User Details: Access registered user information

📸 Screenshots

The project includes visual documentation of database tables:

ADMINS TABLE.png - Admin table structure
DESTINATIONS TABLE.png - Flight destinations
TICKET PRICE TABLE.png - Pricing information

🎯 Sample Flights

Domestic Flights

Code	Airline	From	To	Airport
1	SpiceJet	Delhi	Mumbai	Safdarjung Airport
3	IndiGo	Delhi	Chennai	Delhi Airport
6	GoAir	Bengaluru	Delhi	Kempegowda International Airport

International Flights

Code	Airline	From	To	Airport
2	Air India	Delhi	New York	Indira Gandhi International Airport
4	Emirates	Mumbai	Dubai	Mumbai International Airport
5	Thai Airways	Mumbai	Bangkok	Chhatrapati Shivaji Maharaj International Airport

🔒 Security Features

✅ Unique email validation (prevents duplicate accounts)
✅ Unique password enforcement
✅ Unique phone number verification
✅ Secure login authentication
✅ Role-based access control (User vs Admin)

📝 Database Setup Utilities

The project includes helper scripts for database initialization:

Admin Table.py: Creates and populates the Admins table
Destinations.py: Creates and populates flight destinations
Ticket_Price.py: Creates and populates ticket pricing
User & Customer Table.py: Creates user and customer tables

🐛 Known Limitations

Console-based interface (no GUI)
Passwords stored in plain text (not recommended for production)
No email verification system
No payment gateway integration
Limited search and filter options
No seat selection feature

🔮 Future Enhancements

🤝 Contributing

This is an academic project. If you'd like to use or extend it:

Fork the repository
Create a feature branch
Make your changes
Test thoroughly
Submit a pull request

📄 License

This project is created for educational purposes as a 12th grade Computer Science project.

📧 Support

For issues or questions related to this project, please refer to the documentation files:

ATMS PROJECT.pdf - Complete project documentation
Synopsis.pdf - Project overview and synopsis
FINAL PROJECT along with SYNOPSIS.pdf - Comprehensive project report

Made with ❤️ using Python & MySQL

Air Ticket Management System - Making Flight Booking Simple

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
SimpleAirlinesBookingSystem_PYTHON		SimpleAirlinesBookingSystem_PYTHON
.DS_Store		.DS_Store
ADMINS TABLE.png		ADMINS TABLE.png
AK12.py.txt		AK12.py.txt
ATMS PROJECT.docx		ATMS PROJECT.docx
ATMS PROJECT.pdf		ATMS PROJECT.pdf
Admin Table.py		Admin Table.py
DESTINATIONS TABLE.png		DESTINATIONS TABLE.png
Destinations.py		Destinations.py
FINAL PROJECT along with SYNOPSIS.pdf		FINAL PROJECT along with SYNOPSIS.pdf
Main Program.py		Main Program.py
README.md		README.md
SQL CODE FOR CREATING SAMPLE DATABASE & TABLES.txt		SQL CODE FOR CREATING SAMPLE DATABASE & TABLES.txt
Synopsis.pdf		Synopsis.pdf
TICKET PRICE TABLE.png		TICKET PRICE TABLE.png
Ticket_Price.py		Ticket_Price.py
User & Customer Table.py		User & Customer Table.py

AryanV-Coder/ATMS

Folders and files

Latest commit

History

Repository files navigation