How quantumjv/bank-management-system works
Project type and purpose
• This is a monolithic, command-line Banking Management System written in Python, backed by a MySQL database (schema in bank.sql).
• Purpose: Provide basic banking operations (create/close accounts, deposit/withdraw money, view individual/all customer details) with username/password authentication.
File structure
• Top-level files:
• bank.py – the single Python entry point containing CLI menus, business logic, and data-access calls
• bank.sql – DDL/DML script defining the MySQL schema (tables for customers, transactions, users, etc.)
• screenshots/ – UI snapshots (CLI output)
• README.md, License – documentation
• No separate “frontend” or “backend” folders: UI, logic, and DB integration are all in bank.py.
• No containers, microservices, or API layers—it's a simple, direct DB-driven script.
Extract insights from README
• Confirms Python + MySQL stack.
• Lists features: withdraw/deposit, view/add/close accounts, authentication.
• Operational flow is linear: user logs in → selects operation → Python executes SQL queries → displays results.
a. Main components
1. User (CLI client)
2. bank.py application (three sub-layers: Presentation/CLI module, Business Logic module, Data Access module)
3. MySQL Database (tables: Users, Customers, Transactions)
4. Optional: Operating System / Python runtime
b. Relationships & interactions
• User → (stdin/CLI commands) → Presentation layer of bank.py
• Presentation layer → invokes Business Logic functions
• Business Logic → issues SQL via Data Access layer (using MySQL connector)
• Data Access layer → communicates over TCP/IP or socket with MySQL Server
• MySQL Server → returns query results → Data Access → Business Logic → Presentation → User
c. Architectural patterns/design principles
• Monolithic, layered approach (UI/logic/data access)
• Single responsibility per layer:
– Presentation: menu rendering & input parsing
– Business Logic: validation, transaction rules, flow control
– Data Access: raw SQL execution, connection management
• Authentication gate at entry point enforcing security before business ops
d. Key technologies
• Python 3.x, mysql-connector or PyMySQL
• MySQL Community Server
• bank.sql for schema setup