A menu-driven Bank Management System developed using Python and MySQL that simulates basic banking operations through a simple command-line interface.

This project demonstrates the integration of Python with MySQL by implementing real-world banking functionalities such as account management, deposits, withdrawals, balance enquiry, transaction history, and customer search operations.

• Create New Bank Account
• Modify Existing Account Details
• Close Bank Account
• View Account Information
• Display All Customer Accounts

• Deposit Money
• Withdraw Money
• Check Account Balance

• Search Customer using Aadhaar Number
• Search Customer using Mobile Number

• Maintain Transaction History
• Record Deposit & Withdrawal Transactions
• Automatically Update Account Balance

• Display Closed Accounts
• Menu-driven Interface
• MySQL Database Integration

• 🐍 Python
• 🗄️ MySQL
• 🔗 MySQL Connector for Python
• 💻 SQL

The project uses two MySQL tables.

Stores customer information including:

• Account Number
• Customer Name
• Gender
• Aadhaar Number
• Mobile Number
• Current Balance
• Account Status (Active / Closed)

Stores complete transaction history including:

• Account Number
• Transaction Type (Deposit / Withdrawal)
• Transaction Amount
• Transaction Date
• Updated Account Balance

✅ Create New Account

✅ Deposit Money

✅ Withdraw Money

✅ Balance Enquiry

✅ Modify Customer Details

✅ View Account Details

✅ Display All Accounts

✅ Search by Aadhaar Number

✅ Search by Mobile Number

✅ View Transaction History

✅ Close Account

✅ Display Closed Accounts

bank-management-system/
│
├── bank_management_system.py
└── README.md

1. Install Python.
2. Install MySQL Server.
3. Create the required database and tables.
4. Update the database connection credentials in the Python file (if required).
5. Run the program.

python bank_management_system.py

• Python Functions
• Menu-driven Programming
• Conditional Statements
• Loops
• SQL Queries
• CRUD Operations
• Database Connectivity
• Transaction Management

• 🔐 User Login Authentication
• 🔒 Password Encryption
• 🖥️ GUI using Tkinter
• 📧 Email Notifications
• 📄 PDF Account Statements
• 🌐 Online Banking Features

Sugandhi

🎓 Student | Python | SQL | Data Science | AI & Machine Learning Enthusiast

If you found this project interesting, consider giving this repository a ⭐.

Thank you for visiting!