ABSTRACT:Higher-education institutions manage a wide range of academic, administrative, financial, studentrelated, staff-related, communication-related, and learning-related activities. However, because responsibilities are split across students, staff, colleges, and outside partners, keeping all the data updated and in sync everywhere becomes very difficult. The paper presents Corvenio College ERP, a modular enterprise resource planning system that unifies management of college covering student, staff and parent, admissions, academic structure and learning, attendance, finance and payments, notifications, document management, certificates and transcripts, and learning management system. The system is implemented with Django and Django REST Framework in the backend and React and TypeScript in the frontend. The project uses the PostgreSQL relational database management system with Redis and Celery for enabling the infrastructure needs. The application has a modular monolithic architecture in which the college management domains are decoupled into separate applications that execute within the same backend infrastructure. The paper includes the details of implementation and validation decisions about data integrity and security including role-based access control, tenant isolation, payment verification, protected academic relationships, transaction atomicity, and concurrency control. The automated verification included 557 successful backend tests from the regression test suite. The targeted PostgreSQL concurrency testing covered critical parts of the application, including seat allocation, student enrollment, payment verification, and quiz-attempt creation. The evaluation showed that the implemented architecture provided verified domain separation, transaction atomicity in tested workflows, and PostgreSQL schema-level tenant isolation.
KEYWORDS: College ERP, Enterprise Resource Planning, Multi-Tenant SaaS, Django, React, PostgreSQL, Role-Based Access Control, Learning Management System, Academic Management, Data Integrity
CORVENIO COLLEGE ERP: A MODULAR MULTI-TENANT PLATFORM FOR INTEGRATED COLLEGE MANAGEMENT
AMAAN ASIF MULANI