Write a Java GUI application that will keep track of student results at a local college and save the process result into a database. The application must contain the result that a student has obtain for a test, assignment and exam. Question 1 On the form create a list box that will allow the user to select the student ID populate populate from the text file. Also create a search button when clicked will display the average , highest and lowest result according to the student number and a Save button to save the result to an online data base. Student number should be used as a primary key for your database. Question 2 Create a sequential file (student.txt) that contains data for the following fields The student ID number The student test result The student assignment result The student exam result Question 3 Load the data from the student.txt file and populate the list box with the student numbers Question 4 Calculate the average result obtained by the student. Question 5 Determine the highest and lowest result that the student obtained from the three assessments Question 6 Create a database using SQL/MySql. The database should be named StudentResult only include one table name it ResultTable. The result table should have 4 fields( StudentNumber, HighestResult, LowestResult, and Average). On your interface include a Save option to save the data in the Result table. Sample Output

Write a Java GUI application that will keep track of student results at a local college and save the process result into a database. The application must contain the result that a student has obtain for a test, assignment and exam.

Question 1

On the form create a list box that will allow the user to select the student ID populate populate from the text file. Also create a search button when clicked will display the average , highest and lowest result according to the student number and a Save button to save the result to an online data base. Student number should be used as a primary key for your database.

Question 2

Create a sequential file (student.txt) that contains data for the following fields

• The student ID number
• The student test result
• The student assignment result
• The student exam result

Question 3

Load the data from the student.txt file and populate the list box with the student numbers

Question 4

Calculate the average result obtained by the student.

Question 5

Determine the highest and lowest result that the student obtained from the three assessments

Question 6

Create a database using SQL/MySql. The database should be named StudentResult only include one table name it ResultTable. The result table should have 4 fields( StudentNumber, HighestResult, LowestResult, and Average). On your interface include a Save option to save the data in the Result table.

Sample Output