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).
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
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;
Task 1
| Items | Full Marks | PS | CR (PS+) | DI (CR+) | HD (DI+) |
|---|---|---|---|---|---|
| Presentation | 10 | Very basic presentation (no screen shots are included) | Report with few screen shots is submitted | Report with enough screen shots is submitted | Report with enough screen shots is submitted. The discussion on each screen shot is easy to read and understand. |
| Create Table | 10 | A table is created but provides no error/warning message | Any error/warning is handled | Program checks the validation of the fields before sending the query to the MySQL | Some suggestions about fields and table creation confirmation message is displayed |
| Insert Record | 10 | A record is inserted but provides no error/warning message | Any error/warning is handled | Program checks the validation of the fields before
inserting a record in the table |
Some suggestions about fields and insertion confirmation message is displayed |
| Search | 10 | A record is searched correctly but provides no error/warning message | Any error/warning is handled | Program checks the validation of the field to be searched before running search operation in the table | Some suggestions about fields and all search results are displayed |
| Update | 10 | A record is updated correctly but provides no error/warning message | Any error/warning is handled | Program checks the validation of the field before running update operation in the table | Some suggestions about fields and all updated results are displayed |
| Calculate Final Score | 10 | There are some mistakes in calculating final score | Final score is perfectly calculated | All error/warning message is properly handled | |
Task 2
| Items | Full Marks | PS | CR (PS+) | DI (CR+) | HD (DI+) |
|---|---|---|---|---|---|
| Presentation | 10 | Very basic presentation (no screen shots are included) | Report with few screen shots is submitted | Report with enough screen shots is submitted | Report with enough screen shots is submitted. The discussion on each screen shot is easy to read and understand. |
| Stopwatches increase the time on their own. | 15 | There are some errors in showing the actual time
of all the stopwatches |
No error in showing the
time itself. However the interface is not fully clear to the user. |
The time of corresponding stopwatch increases perfectly and displayed in text and graphics. | |
| A user can increase/decrease the time of stopwatches using the specified keys of keyboard.
|
15 | There are some errors in showing the actual time
of all the stopwatches |
No error in showing the
time itself. However the interface is not fully clear to the user. |
A user can increase/decrease the time of stopwatches properly using the specified keys of keyboard. The time of the stopwatches are displayed clearly both in text and graphics. | |
Following items are to be submitted in the Turnitin (For each task):
- Report: The report (in .doc or .pdf format) should explain how to run your program (1 or 2 page long) and any settings needed to run your program. Enough number of screenshots should be shown in the document. In case if the assignment marker fails to run your program, because of any inconvenience, these screenshots would show how the program worked on your machine/environment.
- Source code and other files: All source codes, exe file and other relevant files must have to be zipped in a folder such that unzipping would keep the file/folder structure unaffected
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]