# jashans-06/banking_management_database architecture

> Architecture diagram of the GitHub repository jashans-06/banking_management_database, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-06). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/jashans-06/banking_management_database
- Repository: https://github.com/jashans-06/banking_management_database

## Overview

FinCore is a MySQL banking database design, not an application service: its principal workflow is to create the constrained schema, load demo data, then run business queries against it. The schema covers bank master data, accounts and money movement, lending, and payment instruments/payees. The README documents these capabilities and key relationships; no source excerpts were provided, so the graph shows only relationships explicitly described there, not unverified SQL execution details.

Main entry points: [`Schema/create_tables.sql`](https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql) (Accounts), [`Schema/insert_data_v1.1_fixed.sql`](https://github.com/jashans-06/banking_management_database/blob/main/Schema/insert_data_v1.1_fixed.sql) (Demo data), [`queries/7 questions.sql`](https://github.com/jashans-06/banking_management_database/blob/main/queries/7%20questions.sql) (Business queries Q1–Q7), [`queries/aryan_queries.sql`](https://github.com/jashans-06/banking_management_database/blob/main/queries/aryan_queries.sql) (Business queries Q8–Q10)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_setup["Database setup"]
  node_ddl["Schema DDL<br/>[create_tables.sql]"]
  node_seed["Demo data"]
end

subgraph group_banking["Banking records"]
  node_master["Branches, staff, customers<br/>[create_tables.sql]"]
  node_accounts["Accounts<br/>[create_tables.sql]"]
  node_transactions["Transactions<br/>[create_tables.sql]"]
  node_loans["Loans and payments<br/>[create_tables.sql]"]
end

subgraph group_payments["Payment services"]
  node_cards["Cards<br/>[create_tables.sql]"]
  node_beneficiaries["Registered payees<br/>[create_tables.sql]"]
end

subgraph group_analysis["Business queries"]
  node_q1q7["Business queries Q1–Q7<br/>[7 questions.sql]"]
  node_q8q10["Business queries Q8–Q10<br/>[aryan_queries.sql]"]
end

node_operator(("Bank team"))
node_mysql[("MySQL database")]

node_operator -->|"sets up"| node_ddl
node_ddl -->|"defines schema"| node_mysql
node_operator -->|"loads data"| node_seed
node_seed -->|"seeds rows"| node_mysql
node_operator -->|"runs questions"| node_q1q7
node_operator -->|"runs questions"| node_q8q10
node_q1q7 -->|"queries"| node_mysql
node_q8q10 -->|"queries"| node_mysql
node_master -->|"staff and customers hold"| node_accounts
node_accounts -->|"anchors movements"| node_transactions
node_accounts -->|"anchors lending"| node_loans
node_accounts -->|"issues instruments"| node_cards
node_master -->|"customers register"| node_beneficiaries

click node_ddl "https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql"
click node_seed "https://github.com/jashans-06/banking_management_database/blob/main/Schema/insert_data_v1.1_fixed.sql"
click node_master "https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql"
click node_accounts "https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql"
click node_transactions "https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql"
click node_loans "https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql"
click node_cards "https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql"
click node_beneficiaries "https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql"
click node_q1q7 "https://github.com/jashans-06/banking_management_database/blob/main/queries/7%20questions.sql"
click node_q8q10 "https://github.com/jashans-06/banking_management_database/blob/main/queries/aryan_queries.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_ddl,node_seed toneBlue
class node_master,node_accounts,node_transactions,node_loans,node_mysql toneAmber
class node_cards,node_beneficiaries toneMint
class node_q1q7,node_q8q10 toneRose
class node_operator toneIndigo
```

## Components

### Database setup

- [Schema DDL](https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql): `Schema/create_tables.sql`
- [Demo data](https://github.com/jashans-06/banking_management_database/blob/main/Schema/insert_data_v1.1_fixed.sql): `Schema/insert_data_v1.1_fixed.sql`

### Banking records

- [Branches, staff, customers](https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql): `Schema/create_tables.sql`
- [Accounts](https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql): `Schema/create_tables.sql`
- [Transactions](https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql): `Schema/create_tables.sql`
- [Loans and payments](https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql): `Schema/create_tables.sql`

### Payment services

- [Cards](https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql): `Schema/create_tables.sql`
- [Registered payees](https://github.com/jashans-06/banking_management_database/blob/main/Schema/create_tables.sql): `Schema/create_tables.sql`

### Business queries

- [Business queries Q1–Q7](https://github.com/jashans-06/banking_management_database/blob/main/queries/7%20questions.sql): `queries/7 questions.sql`
- [Business queries Q8–Q10](https://github.com/jashans-06/banking_management_database/blob/main/queries/aryan_queries.sql): `queries/aryan_queries.sql`

### Other components

- **Bank team**
- **MySQL database**

## Connections

- Bank team → Schema DDL: sets up (evidence: `README.md`)
- Schema DDL → MySQL database: defines schema (evidence: `README.md`)
- Bank team → Demo data: loads data (evidence: `README.md`)
- Demo data → MySQL database: seeds rows (evidence: `README.md`)
- Bank team → Business queries Q1–Q7: runs questions (evidence: `README.md`)
- Bank team → Business queries Q8–Q10: runs questions (evidence: `README.md`)
- Business queries Q1–Q7 → MySQL database: queries (evidence: `README.md`)
- Business queries Q8–Q10 → MySQL database: queries (evidence: `README.md`)
- Branches, staff, customers → Accounts: staff and customers hold (evidence: `README.md`)
- Accounts → Transactions: anchors movements (evidence: `README.md`)
- Accounts → Loans and payments: anchors lending (evidence: `README.md`)
- Accounts → Cards: issues instruments (evidence: `README.md`)
- Branches, staff, customers → Registered payees: customers register (evidence: `README.md`)
