Description: A Beginner Express.js web application with MySQL database to simulate basic banking functionalities. The application provides both Customer and Admin user interfaces. Customers can perform actions such as creating an account, sending money, depositing money, requesting a loan, and withdrawing money. Admins receive and fulfill these requests, and Customers receive message notifications on their UI.
Features:
-
Customer UI:
- Create an account.
- Send money to other accounts.
- Deposit money into the account.
- Request a loan.
- Withdraw money from the account.
-
Admin UI:
- Receive and fulfill customer requests.
- Send message notifications to users.
Technologies:
-
Express.js:
- The backend framework for handling HTTP requests, routing, and business logic.
-
MySQL:
- The database to store user accounts, transactions, and requests.
Project Structure: The project follows a simple structure with separate routes and controllers for customers and admins.
-
/customer
Endpoint:- Handles customer-related functionalities.
-
/admin
Endpoint:- Manages admin-related actions.
Database Schema:
users
table: Stores customer account information.transactions
table: Records transaction history.requests
table: Captures customer requests for admins to fulfill.
Installation:
- Clone the repository:
git clone https://github.com/your-username/Simple-Bank-Application.git
- Navigate to the project directory:
cd Simple-Bank-Application
- Install dependencies::
npm install
- Set up the MySQL database:
- Create a database and run the SQL scripts in the
database
folder to set up the tables.
- Run the application:
npm start
- Access the application in your web browser at
http://localhost:3000
.
Requirements:
- Node.js and npm installed on your machine.
- MySQL database configured.