ISM641.W6A1.05.2016

Description:


Total Possible Score: 25.00

Summarizes the Project Parameters Including a Short Description of Each of the Following Sections: Conceptual Design, Normalization Phase, Physical Design, Data Retrieval, and Stored Procedures

Total: 4.00

Distinguished - Thoroughly summarizes the project parameters including concise descriptions of the required sections.

Proficient - Summarizes the project parameters including a short description of each of the required sections. Minor details are missing.

Basic - Partially summarizes the project parameters including a short description of most of the required sections. Relevant details are missing.

Below Expectations - Attempts to summarize the project parameters and include short descriptions of required sections; however, significant details are missing.

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


Develops the ERD Using Visio. ERD is Based on the Business Rules; Includes Identification of All Entities, Attributes, and All Primary Keys; and Defines All Relationships Between Entities

Total: 3.00

Distinguished - Expertly develops the ERD using Visio. The ERD thoroughly reflects all relevant business rules; comprehensively identifies all entities, attributes, and primary keys; and comprehensively defines all relationships between entities and provides annotations that document the relationship(s).

Proficient - Develops the ERD using Visio. ERD includes the appropriate business rules; identifies all entities, attributes, and primary keys; and defines all relationships between entities. Minor details are missing.

Basic - Develops the ERD using Visio. ERD partially reflects the business rules; partially identifies the entities, attributes, and primary keys; and minimally defines the relationships between entities. Relevant details are missing.

Below Expectations - Develops the ERD using Visio. The ERD attempts to reflect some of the business rules; identify the entities, attributes, and primary keys; and define the relationships between entities; however, significant details are missing.

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


Creates the Logical Data Model, Verifies the Model Meets 3rd Normal Form, Describes the Three Normal Forms, and Justifies How Each of the Tables in the Model Meets 1NF, 2NF and 3NF

Total: 3.00

Distinguished - Expertly creates the Logical Data Model, accurately verifies that the model meets 3rd Normal Form, thoroughly describes the three normal forms, and completely justifies how each of the tables in the model meets the three normal forms.

Proficient - Creates the Logical Data Model, verifies the model meets 3rd Normal Form, describes the three normal forms, and justifies how each of the tables in the model meets the three normal forms. Minor details are missing or slightly inaccurate.

Basic - Partially creates the Logical Data Model, partially verifies that the model meets 3NF, minimally describes the three normal forms, and partially justifies how each of the tables in the model meets the three normal forms. Relevant details are missing and/or inaccurate.

Below Expectations - Attempts to create the Logical Data Model, verify 3NF of the model, describe the three normal forms, and justify how the tables in the model meets the three normal forms; however, significant details are missing and inaccurate.

Non-Performance - The logical data models are either nonexistent or lack the components described in the assignment instructions.


Creates a Database in SQL Server, Translates the ERD into Tables with Appropriate Fields, Selects the Appropriate Data Type for All Fields, Specifies All Primary Keys as “Identity” Fields, and Populates the Tables with Sample Data Using the “Insert” Command

Total: 3.00

Distinguished - Expertly creates a well-structured database in SQL server, and translates the ERD into tables with appropriate fields. Tables and fields are fully documented with appropriate explanatory information. Selects the appropriate data type for all fields, and specifies ‘identity’ for all primary key fields. The tables are populated with sample data using the “insert” command.

Proficient - Creates a database in SQL server. Translates the ERD into tables with appropriate fields. Selects the appropriate data type for all fields. Specifies all primary keys as “identity” fields. Populates the tables with sample data using the “insert” command. Minor details are missing.

Basic - Creates a database in SQL server. Partially translates the ERD into tables and fields. Selects the appropriate data type for most of the fields, though some fields are assigned incorrect data types. Some primary keys are misidentified as something other than “identity” fields. Partially populates the tables with sample data using the “insert” command. Relevant details are missing.

Below Expectations - Attempts to create a database in SQL server. The database may be non-existent or inadequately defined. May attempt to translate the ERD into tables and fields, though some of the tables and/or fields are missing from the database. May select the appropriate data type for some of the fields, though many fields are assigned incorrect data types. Primary keys are misidentified as something other than “identity” fields. May not populate the tables with sample data using the “insert” command. Significant details are missing.

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


Provides Select Statements Satisfying the Seven Required Data Requests Including Screen Shots of the SQL Statements Used to Perform Each Step as well as the Result Sets from the Execution of the SQL Statements, and Describes What Was Done to Complete Each Step

Total: 3.00

Distinguished - Provides select statements expertly satisfying the seven required data requests including screen shots with comments of the SQL statements used to perform each step and the result sets from the SQL statements, and comprehensively describes what was done to complete each step.

Proficient - Provides select statements satisfying the seven required data requests including screen shots of the SQL statements used to perform each step and the result sets from the execution of the SQL statements, and describes what was done to complete each step. Minor details are missing.

Basic - Provides select statements partially satisfying the seven required data requests including screen shots of the SQL statements used to perform each step, and minimally describes what was done to complete each step. Relevant details are missing.

Below Expectations - Attempts to provide select statements satisfying the seven required data requests including screen shots of the SQL statements used to perform each step  and describe what was done to complete each step; however, significant details are missing.

Non-Performance - The description, screen shots, and SQL statements are either nonexistent or lack the components described in the assignment instructions.


Modifies the Java Code Provided in Plain Text to Retrieve the List of Required Data Elements Identified in the Prompt. Additional Records Are Inserted By the Code Where Required

Total: 4.00

Distinguished - Expertly modifies the Java code provided in plain text to retrieve a list of required data elements  identified in the prompt, and additional records are inserted appropriately by the code where required. Includes ample informational comments in the modified code.

Proficient - Modifies the Java code provided in plain text to retrieve a list of required data elements identified in the prompt. Additional records are inserted by the code where required.  Minor details are missing.

Basic - Partially modifies the Java code provided in plain text to retrieve a list of required data elements identified in the prompt. Some additional records are inserted by the code. Relevant details are missing.

Below Expectations - Attempts to modify the Java code provided in plain text; however, the program does not retrieve a list of required data elements, results in fatal errors, and does not insert additional records  Significant details are missing.

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


Written Communication: Control of Syntax and Mechanics

Total: 1.00

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.


Written Communication: APA Formatting

Total: 1.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.


Written Communication: Page Requirement

Total: 2.00

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.


Written Communication: Resource Requirement

Total: 1.00

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.