Implementing a Student Record and Stopwatch System in Java (ITC521)

This project involves developing a Java program to manage student records and simulate stopwatches. The student record system requires creating, inserting, searching, and updating records, along with calculating results and grades based on specific formulas. The program also needs to implement a multithreading component to simulate multiple stopwatches simultaneously. Each stopwatch should have a graphical user interface (GUI) represented as a circular design, allowing time to be displayed and controlled through keyboard input. The Java program will demonstrate proficiency in database interactions, multithreading, and GUI design, providing a comprehensive solution for managing student data and simulating timekeeping devices.

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.