Banking-Management-System

I've tried to implement banking system to some extent using Python3. It's only works in cmd/terminal mode. Just made this as a warm-up project for practicing Python and MySQL.

Requirements :-

Python3
Twilio
MySQL
(Optional) Internet connection (either slow or fast) - It is used only for sending sms to customer mobile number.

Other Python Modules : -

Tabulate
Playsound

How to install Requirements :-

Python3 can be installed from their official site https://www.python.org/ . Or you can use anaconda environment.
Twilio can be installed using PIP :-

pip3 install twilio

You can install MySQL by following the procedure mentioned in official documentation on : -

For Linux : https://dev.mysql.com/doc/refman/8.0/en/linux-installation.html
For WIndows : https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

Yeah, you should refer to youtube or stackoverflow for its installation XD.

Playsound can be installed using PIP :-

pip3 install playsound

Description & Features :-

This project includes implementation of some of common task of Banking-System.
SMS Banking also available. You'll be notified every time any transaction(deposit/withdraw) or update in any of your existing data is made.
Currency counting sound and error sound are also available.

Getting Started :-

Admin credentials (You can change it in program)
admin_id = 0000
admin_passwd = 'root'
Start your MySQL server : For windows -> C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld"
For Linux -> sudo systemctl start mysql
(Optional) You can check your MySQL server :
For windows - "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqlshow" -u root mysql
For Linux - "sudo mysql -u <username> -p"
It might ask you for password, then enter your MySQL password. Replace < username > with your MySQL username.
Go login at Twilio Console and set up your account and get your credentials(ACCOUNT_SID, AUTH_TOKEN) and a phone number for sending sms. For more info you can look at :- Twilio Python SMS

Once you get your credentials and twilio mobile number place it in code at proper place(shown in below screenshot)
Run the file by typing following command :-

python3 Banking-Management-System.py

Intially after program runs, it will ask you for hostname, username, password, database name.
Enter hostname = localhost and database name = bank_db
Enter username and password according to your own MySQL credentials
Then just go with the flow...