How badalvishwendra/dbms_project_scholarship_management_system works
The product is a scholarship administration system with a Vercel single-page client and server-rendered administration pages backed by FastAPI and SQLite. The main workflow is to maintain students and scholarship schemes, submit and review applications, then record payments for approved awards; dashboard and institute reporting provide oversight. The excerpts show representative route and database behavior, but not every handler or template, so some documented capability links rely on the README rather than sampled implementation.
Main entry points: database.py SQLite access · app.py FastAPI routes · app.js Vercel SPA · templates Admin templates
Components 14
User interfaces
- Vercel SPA
frontend-vercel/app.js - Admin templates
frontend/templates
Application services
- FastAPI routes
backend/app.py
Scholarship operations
- Dashboard metrics
backend/app.py - Student directory
backend/app.py - Scholarship catalogue
backend/app.py - Application workflow
backend/app.py - Disbursement register
backend/app.py - Institute reporting
backend/app.py
Persistence
- SQLite access
backend/database.py - Relational schema
db/schema.sql - Demo records
db/seed.sql - SQLite database
storage
Other components
- Administrator
Connections 19
- Administrator → Vercel SPA: uses
README.md - Administrator → Admin templates: uses
README.md - Vercel SPA → FastAPI routes: requests data
frontend-vercel/app.js - Admin templates → FastAPI routes: submits forms
README.md - FastAPI routes → Dashboard metrics: routes to
backend/app.py - FastAPI routes → Student directory: routes to
backend/app.py - FastAPI routes → Scholarship catalogue: routes to
backend/app.py - FastAPI routes → Application workflow: routes to
backend/app.py - FastAPI routes → Disbursement register: routes to
backend/app.py - FastAPI routes → Institute reporting: routes to
README.md - Dashboard metrics → SQLite access: queries
backend/app.py - Student directory → SQLite access: queries
backend/app.py - Application workflow → SQLite access: queries
backend/app.py - Disbursement register → SQLite access: queries
backend/app.py - Scholarship catalogue → SQLite access: queries
backend/app.py - Institute reporting → SQLite access: queries
backend/app.py - SQLite access → SQLite database: reads and writes
backend/database.py - SQLite access → Relational schema: loads schema
backend/database.py - SQLite access → Demo records: loads when empty
backend/database.py