Distinguished - Provides output on three, or more than three, SQL command queries specified. Includes all required fields and data, and includes complex examples of the required operations.

Proficient - Provides output on the three SQL command queries specified. Includes all required fields and data, and includes examples of the operations.

Basic - Provides output on two of the required SQL command queries specified. Includes some of the required fields and data and includes examples of the operations.

Below Expectations - Attempts to provide output on the required SQL command queries; however, the queries provided show few of the required elements, and examples of the operations are not included.

Non-Performance - The SQL command queries are either nonexistent or lack the components described in the assignment instructions.

Distinguished - Uses complex SQL statements to add a Birthday field to the Customers table, and populates the Birthday field for some of the table records.  Populates all of the other fields with data. The SQL statement shown in the screenshot with before and after data is well presented and professionally formatted.

Proficient - Uses complex SQL statements to add a Birthday field to the Customers table, and populates the Birthday field for some of the table records.  Populates most of the other fields with data.  Shows the SQL statement in a screenshot with before and after data.

Basic - Uses valid SQL statements to add a Birthday field to the Customers table, and populates the Birthday field for some of the table records.  Populates some of the other fields with data.  Shows the SQL statement in a screenshot with before and after data.

Below Expectations - Attempts to use SQL statements to add a Birthday field to the Customers table; however, the statements are not valid, the fields are not populated with data, and/or the SQL statement is not shown in a screenshot with before and after data.

Non-Performance - The SQL statement and screenshots are either nonexistent or lack the components described in the assignment instructions.

Distinguished - Creates a professionally rendered report showing all customer names, states, and phone numbers. Shows the SQL statements and the report in a screenshot.

Proficient - Creates a report showing most customer names, states, and phone numbers. Shows the SQL statements and the report in a screenshot.

Basic - Creates a report showing some customer names, states, and phone numbers. Shows the SQL statements and the report in a screenshot.

Below Expectations - Attempts to create a report showing customer names, states, and phone numbers; however, the report shows little customer information or shows only the table and no report. The SQL statements are invalid or not shown in a screenshot.

Non-Performance - The report and the SQL statements are either nonexistent or lack the components described in the assignment instructions.

Distinguished - Creates a professionally rendered report showing contact names and birthdays. Shows the report and the SQL statements in a screenshot. The SQL statements shown are complex.

Proficient - Creates a report showing contact names and birthdays. Most records shown have a birthday. Shows the report and the SQL statements in a screenshot.

Basic - Creates a report showing contact names and birthdays. Some records shown have a birthday. Shows the report and the SQL statements in a screenshot.

Below Expectations - Attempts to create a report showing contact names and birthdays; however, few records shown have a birthday, the report is not shown in a screenshot, and/or the SQL statements are not shown or are invalid.

Non-Performance - The report showing contact names and birthdays is either nonexistent or lacks the components described in the assignment instructions.

Distinguished - Provides a comprehensive explanation of referential integrity, and includes how the lack of referential integrity can compromise data in the database. Accurately identifies the referential integrity in the database, and shows the affected tables in each dataset and how the data elements are impacted as the result of the primary update, add, delete (UAD) operations in a before and after screenshot.

Proficient - Provides an explanation of referential integrity, and includes how the lack of referential integrity can compromise data in the database. Identifies the referential integrity in the database, and shows the affected tables in each dataset and how the data elements are impacted as the result of the three primary update, add, delete (UAD) operations in a before and after screenshot. Minor details may be missing or inaccurate.

Basic - Provides a partial explanation of referential integrity, and somewhat includes how the lack of referential integrity can compromise data in the database. Partially identifies the referential integrity in the database, and shows the affected tables in one dataset and how some of the data elements are impacted as the result of the primary update, add, delete (UAD) operations in a before and after screenshot. Relevant details are missing and/or inaccurate.

Below Expectations - Attempts to provide an explanation of referential integrity, and to include how the lack of referential integrity can compromise data in the database, to identify the referential integrity in the database, and to show the affected tables in each dataset and how the data elements are impacted as the result of the three primary update, add, delete (UAD) operations in a before and after screenshot; however, significant details are missing and inaccurate.

Non-Performance - The explanation of referential integrity and identification of the referential integrity in the database are either nonexistent or lack the components described in the assignment instructions.

Distinguished - Displays meticulous comprehension and organization of syntax and mechanics, such as spelling and grammar. Written work contains no errors and is very easy to understand.

Proficient - Displays comprehension and organization of syntax and mechanics, such as spelling and grammar. Written work contains only a few minor errors and is mostly easy to understand.

Basic - Displays basic comprehension of syntax and mechanics, such as spelling and grammar. Written work contains a few errors which may slightly distract the reader.

Below Expectations - Fails to display basic comprehension of syntax or mechanics, such as spelling and grammar. Written work contains major errors which distract the reader.

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

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.

Distinguished - The length of the paper is equivalent to the required number of correctly formatted pages. 

Proficient - The length of the paper is nearly equivalent to the required number of correctly formatted pages. 

Basic - The length of the paper is equivalent to at least three quarters of the required number of correctly formatted pages.

Below Expectations - The length of the paper is equivalent to at least one half of the required number of correctly formatted pages.   

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

Distinguished - Uses more than the required number of scholarly sources, providing compelling evidence to support ideas. All sources on the reference page are used and cited correctly within the body of the assignment.

Proficient - Uses the required number of scholarly sources to support ideas. All sources on the reference page are used and cited correctly within the body of the assignment.

Basic - Uses less than the required number of sources to support ideas. Some sources may not be scholarly. Most sources on the reference page are used within the body of the assignment. Citations may not be formatted correctly.

Below Expectations - Uses an inadequate number of sources that provide little or no support for ideas. Sources used may not be scholarly. Most sources on the reference page are not used within the body of the assignment. Citations are not formatted correctly.

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