Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Grading Rubric For Project 3 - Fall 2022Grading Rubric For Project 3 - Fall 2022CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeThe User InterfaceThe GUI is similar to the GUI as shown...

1 answer below »
Grading Rubric For Project 3 - Fall 2022
Grading Rubric For Project 3 - Fall 2022
CriteriaRatingsPts
This criterion is linked to a Learning OutcomeThe User Interface
The GUI is similar to the GUI as shown in the project document, with full functionality for all buttons, text fields and dropdown lists.
25pts
Full Marks
0pts
No Marks
25pts
This criterion is linked to a Learning OutcomeScreenshots and deliverables
You provided a complete set of screenshots for both the root user and client client user command sequences. The screenshots show the execution, starting from a pristine database, in order, the complete set of root user commands followed by the client user commands. These screenshots should clearly show the complete query/command expression and results for each of the commands when executed via your application. This includes the command sequences as required by non-query DML commands. There are 15 root user commands and 10 client user commands in their respective script files. Each screenshot is clearly labeled as to which command it represents. They should be numbered so that their order is quite clear.
You also provided a screenshot of the contents of the operationscount table AFTER the execution of the root user script and client user script commands have been executed. You also included a screenshot illustrating a mismatch between user entered credentials and those in the selected properties files that resulted in no connection to the database being established.
You also provided all of the .java files (your IDE project) that were used to develop this application. (5pts/screenshot)
40pts
Full Marks
0pts
No Marks
40pts
This criterion is linked to a Learning OutcomeExecution Functionality
The application establishes a connection to a database specified in a .properties file selected by the user. The user must also enter their database credentials via the GUI and these must match with those in the specified .properties file for a connection to be made. Once the connection is established the application must execute the SQL commands entered by the user and output all SQL query results to the SQL Execution Result window of the GUI. (Note that all connection data is loaded from properties files but user credentials entered via the GUI must be verified as matching those in the loaded properties file.) You provided a screenshot verifying that your application handles this correctly.
15pts
Full Marks
0pts
No Marks
15pts
This criterion is linked to a Learning OutcomeInterface Efficiency
You must provide buttons for the user to clear the command window as well as the result window. This will prevent the user from either needing to back out of commands or continue to view old or partially old data.
5pts
Full Marks
0pts
No Marks
5pts
This criterion is linked to a Learning OutcomeConnection Status
The status of the connection must be returned to the GUI and displayed in the connection area. Note, that once this connection is established, it cannot be modified by this application instance.
5pts
Full Marks
0pts
No Marks
5pts
This criterion is linked to a Learning OutcomeProper Use of Metadata
Your application must return and print metadata related to any query command submitted by the user. No command that returns tabular data should be displayed without its corresponding metadata (attribute/column name) being displayed in the output.
5pts
Full Marks
0pts
No Marks
5pts
This criterion is linked to a Learning OutcomeError Handling
Any errors in input submitted by the user that generate a MySQL error, must have that error message returned to the GUI and displayed to the user. See the project document for an example.
5pts
Full Marks
0pts
No Marks
5pts
Total Points:100
Answered 3 days After Oct 21, 2022

Solution

Aditi answered on Oct 24 2022
61 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here