EDUNEX: ARCHITECTURE AND IMPLEMENTATION OF A COLLEGE ERP WITH TWO GROUNDED AI ASSISTANTS

This preprint presents EduNex, a cloud-deployed College Enterprise Resource Planning (ERP) system developed for Brahmdevdada Mane Institute of Technology, Solapur, Maharashtra, India. EduNex integrates academic and administrative operations into a unified platform, including attendance management, marks and results, fee management, scholarships, timetable scheduling, examination management, library circulation, document tracking, grievance management, and QR-based bonafide certificate verification. The system introduces two AI-powered assistants: an EduNex Assistant that answers questions using authorized live ERP records, and Campus AI, which uses Retrieval-Augmented Generation (RAG) to retrieve relevant information from institutional documents before generating responses. The implementation uses Next.js, React, TypeScript, Tailwind CSS, Python FastAPI, SQLAlchemy, PostgreSQL, JWT authentication, LangChain, FAISS, FastEmbed, and a Groq-hosted language model. The system comprises 29 database tables and 112 REST API endpoints. Reported functional testing includes 94 successful test cases across bonafide certificate, timetable, and examination workflows. The paper also reports an approximate Campus AI response-time improvement from 6.0 seconds to 2.3 seconds following optimization. This manuscript documents the architecture, implementation, selected functional test results, and limitations of the EduNex ERP system. Further controlled performance, security, usability, and AI-quality evaluations are identified as future research directions. This work is shared as a research preprint for academic access, citation, and feedback. It has not been presented here as a peer-reviewed journal publication. Keywords: College ERP, Academic Information System, Artificial Intelligence, Retrieval-Augmented Generation, Role-Based Access Control, Examination Scheduling, QR Verification.