Description:
Total Possible Score: 10.00
Distinguished - Expertly creates a database, and translates the normalized Week 3 ERD into SQL server entities. All entities on the ERD are present in SQL.
Proficient - Creates a database, and translates the normalized ERD from the Week 3 assignment into SQL server entities. Most of the entities on the ERD are present in the SQL.
Basic - Creates a database, and partially translates the normalized ERD from Week 3 into SQL server entities. Some of the entities on the ERD are present in the SQL.
Below Expectations - Attempts to create a database and translate the normalized ERD from Week 3 into the SQL server entities; however, the database is incomplete, and many entities on the ERD are missing in the SQL.
Non-Performance - The SQL database and entities are either nonexistent or lack the components described in the assignment instructions.
Distinguished - Expertly creates all entities with appropriate attributes, selects and fully documents the appropriate data types for all fields, and accurately translates business requirements into integrity constraints.
Proficient - Creates all entities with appropriate attributes, selects appropriate data types for all fields, and translates business requirements into integrity constraints. Minor details are missing or slightly inaccurate.
Basic - Partially creates entities with appropriate attributes, selects appropriate data types for some of the fields, and partially translates business requirements into integrity constraints. Relevant details are missing and/or inaccurate.
Below Expectations - Attempts to create entities with appropriate attributes, select appropriate data types, and translate business requirements into integrity constraints ; however, significant details are missing and inaccurate.
Non-Performance - The entities, attributes, and data types are either nonexistent or lack the components described in the assignment instructions.
Distinguished - Expertly builds the ERD using the SQL Server Diagramming tool, and includes appropriately labeled screenshots of the ERD and all of the individual tables in the document.
Proficient - Builds the ERD using the SQL Server Diagramming tool, and includes labeled screenshots of the ERD and most of the individual tables in the document. Minor details are missing.
Basic - Partially builds the ERD using the SQL Server Diagramming tool, includes some labeled screenshots of the ERD and the individual tables in the document. Relevant details are missing.
Below Expectations - Attempts to build the ERD and include screenshots of the ERD and individual tables in the document; however, does not use the SQL Server Diagramming tool, screenshots are not appropriately labeled, and significant details are missing.
Non-Performance - The ERD document is either nonexistent or lacks the components described in the assignment 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.