Database Application - A Java GUI Based Program - IT/Computer Science Assignment Help

Assignment Task

Task 1: Database Application
For this program, you are to write a Java GUI-based program that allows the user to view, insert and update information within a MySQL database. 
Your database will contain only one table, called Staff, with the following fields: An ID (the primary key), last name, first name, middle initial (MI), address, city, state (ACT, NSW, NT, QLD, SA, TAS, VIC, WA), and a telephone number. 
Your program should allow the user to view a staff record with a specified ID, to insert a new record into the table, to update any field (except the ID) of an existing staff member record, and to clear all fields from the display. Your GUI design should be similar to the image below. In addition, make sure you include the following features: 
• Display an appropriate message indicating the success or failure of the View/Insert/Update operations. For example, "Record found/record not found" when the user selects View, "Record Inserted/failed to insert" when the user selects Insert, and "Record updated/failed to update" when the user selects Update. 
• When no record is displayed (e.g., when the program first starts), or when the user selects Clear, display a message inviting the user to view or insert a new record. 
• When inserting a new record, the ID field should be generated automatically so that it is unique for the table. 
• The ID field should only be editable when the user chooses to search for a new record to View. IDs returned from the database through the View operation, or generated as part of the Insert operation, should not be editable. 
• When Inserting or Updating a record, ensure all fields (e.g., Last name, first name, etc.) are not left blank, and that the telephone number contains only digits. Ensure the state is valid.

Task 2: Data Visualisation
Using the same database as in Task 1 above, write a Java GUI application that connects to your database and displays a pie chart representation for the percentage of staff in the Staff table that reside in each state. Your display should look similar to the image below. Only display output for the states where staff reside. In addition to the pie chart graphic, make sure you report the written percentage for each state in a legend that appears at the bottom of the window. 

Task 3: Multi-threaded Animation 
The program described in listing 15.12 of your textbook displays a bouncing ball, as shown below: 

Modify this program so that 
• It has a label which displays the current speed of the ball
• Users can increase and decrease the speed of the ball by using an up or down arrow key 
• It uses a thread to animate the bouncing ball movements
Acknowledgment: Task 3 is based on Exercise 32.6 from the textbook.
RATIONALE
back to top
This assessment task will assess the following learning outcome/s:
• Be able to design and implement multithreaded Java applications.
• Be able to design and construct Java Graphical User Interfaces (GUI) that interact with problem domain objects.
• Be able to create, connect to and update a relational database using the Java Database Connectivity (JDBC).

This IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.