Design and Development of a Web-Based College Enterprise Resource Planning (ERP) System for Academic and Administrative Management

Abstract

A web-based program called the College ERP System was created to automate and manage academic tasks at colleges. It facilitates the completion of duties by teachers, administrators, and students using a single, centralized system. The administrator can make schedules, keep track of attendance, and handle teacher and student information. Teachers are able to submit study materials for students and record attendance. Through the system, students can access their notes and see their attendance. React, Flask, and MySQL are used in the development of the application to guarantee effective data management. College administration is made simpler and more structured by this system, which also decreases manual labor and increases accuracy.

Introduction

The document describes the development of a College ERP (Enterprise Resource Planning) System designed to automate and centralize academic and administrative tasks in educational institutions. Traditional manual methods for managing student records, faculty information, attendance, and timetables are time-consuming, error-prone, and inefficient. The proposed system addresses these issues by providing a web-based centralized platform.

The system uses modern technologies:

• Frontend: React

• Backend: Flask

• Database: MySQL

It implements role-based access control for three users: Administrator, Faculty, and Student.

Key features include:

• Student and faculty management (add, edit, delete records)

• Attendance management system (faculty mark attendance; students view records)

• Timetable management (schedule creation and assignment)

• Study material upload and access (faculty upload notes; students download them)

• Secure login and authentication

• Centralized database integration

The system improves data accuracy, transparency, communication, and efficiency, while reducing paperwork and human errors. It ensures secure access and structured workflow among users.

The methodology includes system architecture design, workflow process, user authentication, database integration, and module implementation. Evaluation results show that the system performs effectively with proper functionality and user-friendly interfaces.

Overall, the College ERP System provides a secure, scalable, and efficient digital solution for managing academic operations in colleges and universities.

Conclusion

The College ERP System is intended to streamline and automate a college\'s administrative and academic operations. Administrators, teachers, and students can all work effectively on the system\'s consolidated platform. It facilitates the orderly management of student and faculty data, attendance records, schedules, and study materials. The technology saves time and increases accuracy by decreasing manual labor and paperwork. The system is dependable, safe, and user-friendly thanks to the utilization of contemporary web technologies like MySQL, Flask, and React. Each user can only access the features that are pertinent to them thanks to role-based access.System enhances efficiency, transparency, and communication in college administration.

References

[1] Q. N. Naveed, S. Islam, M. R. N. M. Qureshi, A. M. Aseere, M. A. A. Rasheed and S. Fatima, \"Evaluating and Ranking of Critical Success Factors of Cloud Enterprise Resource Planning Adoption Using MCDM Approach,\" in IEEE Access, vol. 9, pp. 156880156893, 2021, doi: 10.1109. [2] Wang Yunzhi, Hu Yaoguang, Jia Yanhua and Zhang Ruijun, \"A game theoretic approach to product-mix resource allocation,\" 2010 5th IEEE Conference on Industrial Electronics and Applications, Taichung, Taiwan, 2010, pp. 2142-2147, doi: 10.1109. [3] R. Rakholia, A. L. Suárez-Cetrulo, M. Singh and R. S. Carbajo, \"AI-Driven Meat Food Drying Time Prediction for Resource Optimization and Production Planning in Smart Manufacturing,\" in IEEE Access, vol. 13, pp. 22420-22428, 2025, doi: 10.1109. [4] M. -S. Yeon, Y. -K. Lee, D. -L. Pham and K. P. Kim, \"Experimental Verification on Human-Centric Network-Based Resource Allocation Approaches for Process-Aware Information Systems,\" in IEEE Access, vol. 10, pp. 23342-23354, 2022, doi: 10.1109. [5] H. Li et al., \"Composition of Resource-Service Chain Based on Evolutionary Algorithm in Distributed Cloud Manufacturing Systems,\" in IEEE Access, vol. 8, pp. 19911-19920, 2020, doi: 10.1109. [6] Y. -K. Liu, X. -S. Zhang, L. Zhang, F. Tao and L. -H. Wang, \"A Multi-Agent Architecture for Scheduling in Platform-Based Smart Manufacturing Systems,\" in Frontiers of Information Technology & Electronic Engineering, vol. 20, no. 11, pp. 1465-1492, November 2019, doi: 10.1631. [7] J. Zhang, \"Research on Intelligent Analysis System for Enterprise Financial and Management Decision-Making Based on Multidimensional Behavioral Data,\" in IEEE Access, vol. 13, pp. 212672-212688, 2025, doi: 10.1109. [8] L. Zhou et al., \"A Comparative Study on Grid Resource Utilization Rate Between China Southern Power Grid and National Grid Pic of UK,\" in Protection and Control of Modern Power Systems, vol. 3, no. 3, pp. 1-8, July 2018, doi: 10.1186 [9] N. A. Ahmad, S. M. Drus and H. Kasim, \"Factors That Influence the Adoption of Enterprise Architecture by Public Sector Organizations: An Empirical Study,\" in IEEE Access, vol. 8, pp. 98847-98873, 2020, doi: 10.1109. [10] W. Zhang, R. -S. Chen, Y. -C. Chen, S. . -Y. Lu, N. Xiong and C. -M. Chen, \"An Effective Digital System for Intelligent Financial Environments,\" in IEEE Access, vol. 7, pp. 155965-155976, 2019, doi: 10.1109 . [11] S. Lou, Y. Feng, G. Tian, Z. Lv, Z. Li and J. Tan, \"A CyberPhysical System for Product Conceptual Design Based on an Intelligent Psycho-Physiological Approach,\" in IEEE Access, vol. 5, pp. 5378-5387, 2017, doi: 10.1109. [12] S. Sriram, P. R. Tharaniesh, P. Saraf, N. Vijayaraj and T. Murugan, \"Enhancing Digital Identity and Access Control in Event Management Systems Using Sui Blockchain,\" in IEEE Access, vol. 13, pp. 24295-24308, 2025, doi: 10.1109. [13] [13] A. R. Hevner, D. Zhang and J. L. Zhao, \"Guest Editorial: Introduction to the Special Issue on Modeling and Implementation of Service Enterprise Systems,\" in IEEE Transactions on Services Computing, vol. 3, no. 2, pp. 86-88, April-June 2010, doi: 10.1109. [14] S. Qureshi, G. . -J. de Vreede and D. Vogel, \"Research methods & applications mini-track organizational systems & technology track,\" 37th Annual Hawaii International Conference on System Sciences, 2004. Proceedings of the, Big Island, HI, USA, 2004, pp. 256-256, doi: 10.1109. [15] L. Wang, J. Zhou and X. Li, \"Influence of College Teacher’s Instructional Design on the Development of College Students’ Thinking of Innovation Multi-Algorithms Perspective Analysis,\" in IEEE Access, vol. 12, pp. 3969-3980, 2024, doi: 10.1109.

Copyright

Copyright © 2026 Saladi Sruthi Ramya, Bonthu Beulah , Ranganadham Veera Pavan Aditya , Chikkala Sri Ram Krishna Sai Narasimha , Kudupudi Yeswanth , Chavatapalli Tataya Naidu. This 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.