Java Programing

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 Assignment1 Assignment2 Assignment3 Final;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.;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 cars? (e.g. 4) speed meter using the concept of Multithreading. A car?s speed can be both increased and decreased using specified keys from the keyboard. The speed of all the cars should be displayed on the screen both in text format and graphically simultaneously.;Note: For further clarification and concerns about the assignment, students are recommended to talk to the subject lecturer at;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