← Back to Portfolio

Major Project: College ERP System (Flask, MySQL)

This project focused on rebuilding our college's existing Enterprise Resource Planning (ERP) system. The primary goal was to address issues of poor responsiveness and outdated user experience by implementing a modern web stack and a streamlined database architecture.

As a B.Tech Minor Project, it emphasized practical application of full-stack development, database optimization, and user-centric design principles to create a fast, accessible, and friendly interface for Admin, Faculty, and Student roles.

Problem & Solution

  • Problem: Outdated ERP System

    The existing college ERP system suffered from a non-responsive interface, slow load times, and poor information architecture, leading to user frustration and inefficient processes for key operations (e.g., admissions, results access).

  • Solution: Full-Stack Modernization

    We implemented a modern Python/Flask back-end for lightweight server-side logic and utilized a relational MySQL database for structured data management. The front-end was built using Bootstrap to ensure immediate mobile responsiveness and an improved UI/UX.

Technical Stack & Database Design

    Front-End & UX
  • HTML, CSS, JavaScript
  • Bootstrap 5.3+ (Responsive Design)
    • Back-End & Server
  • Python (Flask Framework)
  • Routing and Session Management
    • Database & Infrastructure
  • MySQL (Relational Data Model)
  • Database Schema Design & Normalization
  • NetApp (Potential Storage Integration)

Key Implementation Highlights

  1. Improved Database Responsiveness

    Optimized MySQL queries and database structure to significantly reduce data retrieval latency compared to the legacy system.

  2. Role-Based Access Control (RBAC)

    Implemented distinct login portals and secure access levels for Admin, Faculty, and Student roles, ensuring data segmentation and security.

  3. Modern UI/UX

    Integrated Bootstrap components to deliver a modern, clean, and fully responsive user interface that scales effectively across desktop and mobile devices.

Code & Demonstration

Review the complete source code and project architecture via the GitHub repository:

View Project Repository