Write java code using JDBC to do the following:

$1.$ Create a database and a table Student with the following details: Name, BITSID, Sub$1\_$marks, Sub$2\_$marks, Sub$3\_$marks and Sub$4\_$marks, total, average and result.

$2.$ Insert data only for the following columns: Name, BITSID, Sub$1\_$marks, Sub$2\_$marks, Sub$3\_$marks and Sub$4\_$marks

$3.$ Fetch the result into local variables in java using the result set. Calculate the total, average and result $($Pass if all marks $>=50).$

$4.$ Update the Student table to reflect the total, average and result.

$5.$ Fetch the updated data and display the student$$s mark sheet in a neat format for all the students.