This is a Bank Management System Database Project.
The main aim of the Bank Management Mini project is to keep record of customer transactions in the bank. We aim to demonstrate the use of create, read, update and delete MySQL operations through this project. Firstly, customer registration is done in the concern bank branch and account number is provided to them. Afterwards, the customer can login into the bank account and update the personal details anytime. The customer can also check his/her previous transactions (debit and credit) and can take a soft copy of these transactions as a bank statement in the CSV format. To perform the debit and credit transactions in an account, a bank employee account is required. In addition to deposit or withdraw transaction, the employee is also authorized to close the bank account as per customer demand.
Figure 1: A depiction of bank management system simulated in the project.
Bank Management Mini Project contains 3 different types of data:
1) User Accounts: As the name suggests, a record of all the customer and employee details along with thier admin status.
2) User personal detail: Contains the information about a particulaar account, which can be viewed by its owner.
3) Transaction: Transactions to be made by the customer (credit amount, debit, dates etc).