Reference no: EM13477398

TASK 1

You must setup your program so that it connects to a MYSQL database named "grading_db", running on "localhost".
The username must be "grader" and "abc" (user name/password).
The first thing your program must do is to crate the tables in this database.

You can either provide a button that I click on for this to happen (if you are building a GUI), a text-menu option, or to just do this on startup (my preferred option).

Of course, if you choose the latter, you will get extra mark if your program first checks that the table(s) already exist so that you don't destroy existing data.

Then, provide menu options for inserting records, and searching.

The search results should show the student's marks, and also display the calculated total final score (the formula for this in the assignment description in the subject outline).

TASK 2

Here's some clarification on what is expected for Task 2.

* I imagine 4 cars, implemented a threaded classes (implementing Runnable), running in a pool.
* Each contains a speed instance variable.
* On the keyboard, I assign two keys for each car, one for acceleration and one for deceleration.

For example, if I press "q", the speed of car 1 will go up by 1, and if I press "w", the speed of car 1 will go down by 1.
* Each threaded car will listen for key presses independently. This can be done using a KeyListener to capture key events.
* To graphically display the car speeds, I suppose something like a bar graph would be acceptable, with the text speed indicators somewhere in the same jPanel.

There is no single way to do this. Think about your GUI skills (current and desired) and imagination, and create a graphical representation.

This could be a simple bar graph, or a race course-style visualisation with animation and visual effects.

There are two deliverables:

1) The report

2) A NetBeans archive with your code and project assets.

1. REPORT

Quoting from the subject outline, here's the report requirements:

"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."

In other word, you must provide clear instructions to me on how to run your programs. Include screenshots showing your programs in action, with descriptions with each screenshot. These images will be my fallback in case I am unable to get your programs to run on my computer.