Final CS PhD Thesis

CS Ph. D. Dissertation (Final Thesis)

Topic: Mini-Banking System (for Business Investment)

Open Source (free to distribute and use)

developed by PHP, MySQL Database and Apache (with WAMP Server)

ATLANTIC INTERNATIONAL UNIVERSITY (AIU), USA

Address: Pioneer Plaza, 900 Fort Street Mall 905 Honolulu, HI 96813, USA
Email: info@aiu.edu

Phone: 800-993-0066 (Toll Free in US)

Name: Mirza Ahmed

Location: New Jersey, USA

Software Engineer (QA Automation, Full-time), NIKSUN, USA

Former Adjunct Faculty (Part-time)

Daffodil International University (DIU), Bangladesh

Final Thesis Demo Video on Mini-Banking System

Table of Contents

1. Introduction
2. Summary

4. Mini-Banking System Hands-On Project
4.1. Objective
4.2. Software used for Mini-Banking System
4.3. WAMP (Windows, Apache, MySQL, and PHP) Server in my laptop
4.4. PhpMyAdmin to setup MySQL Database
4.5. PhpMyAdmin Login
4.6. MySQL Database tables for Mini-Banking System
4.7. Mini-Banking System code location in Apache www root folder of my laptop

5. Mini-Banking System Overview

5.1. Bank Menu
5.2. Mini-Banking System functionalities
5.3. View Customer Data
5.4. Enter Customer Data
5.5. View Account Data
5.6. Enter Account Data
5.7. Balance Enquiry
5.8. Deposit Money
5.9. Withdraw Money
5.10. Business Investment Info
5.11. Deposit Money to Business
5.12. Interest Earned from Business
5.13. Interest calculation

6. Opinions and analysis of the course concepts
7. Personal experiences
8. How I applied the course knowledge to my life, work and community
9.1 Use case examples to demonstrate the concepts
9.2 Mini-Banking-System code in GitHub
9.3 Conclusion
9.4 References

10. Appendix: Source Code
10.1. Command to Create a new My SQL Database User
10.2. Config to connect to MySQL Database from PHP
10.3. Customer Table
10.4. View Customer Data
10.5. Enter Customer Data
10.6. Account Table
10.7. View Account Data
10.8. Enter Account Data
10.9. Balance Enquiry
10.10. Deposit Money
10.11. Withdraw Money
10.12. Business To Invest Table
10.13. Business Investment Info
10.14. Deposit Money to Business
10.15. Interest Earned from Business
10.16. Bank Menu

1. Introduction

Banking System is used all around the world. The Banking System developed here can help the people in poor countries like Bangladesh.

2. Summary

Here we are going to discuss about a Mini-Banking System with Hands-On Project (Apache Web Server, PHP and MySQL Database). The bank will have the ability for its customers to invest money in the business and earn interest in addition to banking basic features.

4. Mini-Banking System Hands-On Project

4.1. Objective

Develop a Mini-Banking System with basic banking functionalities like creating a customer, creating checking or saving account, deposit or withdraw money from bank. Also, have the ability to invest money in the business for bank customers. Interest earned from the business can be calculated in the banking system.

4.2. Software used for Mini-Banking System

  1. WAMP Server to host Apache, MySQL Database, and PHP in my local laptop
  2. PHP for front-end Webpage
  3. MySQL Database to store Bank Data

4.3. WAMP (Windows, Apache, MySQL, and PHP) Server in my laptop

4.4. PhpMyAdmin to setup MySQL Database

4.5. PhpMyAdmin Login

4.6. MySQL Database tables for Mini-Banking System

4.7. Mini-Banking System code location in Apache www root folder of my laptop

C:\wamp64\www\PhD_Dissertation_Project

  1. Mini-Banking System Overview

5.1. Bank Menu

http://localhost/PhD_Dissertation_Project/Bank_Menu/Bank_Menu.html

5.2. Mini-Banking System functionalities

  1. View Customer Data
  2. Enter Customer Data
  3. View Account Data
  4. Enter Account Data
  5. Balance Enquiry
  6. Deposit Money
  7. Withdraw Money
  8. Business Investment Info
  9. Deposit Money to Business
  10. Interest Earned from Business

5.3. View Customer Data

Below form is used to view bank customer data

Below is an example of bank customer data.

5.4. Enter Customer Data

Below form is used to enter bank customer data

5.5. View Account Data

Below form is used to view bank account data

Below is an example of bank account data.

5.6. Enter Account Data

Below form is used to enter bank account data

5.7. Balance Enquiry

Below form is used for bank account balance enquiry

Below form is showing account balance of a customer

5.8. Deposit Money

Below form is used to deposit money in bank accounts

5.9. Withdraw Money

Below form is used to withdraw money in bank accounts

5.10. Business Investment Info

Below form is used to see business investment Info

Below form is showing 3 months business investment Info of a bank customer

5.11. Deposit Money to Business

Below form is used to deposit money to business

Customer can select Month from January to December from drop down.

Customer can select Year values from drop down.

5.12. Interest Earned from Business

Below form is used to see interest earned from business for bank customer

Below is an example of interest earned from business for bank customer for 3 months.

5.13. Interest calculation

Total Interest Earned = (Total Amount Invested/Month Count)*(Fixed Monthly Interest Rate/100)* Month Count

6. Opinions and analysis of the course concepts

In my opinion, Banking System is a growing field and lots of jobs are available nowadays in it (like Banking System developer). So, it is worth spending time learning Banking System.

7. Personal experiences

I am going to teach this Banking System for Daffodil International University (DIU), Bangladesh in the future. I am a part-time faculty in DIU.

8. How I applied the course knowledge to my life, work and community

8.1 No copy right for Mini-Banking System

This mini-banking application software developed here can be
1. Used (for free)
2. Enhanced (for free)
3. Distributed (for free)
in third world countries who cannot afford expensive software.

So, poor countries like Bangladesh can use this code which will help them saving money

8.2 Mini-Banking System knowledge can be used for my current job
I am already applying my Banking System knowledge at my current job. I am a developer in US. I use Apache Web Server, PHP and MySQL Database for my development work

8.3 Mini-Banking System can be used for web development learning
People can learn from this system and be ready for applying the knowledge in real web development jobs

8.4 Mini-Banking System learning from my personal IT training web site
My thesis is published now in my personal IT training website here. So, people like you visiting my site can learn from it as well.

9.1 Use case examples to demonstrate the concepts

I used a hands-on Banking System project here with Apache Web Server, PHP and MySQL Database.

9.2 Mini-Banking-System code in GitHub

Mini-Banking-System code is in GitHub so that people from all around the world can download and use this software (for free)

GitHub Repository for Mini-Banking-System

https://github.com/mirza99121/Mini-Banking-System

 

9.3 Conclusion

We have learned how to build a mini-banking application from scratch (with PHP, MySQL and Apache) here. This mini-banking system can be enhanced if needed to satisfy new banking business process.

9.4 References

Create Editable Bootstrap Table with PHP & MySQL. (n.d.). Retrieved from webdamn.com: https://webdamn.com/create-editable-bootstrap-table-with-php-mysql/

Installing WampServer. (n.d.). Retrieved from make.wordpress.org: https://make.wordpress.org/core/handbook/tutorials/installing-a-local-server/wampserver/

MySQL Tutorial. (n.d.). Retrieved from mysqltutorial: https://www.mysqltutorial.org

PHP Tutorial. (n.d.). Retrieved from w3schools: https://www.w3schools.com/php

Appendix: Source Code(click here to view)