Expense Management System

A console-based Expense Management System developed using Python and MySQL. The application allows users to manage expenses through CRUD operations and perform spending analysis using SQL aggregate functions.

Features

• Add Expense
• View Expenses
• Update Expense
• Delete Expense
• Total Spending
• Highest Expense
• Category-wise Summary
• Expense Count
• Menu Driven Interface
• Exception Handling

Technologies Used

• Python
• MySQL
• mysql-connector-python

Database Design

Table: expenses

Column	Type
expense_id	INT AUTO_INCREMENT PRIMARY KEY
amount	DECIMAL(10,2)
category	VARCHAR(50)
description	VARCHAR(255)
expense_date	DATE

SQL Concepts Used

• INSERT
• SELECT
• UPDATE
• DELETE
• SUM()
• COUNT()
• GROUP BY
• ORDER BY
• LIMIT

Project Structure

Expense_Management_System/

├── main.py

├── database.py

├── schema.sql

├── requirements.txt

└── README.md

How to Run

1. Create database using schema.sql
2. Install dependencies

pip install -r requirements.txt

3. Run the application

python main.py

Learning Outcomes

• Python Functions
• MySQL Integration
• CRUD Operations
• Aggregate Functions
• Exception Handling
• Database Connectivity
• Menu Driven Applications

Future Enhancements

• Monthly Expense Reports
• Expense Search
• CSV Export
• Budget Tracking
• Data Visualization