MiniBank

A simple desktop banking application built with Python and Tkinter, with data stored in MySQL. Supports basic banking operations like deposits, withdrawals, and transfers, and logs all transactions.

---

Features

• User authentication (username & password)
• Check balance
• Deposit money
• Withdraw money
• Transfer funds between users
• Transaction history
• MySQL database integration
• Simple and clean GUI interface

---

Technologies Used

• Python 3
• Tkinter – GUI framework
• MySQL Connector – connect and interact with MySQL database
• SQL (Minibank-4.sql) – database and table setup

---

Installation

Clone the repository:

git clone https://github.com/ErkanSoftwareDeveloper/minibank.git
cd minibank

Install dependencies:

pip install -r requirements.txt

---

Database Setup

Use the included Minibank-4.sql file to create the database, tables, and sample data:

-- Temporarily disable foreign key checksSET FOREIGN_KEY_CHECKS =0;
-- Drop old tables if they existDROPTABLE IF EXISTS transactions;
DROPTABLE IF EXISTS users;
-- Re-enable foreign key checksSET FOREIGN_KEY_CHECKS =1;
-- Create users tableCREATETABLEusers(
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) UNIQUE NOT NULL,
password VARCHAR(100) NOT NULL,
balance DECIMAL(10,2) DEFAULT 0.00,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB;
-- Create transactions tableCREATETABLEtransactions (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INTNOT NULL,
type ENUM('deposit','withdraw','transfer') NOT NULL,
amount DECIMAL(10,2) NOT NULL,
details VARCHAR(255),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT fk_user FOREIGN KEY (user_id) REFERENCES users(id)
) ENGINE=InnoDB;
-- Insert example usersINSERT INTO users (username, password, balance)
VALUES
('Ali', '1234', 500.00),
('Ayse', 'abcd', 1000.00),
('Mehmet', 'pass', 750.00);
-- Insert example transactionsINSERT INTO transactions (user_id, type, amount, details)
VALUES
(1, 'deposit', 200.00, 'Salary deposited'),
(1, 'withdraw', 50.00, 'Grocery shopping'),
(2, 'transfer', 100.00, 'Sent to Ali');

Make sure your MySQL server is running and credentials in mini_bank.py are correct.

---

Usage

Run the application:

python mini_bank.py

1. Login with a username and password
2. View balance, deposit, withdraw, or transfer money
3. Check transaction history within the application
4. All changes are saved to the MySQL database

---

📁 Project Structure

minibank/
├─ mini_bank.py # Main application file
├─ Minibank-4.sql # SQL file to create database and sample data
├─ .gitignore # Git ignored files
├─ README.md # Project documentation
└─ requirements.txt # Project dependencies

---

Picture

---

Possible Improvements

• Password hashing for security
• Multi-user login with session management
• Export transaction history as CSV or PDF
• Dark / light UI theme
• Packaging as executable (.exe)

---

License

This project is intended for educational and personal use.