Copyright © 2026 Authors retain the copyright of this article. This article is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

@article{200911,
        author = {Abhijeet Vishwas Jadhav and Atharv Rangrao Patil and Prathmesh Madhukar Kanekar and Sharvari Bhagwan Karande and Nurain Aanis Sayyad},
        title = {smart attendance system},
        journal = {International Journal of Innovative Research in Technology},
        year = {2026},
        volume = {12},
        number = {12},
        pages = {2109-2116},
        issn = {2349-6002},
        url = {https://ijirt.org/article?manuscript=200911},
        abstract = {This paper presents the design and architectural validation of a secure, multi-role student attendance management system utilizing geofencing technology. Traditional attendance methods are inefficient and susceptible to manipulation, demanding a robust digital alternative. The proposed system, built on a Flutter mobile client, a Node.js application layer, and a PostgreSQL database extended with PostGIS, addresses these limitations. A core contribution is the implementation of a highly secure server-side virtual room access control mechanism. Unlike susceptible client-side validation, the system enforces presence verification by performing Point-in-Polygon checks using PostGIS spatial functions, ensuring the integrity of the attendance record. Authorization is managed through a stringent Role-Based Access Control (RBAC) hierarchy (Student, Teacher, HOD, Principal), with fine-grained data isolation for administrative roles achieved via PostgreSQL's native Row-Level Security (RLS). This architecture ensures that attendance links are only accessible when the student's authenticated location is confirmed by the server to be within the designated 500-meter by 500-meter ArcGIS-defined virtual room boundary. Evaluation focuses on maintaining data integrity, providing accurate departmental data visibility for Heads of Department (HODs), and establishing a scalable, tamper-proof foundation for educational institutions.},
        keywords = {Geofencing, Role-Based Access Control, PostGIS, Row-Level Security, Flutter, Attendance Management.},
        month = {May},
        }