Gram Panchayat Management System February 2025
A multi-user web app for managing Gram Panchayat administration, built for a DBMS course.
Every Database Management Systems Laboratory needs a mid-term group project, and ours was a Gram Panchayat Management System - a multi-user web app for running the administrative side of a Gram Panchayat (India's village-level local government body): session-based authentication, CRUD over multiple linked entities, and detailed reports pulled straight from the schema. You can see it live.
Here's the part that actually shaped how we built it: the real deliverable wasn't the app - it was the submission report containing the database's ER diagram. That's what got graded. So once our group realized the UI was mostly a formality, we stopped overthinking it and just built: full working CRUD, sessions, and reports, done in about 5-6 hours flat once we actually sat down together.
I deliberately didn't spend time polishing the interface beyond "clearly functional." The teaching assistant grading it wasn't rewarding visual polish - the schema design and the correctness of the reports were what mattered, so that's where the actual engineering effort went.