/SaleskenProject

This is the Spring Boot project for Student Reporting System for Salesken.

Primary LanguageJava

Students Reporting System

Students Reporting System spring boot application

student-report-management-system-1620319712-577

About

Student Reporting System is able to perform all the CRUD based operation and can manage data to the database hassle free.

Features

  • Student record can be registerd to the database
  • User can see average percentage of whole class in a recent semester
  • User can see average marks of Students in a particular subject
  • User can see the top 2 student's average marks

Technologies and Dependencies Used

  • Java
  • Spring Boot
  • Spring Data JPA
  • Spring Web
  • Devtools
  • MySQL
  • Lombok
  • Maven

Backend Design

ER Diagram

New Microsoft PowerPoint Presentation

Schema

  • Student table

  • Database Schema



API Root and Endpoint

  • Register one student entity to the database
  • Method : POST
http://localhost:8888/students
  • Get all the student from the database
  • Method : GET
http://localhost:8888/students
  • Get avarage marks of all students for semester 1
  • Method : GET
http://localhost:8888/students/semester1
  • Get avarage marks of all students for semester 2
  • Method : GET
http://localhost:8888/students/semester2
  • Find the avarage marks of top 2 students
  • Method : GET
http://localhost:8888/students/top/2