A project developed as part of the Cisco Data Analyst Apprenticeship Program
A lightweight and intuitive Flight Management System built with Python and SQLite. Designed as a learning project, it demonstrates how to manage data with CRUD operations in a clean and structured way — from creating flights to updating, deleting, and retrieving them.
Whether you’re a beginner exploring databases in Python or someone who loves tinkering with console apps, this project will feel both simple and powerful.
- Add new flights with airline, route, timing, seats & price.
- View all available flights in a neat, readable format.
- Search flights by ID.
- Update existing flight details (only what you want to change).
- Delete flights with a single command.
- Persistent storage with SQLite (so your data survives restarts).
- Optional in-memory version (no database needed).
.
├── flight.py # Flight model (defines what a flight is)
├── flight_manager.py # Core logic + menu interface
├── flights.db # Auto-created SQLite database (if not present)
-
Clone this repository
git clone https://github.com/yourusername/flight-management-system.git cd flight-management-system -
Run the program
python flight_manager.py
-
Database
- The system will auto-create
flights.dbon first run. - No extra setup required!
- The system will auto-create
When you run the program, you’ll see a menu-driven console interface:
===== Flight Management System =====
1 - Add Flight
2 - View All Flights
3 - View Flight By ID
4 - Update Flight
5 - Delete Flight
6 - Exit
👉 Choose an option, follow the prompts, and manage your flights.
- Language: Python 3.x
- Database: SQLite3 (built-in, no extra install)
- Style: Simple console app
This project started as a way to explore practical database handling in Python while keeping things approachable. Instead of drowning in boilerplate, I wanted a hands-on system that’s easy to run, modify, and extend.
Perfect for:
- Students practicing CRUD operations
- Beginners learning SQLite with Python
- Anyone curious about building menu-based apps
- ✨ Add search by airline, origin, or destination
- 📊 Export flights to CSV/Excel
- 🌐 Build a web frontend (Flask/Django)
- 🔑 Add authentication for admin use
If you’ve got ideas to make this system better — more features, cleaner UI, or new integrations — feel free to fork, experiment, and raise a PR.
This project is developed as part of the Cisco Data Analyst Apprenticeship Program. All rights and materials belong to Cisco and are intended strictly for educational and apprenticeship training purposes.