INF322.W3A1.02.2015

Description:


Total Possible Score: 20.00

Shows a Screenshot of 10 Customers Added to the Database Using the Customers Table, and Includes the SQL Statement(s) Used to Create the Entries

Total: 4.00

Distinguished - Shows a screenshot of 10 or more customers added to the database using the Customers table, and includes complex SQL statements used to create the entries.

Proficient - Shows a screenshot of 10 customers added to the database using the Customers table, and includes SQL statement(s) used to create the entries.

Basic - Shows a screenshot of at least nine customers added to the database using the Customers table, or does not include the SQL statement(s) used to create the entries.

Below Expectations - Attempts to show a screenshot and include SQL statement(s) used to create the entries; however, the screenshot does not show any indication of new data added to the database using the Customers table and/or does not include the SQL statements(s) used to create the entries.

Non-Performance - The screenshot of 10 customers added to the database using the Customers table is either nonexistent or lacks the components described in the assignment instructions.


Uses a Valid SQL Statement to Update One Customer Record in the Database, Shows Before and After Data and Includes the SQL Statement Used

Total: 4.00

Distinguished - Uses valid SQL statements to update more than one element in a customer record in the database, shows before and after data in a screenshot,  and includes complex SQL statements used.

Proficient - Uses a valid SQL statement to update at least one element in a customer record in the database, shows before and after data in a screenshot,  and includes the SQL statement used.

Basic - Attempts to use a SQL statement to update one element in a customer record in the database, but the statement is not valid, or before and after data or the SQL statement used is not shown.

Below Expectations - Attempts to use a SQL statement to update an element in a customer record in the database and show before and after data; however, the SQL statement is not valid, and the SQL statement used is not included.

Non-Performance - The usage of the SQL statement and before and after data is either nonexistent or lacks the components described in the assignment instructions.


Adds and Deletes an 11th Customer Record with Valid SQL Statement(s), Shows Before and After Data, and Includes the SQL Statement(s) Used

Total: 5.00

Distinguished - Adds and deletes an 11th customer record, or more, with valid SQL statement(s), shows before and after data in a screenshot, and includes the complex SQL statement(s) used.

Proficient - Adds and deletes an 11th customer record with valid SQL statement(s), shows before and after data in a screenshot, and includes the SQL statement(s) used.

Basic - Partially adds and/or partially deletes an 11th customer record. Parts of the SQL statement(s) used are not valid. Shows before and after data in a screenshot, including the SQL statement(s) used.

Below Expectations - Attempts to add and delete an 11th customer record; however, the SQL statement(s) are not valid, before and after data is not shown in a screenshot, and the SQL statement(s) used are not included.

Non-Performance - The evidence of the addition and deletion of an 11th customer record is either nonexistent or lacks the components described in the assignment instructions.


Creates a Report Displaying the Customer Records, and Identifies the Primary Keys for the Table

Total: 5.00

Distinguished - Creates a professional report displaying the customer records using multiple tables, and identifies the primary keys in all the tables. The screenshot of the report shows customers and identifies primary keys of all tables used in SQL query.

Proficient - Creates a report displaying the customer records, and identifies the primary key in the table. The screenshot of  the report shows customers and identifies the primary key of the table.

Basic - Creates a report displaying partial customer records, or does not identify the primary key in the table. The screenshot of the report shows partial information on customers or does not identify the primary key of the table.

Below Expectations - Attempts to create a report displaying the customer records, but does not identify the primary key in the table. The screen shot of the report does not show customers, or it does not identify the primary key of the table.

Non-Performance - The creation of the report displaying customer records and the identification of the primary keys of the table are either nonexistent or lack the components described in the assignment instructions.


Written Communication: APA Formatting

Total: 2.00

Distinguished - Accurately uses APA formatting consistently throughout the paper, title page, and reference page.

Proficient - Exhibits APA formatting throughout the paper. However, layout contains a few minor errors. 

Basic - Exhibits limited knowledge of APA formatting throughout the paper. However, layout does not meet all APA requirements. 

Below Expectations - Fails to exhibit basic knowledge of APA formatting. There are frequent errors, making the layout difficult to distinguish as APA.

Non-Performance - The assignment is either nonexistent or lacks the components described in the instructions.