java programming 2

TASK 1 In regards to part 1 of this assessment, please read the following instructions carefully so that you can submit your program for marking succesfully. 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. please read this carefully, it contains instruction on how to submit your Assignment 2. 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. VERY IMPORTANT: Take care so that your report is well formatted and easy to read. Use large headers before each sections. The first page must contain your full name and student ID. REPORT SUBMISSION: Turnitin. Class ID: 8407424, Password: itc521313 2. Code Archive You need to submit your code to me in a format that I can use to easily run your programs. Since our lab is equiped with NetBeans, we will use this as the minimum standard for code submittion. Please follow these steps: a. Find the folder that contains your assignment 2 Netbeans project. b. Compress it using ZIP c. Rename it to something like this: "111222333-ITC521-Assignment2.zip" (obviously, change 111222333 to your actual student ID, and ITC521 to ITC313 if that's your class - Got to say this because I have been blinded in the past). d. Upload the archive to Interact. Go to ITC521 or ITC313, then Resources --> Assignment project archives --> Assignment 2 NETBEANS archives, and upload your ZIP file. OTHER IMPORTANT INFORMATION Please take the time to read the marking criteria section in the Subject Outline for this assignment. I will be marking your work based on these criteria. The assignment requirements are basic, and that leaves you with a lot of room to make design and implementation desisions. For example, the requirements ask you to implement a zoom feature, but don't explicit state how that is supposed to work. The more work and effort you put in this, the higher your mark will be as per the marking criteria. Any questions, please ask. Peter