University Grading System and Stopwatches

The assignment requires two Java programs to be written. The first program is designed to create, insert records into, search, update and calculate results and grades for a university grading system. The program will use tables with attributes like StudentID, StudentName, Quiz scores, Assignment1-3, Exam score, Results and Grade. The second program simulates multiple stopwatches (e.g., 4) using multithreading concept. Each stopwatch's time can be increased or decreased using keyboard keys and the times of all stopwatches will be displayed in text format and graphically with a GUI design.

Task 1
University grading system maintains number of tables to store, retrieve and manipulate student
marks. These tables reside in a centrally or locally located server known as ‘GradeProcessing’.
‘ITC521’ is one of the tables which contains following information/attributes for all the students
enrolled in ITC521: ‘StudentID’, ‘StudentName’, Quiz', "‘Assignment1’, ‘Assignment2’, ‘ Assignment3’
‘Exam’, 'Results' and 'Grade'. A sample of the table may look like as follows:
StudentID StudentName Quiz Assignment1 Assignment2 Assignment3 Exam Results Grade
11111111 X 100 80 100 90 90 91 HD
22222222 Y 100 60 80 80 80 78 DI
Write a JAVA program that would perform following tasks:
 Create Table: Create a table that is capable to store above information.
 Insert Record: If the user of your program wants to insert a record, your program should ask
for all the fields of the record and insert them in the table.
 Search: The user of your program should be able to search a particular record by ID or any
other field.
 Update: The user of your program should be able to update any field/s of a particular record.
The record in which the update operation needs to be done will be selected by Student ID.
 Calculate Results: The results of a student should be calculated using the following formula:
Results = (Quiz * 0.05)+(Assignment1 * 0.15) +(Assignment2 * 0.2) + (Assignment3 * 0.10) +
(Exam * 0.5)
 Calculate Grade:
HD: Results>=85
DI: 75<=Results<85
CR: 65<=Results<75
PS: 50<=Results<65
FL: 75<=Results<50
Task 2
Write a JAVA program that would simulate a number of stopwatches (e.g. 4 stopwatches) times using
the concept of Multithreading. The time of stopwatches increase on their own. Moreover, a
stopwatch’s time can be increased and decreased using specified keys from the keyboard. Please
note that, initially the time in each stopwatch would be zero. The time of all the stopwatches should be
displayed in the screen in both text format and graphically. For each stopwatch design a GUI in
circular shaped (like real stopwatch) for the graphical representation of time.