Skip to content

Latest commit

 

History

History
45 lines (36 loc) · 1.76 KB

README.md

File metadata and controls

45 lines (36 loc) · 1.76 KB

Project-SAFE-Bank

Project Name: SAFE (Save And Fortune Excellence) Bank
Project Type: Web Application
Course: Principle of Database Systems Project

Overview

Project-SAFE-Bank is a comprehensive web application designed to manage banking data, focusing on customer accounts and loan management. The application integrates various account types (checking, savings, loans) while ensuring compliance with business requirements through a robust database schema.

Features

  • Customer Management:

    • CRUD operations for customer data, including personal details and addresses.

  • Account Management:

    • Support for different account types: checking, savings, and loans.
    • Manage account-specific attributes (interest rate, loan rate, etc.)

  • Loan Management:

    • Differentiate between loan types: Home, Personal, Student.
    • Capture details such as insurance, educational institutions, and payment terms.

  • Reporting:

    • Generate summary reports on customer accounts and loans.
    • Analyze high-value customers and active accounts.

Database Schema

  • Customer Table: Stores customer information like name and address.
  • Account Tables: Individual tables for each account type (checking, savings, loan).
  • Loan Subtables:
    • Home Loan: Insurance, house build year, premium.
    • Personal Loan: Early repayment fee.
    • Student Loan: Education institution, student details.

Technology Stack

  • Frontend: JavaScript, Bootstrap.
  • Backend: Java, Spring Boot, REST API.
  • Database: MySQL.
  • Other Tools: MySQL Workbench for database management.

Setup Instructions

  1. Clone Repository: 
    git clone https://github.com/your-username/Project-SAFE-Bank.git

Project-SAFE-Bank

Principle of Database System Project