# Airline Reservation System 🛫

A terminal-based Airline Reservation System built with Python and MySQL.

## Features

- Register customer details

- Book tickets (First, Business, Economy class)

- Calculate ticket price + luggage charges

- View individual customer bill

- View all customer records

## Tech Stack

- Python 3

- MySQL

- mysql-connector-python

- python-dotenv

## How to Run

1. Clone the repo

git clone https://github.com/aditimiss55-cmyk/Airline-System-Python.git

2. Install dependencies

pip install -r requirements.txt

3. Create a .env file

cp .env.example .env

Add your MySQL password to .env

4. Set up MySQL database

Create a database called 'airline'

Create tables: pdata and tkt

5. Run the program

python main.py

## Database Schema

pdata table:

- custno (INT, PRIMARY KEY)

- custname (VARCHAR)

- addr (VARCHAR)

- jrdate (VARCHAR)

- source (VARCHAR)

- destination (VARCHAR)

tkt table:

- custno (INT)

- tkt_tot (INT)

- lug_tot (INT)

- g_tot (INT)

## Author

Aditi Guptas| 2026