i I have no idea what to do here   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.

Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter9: Sequential Access Files And Menus
Section: Chapter Questions
Problem 4E
icon
Related questions
Question

hi I have no idea what to do here

 

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.

Expert Solution
steps

Step by step

Solved in 7 steps with 4 images

Blurred answer
Knowledge Booster
Data Binding
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage