CampusConnect: A Scalable Role-Based Campus ERP System Using the MERN Stack (Case Study at MGIT)

Abstract

This paper presents MGIT CampusConnect, a fullstack, role-based campus ERP system built on the MERN stack and deployed on cloud PaaS infrastructure, with two algorithmic contributions. First, a dual-constraint timetable conflict detection algorithm enforces mutual exclusion at both the section and faculty levels through two sequential O(log n) indexed queries; a concurrent insertion experiment confirmed that storage-layer enforcement via a compound unique index on {facultyId, day, timeSlot} is a correctness requirement. Second, an asynchronous, threshold-triggered attendance notification algorithm classifies students into Safe (P≥75%), Warning (60%≤P<75%), and Critical (P<60%) risk tiers and dispatches notifications to the at-risk student and their faculty mentor after every marking session. The system also provides credit-weighted CGPA computation, structured mentoring, and a tamper-evident audit trail. A pilot at MGIT (24 students, 12 faculty, 5 subjects) validated 47 API endpoints with response times below 500 ms for single-document operations and 634 ms for aggregation pipelines. Index Terms—attendance management, audit logging, campus ERP, conflict detection, Express.js, JWT authentication, marks management, MERN stack, mentor module, MongoDB, Node.js, React, role-based access control, web application.