University grading system and stop watch JAVA Programming

ASSIGNMENT #1: Task 1 - University grading system

Task 1 ( 60 marks)

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 ‘database server’. ‘Student_marks_ITC000’ is one of the tables which contains following information for all the students enrolled for ITC000: ‘Student ID’, ‘Student Name’, ‘Marks obtained in Assignment 1’, ‘Marks obtained in Assignment 2’, ‘Marks obtained in Assignment 3’ and ‘Marks obtained in Final’. A sample of the table may look like as follows:

Student ID	Name	Assignment 1	Assignment 2	Assignment 3	Final Exam
1001	Janet	80	100	90	85
1002	Daniel	60	70	75	90

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 final score: Take a student’s ID as input and displays his/her score in each item. It also should calculate and display the final score where final score = 10%(Assignment 1) + 20%(Assignment 2) + 20%(Assignment 3) + 50%(Final exam). 

1.1) Algorithm : Psudocode

- please answer here

1.2) Source code

-- please answer here source code with comments

1.3) Analysis

- please answer here details include any problems to create and run program.

.

1.4) Testing and Output

- please answer here please provide 4 set of testing data and describe the output problems

ASSIGNMENT #1: Task 2 - Stopwatch

Task 2 (40 marks)

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.

Note: For further clarification and concerns about the assignment, students are recommended to contact with the subject lecturer at [email protected]

Rationale

This assignment is designed to asses following learning outcomes:

· be able to create, connect to and update a relational database using the Java Database Connectivity (JDBC);

· be able to design and implement multithreaded Java applications;

· be able to demonstrate the use of the inheritance features of the Java language to design and implement complex object-oriented programs;

2.1) Algorithm : Psudocode

- please answer here

2.2) Source code

-- please answer here source code with comments

2.3) Analysis

- please answer here details include any problems to create and run program.

.

2.4) Testing and Output

- please answer here please provide 4 set of testing data and describe the output problems

Assignment#1