Educational CRM

An Educational Customer Relationship Management (CRM) system built using Spring Boot (Web MVC), Spring Data JPA, and MySQL.
This project streamlines customer relationship management for educational institutions by handling student data, course sales, support services, and lead tracking. This project is first built using Spring MVC and then refactored into a RESTful API to demonstrate understanding of both architectures and the transition from legacy MVC to modern REST.

---

Table of Contents

• Introduction
• Modules
• Features
• Database Design
• Technologies Used
• Deployment

---

Introduction

The Educational CRM project focuses on simplifying how educational institutes manage their customers (students), employees, and course sales.
It provides tools for:

• Managing student and course data efficiently
• Tracking leads and inquiries
• Automating customer follow-ups
• Monitoring sales and performance analytics

---

Modules

1. Admin

• Login & Profile Management (view, update)
• Employee Management (add, view, update)
• Course Management (add, view, update, delete)
• Sales Monitoring and Analytics
• Customer Management (view, search, edit)
• Feedback Collection and Analysis

2. Employee

• Login & Profile Management (view, update)
• Handle Customer Inquiries
• Lead Management (discussion, follow-ups)
• View Assigned Tasks

3. Customer (Student/User)

• Register & Login
• View Available Courses
• Purchase Courses (with payment integration)
• Provide Feedback

---

Features

• Role-based authentication (Admin, Employee, Student)
• Course sales and purchase tracking
• Customer inquiry and follow-up management
• Sales dashboard with analytics & charts
• Data persistence with Hibernate/JPA
• Pagination and filtering
• Feedback collection system

---

Database Design

Tables Overview

Table Name	Description	Key Columns
register	Stores admin and employee login data	id, name, email, password, phone_no, module
customer_register	Stores customer/student data	id, name, email, password, phone_no, city
sales	Tracks course sales and payment details	id, customer_email, course, price, date, time
customer_inquiries	Manages inquiries and follow-ups	id, phone_no, name, interested_course, discussion, inquiry_date, follow_up_date, calling_details

---

Technologies Used

Frontend

• HTML
• JavaScript
• Thymeleaf (Template Engine)

Backend

• Java 21 (LTS)
• Spring Boot (Web MVC)
• Spring Data JPA
• Hibernate ORM

Database

• MySQL

Deployment

• AWS EC2 (Apache Tomcat)

---