🌟 Mobile Banking Application - Database Project

This project demonstrates the design and implementation of a Mobile Banking Application with a focus on robust database management and secure backend integration.

---

📂 Project Overview

A simplified banking system that includes features such as user authentication, account management, secure transactions, and loan processing. The project highlights best practices in PostgreSQL database design and backend development with Django.

---

🚀 Features

✅ Core Functionalities

• User Account Management:
  • View account details and balances.
  • Access transaction history with filtering options.
• Transactions:
  • Secure fund transfers with rollback for errors (ensuring atomicity).
• Loan Management:
  • Calculate loan eligibility and apply for loans.
  • Track loan repayments and view installment details.
• Security:
  • Input validation and SQL injection prevention.
• Admin panel for managing accounts, loans, and user operations.

---

🛠️ Tech Stack

Component	Technology
Backend	Django (with Template Rendering)
Database	PostgreSQL
Language	Python

---

🗂️ Project Structure

1. Database Design:

   • Implementation of tables, stored procedures, and functions in PostgreSQL.
   • All constraints and validations are handled at the database level.

2. Backend Implementation:

   • Django-based backend to provide a seamless user interface.
   • Secure integration with the database for banking operations.

3. Key Modules:

   • Authentication: User login with hashed password storage.
   • Accounts: Retrieve account details and balances.
   • Transactions: Transfer funds securely and view transaction history.
   • Loans: Loan eligibility, application, and repayment tracking.

---

📊 How to Use

Prerequisites Install PostgreSQL on your machine. Refer to the official PostgreSQL documentation for installation instructions. Run the SQL scripts provided in script.sql to set up the database schema and stored procedures:

psql -U <your_username> -d <your_database> -f script.sql

Manually create a user in the users table with the necessary credentials to log in to the application.

1. Clone the repository:

   git clone https://github.com/mhasanbash/Mobile-Bank-App.git

2. Navigate to the project directory:

    cd Mobile-Bank-App/

3. Install dependencies:

   pip install -r requirements.txt

4. Set up the database (PostgreSQL) and apply migrations:

   python manage.py makemigrations
   python manage.py migrate

5. Run the Django server:

   python manage.py runserver

6. Access the application at:
   http://localhost:8000/Home

---

🎨 Screenshots

---

📝 License

This project is licensed under the MIT License. See the LICENSE file for details.

---