College ERP Portal – Cloud-Based Full Stack System A full-stack college management system designed to handle academic and administrative workflows with role-based access control. The platform supports Students, Faculty, and Dean/HOD roles with real-time data synchronization and a modern, Apple-inspired interface. Developed by Ash (Aishwarya Tripathi) Overview This system replicates a real-world college ERP (Enterprise Resource Planning) platform. It enables seamless interaction between different roles in an academic institution, allowing centralized management of attendance, academic performance, student records, and administrative processes. The application is built using a Node.js backend with a lightweight SQLite database and a responsive frontend using HTML, CSS, and JavaScript. It was deployed on AWS for cloud accessibility. Core Features Role-Based Authentication Separate login for Students, Faculty, and Dean/HOD Session-based authentication with secure password hashing Access control enforced at API and UI levels Student Portal View personal and academic profile Track attendance across subjects Access marks and performance data Submit daily assignments View exam schedules and venue details Real-time updates from faculty and administration Faculty Portal Mark and update student attendance Upload and manage student marks View student data Support for bulk operations Automatic grade calculations Dean / HOD Portal Approve or reject student registrations Manage active student database Create and manage exam venues Access complete attendance and marks data Generate reports and oversee system activity Student Registration Workflow New students submit detailed registration forms Data includes academic scores and personal information Requests are reviewed and approved by HOD Approved students are added to the system Real-Time Data Flow Updates made by faculty are instantly visible to students Administrative actions reflect across all dashboards Ensures consistency across roles without manual refresh Technology Stack Frontend HTML5 CSS3 (custom styling with modern UI principles) JavaScript (ES6) Backend Node.js Express.js Database SQLite3 Authentication Session-based authentication bcrypt for password hashing Deployment Hosted on AWS System Architecture The application follows a standard client-server architecture: Frontend handles UI and user interaction Backend exposes REST APIs SQLite database manages persistent storage Role-based middleware ensures access control Database Design The system uses structured relational tables including: Users (authentication and roles) Student Requests (approval workflow) Attendance (subject-wise tracking) Marks (academic performance) Exam Venues (scheduling and logistics) DA Submissions (assignment tracking) API Design Key API modules include: Authentication Login and logout endpoints Student APIs Attendance retrieval Marks retrieval Assignment submission Exam venue access Faculty APIs Attendance updates Marks updates Student list retrieval Dean/HOD APIs Student approval and removal Exam venue creation System-wide data access UI and Design The interface follows modern UI principles inspired by Apple design systems: Clean typography and layout hierarchy Glassmorphism and subtle depth effects Smooth transitions and micro-interactions Fully responsive design for different screen sizes Project Structure: college-portal/ ├── public/ │ ├── css/ │ └── js/ ├── views/ ├── server.js ├── package.json └── college_portal.db Setup Instructions Install dependencies: npm install Start the server: npm start Open in browser: http://localhost:3000 Key Highlights Full-stack implementation with real-world use case Role-Based Access Control (RBAC) REST API architecture Cloud deployment on AWS Clean and modern UI design Structured database schema Scalable system design approach Future Improvements JWT-based authentication File upload for assignments Advanced analytics dashboard Notification system (email/push) Mobile application integration Real-time communication features Author Ash (Aishwarya Tripathi) B.Tech CSE, VIT Vellore