Banking-System-Database

  • Objective: The objective of the Banking System Database Project is to create a comprehensive database system for both banking applications and physical banks. This project aims to understand how banks manage vast amounts of data, providing insights into real-life data management practices.

  • Features:

    1. User Data Management: Store user details (name, contact info, address).
    2. Account Management: Track customer accounts, transactions, and account statuses.
    3. Loan and Investment Tracking: Manage loan, investment, and insurance data.
    4. Customer Records: Record customer applications and statuses.
  • Schemas used: Entity-Relationship Diagram(ERD), Relational schema

  • Tools and Technologies used: PostgreSQL