How jashans-06/banking_management_database works
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: create_tables.sql Accounts · insert_data_v1.1_fixed.sql Demo data · 7 questions.sql Business queries Q1–Q7 · aryan_queries.sql Business queries Q8–Q10
Components 12
Database setup
- Schema DDL
Schema/create_tables.sql - Demo data
Schema/insert_data_v1.1_fixed.sql
Banking records
- Branches, staff, customers
Schema/create_tables.sql - Accounts
Schema/create_tables.sql - Transactions
Schema/create_tables.sql - Loans and payments
Schema/create_tables.sql
Payment services
- Cards
Schema/create_tables.sql - Registered payees
Schema/create_tables.sql
Business queries
- Business queries Q1–Q7
queries/7 questions.sql - Business queries Q8–Q10
queries/aryan_queries.sql
Other components
- Bank team
- MySQL database
Connections 13
- Bank team → Schema DDL: sets up
README.md - Schema DDL → MySQL database: defines schema
README.md - Bank team → Demo data: loads data
README.md - Demo data → MySQL database: seeds rows
README.md - Bank team → Business queries Q1–Q7: runs questions
README.md - Bank team → Business queries Q8–Q10: runs questions
README.md - Business queries Q1–Q7 → MySQL database: queries
README.md - Business queries Q8–Q10 → MySQL database: queries
README.md - Branches, staff, customers → Accounts: staff and customers hold
README.md - Accounts → Transactions: anchors movements
README.md - Accounts → Loans and payments: anchors lending
README.md - Accounts → Cards: issues instruments
README.md - Branches, staff, customers → Registered payees: customers register
README.md