StudentInformationSystem

FullStackWeb Project using REST api implementation details

Front end (HTML + CSS + BootStrap + JavaScript + jQuery)
Back end (Java + Jersy + JDBC + MySQL)
Database Schema

create database studentproject;
use studentproject;


CREATE TABLE `student` (  
  `Name` varchar(100) NOT NULL,  
  `DOB` date NOT NULL,  
  `rollNumber` int NOT NULL,  
  `physicsMarks` double DEFAULT NULL,  
  `chemistryMarks` double DEFAULT NULL,  
  `mathematicsMarks` double DEFAULT NULL,  
  PRIMARY KEY (`rollNumber`),  
  CHECK ( `rollNumber` > 0 )  
);