INF322.W5A2.11.2016

Description:


Total Possible Score: 30.00

Background of the Proposed System is Provided

Total: 2.40

Distinguished - Provides a comprehensive background of the proposed system. All required content is included.

Proficient - Provides a background of the proposed system. Minor details are missing.

Basic - Provides a limited background of the proposed system. Relevant details are missing.

Below Expectations - Attempts to provide background of the proposed system; however, significant details are missing.

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


The Database Structure is Provided Including Data Items, Entities, and Attributes

Total: 2.40

Distinguished - Provides a comprehensive description of the database structure. Data items are identified. More than five entities are listed. More than five attributes for each entity are provided. All required items are included.

Proficient - Provides a description of the database structure. Data items are identified. A minimum of five entities are listed. A minimum of five attributes for each entity are provided. Minor details are missing.

Basic - Provides a limited description of the database structure. Data items are identified. Three to four entities are listed. Three to four attributes for each entity are provided. Relevant details are missing.

Below Expectations - Attempts to provide a description of the database structure; however, significant details are missing. Data items are identified.  Entities are listed. One to two attributes for each entity are provided.

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


Constraints, Restrictions, and Entity Relationships are Defined

Total: 2.40

Distinguished - Provides a comprehensive definition of constraints for more than two attributes in each entity. Relationships between entities are provided.

Proficient - Provides a definition of constraints for at least two attributes in each entity. Relationships between entities are provided. Minor details are missing.

Basic - Provides a limited definition of constraints for at least one attribute in each entity. Relationships between entities are provided. Relevant details are missing.

Below Expectations - Attempts to provide a definition of constraints for e attribute in each entity. Relationships between entities are not provided. Significant details are missing.

Non-Performance - The description of the database constraints and entity relationships is either nonexistent or lacks the components described in the assignment instructions.


The Entity-Relation (ER) Diagram is Provided Using the Entity Relationship Diagram PowerPoint Drawing Tool

Total: 2.40

Distinguished - Provides a comprehensive Entity-Relationship model of your database including more than two related entities, primary keys, attributes, and relationships between entities and attributes.

Proficient - Provides an Entity-Relationship model of your database including at least two related entities, primary keys, attributes, and relationships between entities and attributes. Minor details are missing.

Basic - Provides a limited Entity-Relationship model of your database missing some required items: at least two related entities, primary keys, attributes, and relationships between entities and attributes. Relevant details are missing.

Below Expectations - Attempts to provide an Entity-Relationship model of your database; however, significant details are missing.

Non-Performance - The Entity-Relationship model of your database is either nonexistent or lacks the components described in the assignment instructions.


Primary Keys and Foreign Keys are Identified

Total: 2.40

Distinguished - Provides a comprehensive description of primary keys and at least two foreign keys.

Proficient - Provides a description of primary keys and at least two foreign keys. Minor details are missing.

Basic - Provides a limited description of primary keys and at least one foreign keys. Relevant details are missing.

Below Expectations - Attempts to provide a description of primary keys and foreign keys; however, significant details are missing.

Non-Performance - The description of primary keys and at least two foreign keys is either nonexistent or lacks the components described in the assignment instructions.


SQL CREATE TABLE and Results are Provided. Code and Results are Added to Word or PDF File for Upload Into Final Project

Total: 2.20

Distinguished - Creates and executes the CREATE Table query command. Specifies the columns data types and the NULL/NOT NULL constraint for each column. Code runs successfully with no errors. The code is clean and works efficiently.

Proficient - Creates and executes the CREATE Table query command. Specifies the columns data types and the NULL/NOT NULL constraint for each column. The code needs few changes to make it more efficient.

Basic - Creates and executes the CREATE Table query command. Specifies the columns data types and the NULL/NOT NULL constraint for each column. The code needs several changes to make it more efficient.

Below Expectations - Creates and executes the CREATE Table query command. Specifies the columns data types and the NULL/NOT NULL constraint for each column. The code needs significant changes to make it more efficient.

Non-Performance - The creation and execution of the SQL Create Table query are either nonexistent or lack the components described in the assignment instructions.


SQL INSERT Commands and Results are Provided

Total: 2.20

Distinguished - Creates and executes the INSERT INTO query command for more than five rows of data. Code runs successfully with no errors. The code is clean and works efficiently.

Proficient - Creates and executes the INSERT INTO query command for five rows of data. Code runs successfully with no errors. The code needs few changes to make it more efficient.

Basic - Creates and executes the INSERT INTO query command for two to four rows of data. The code needs several changes to make it more efficient.

Below Expectations - Creates and executes the INSERT INTO query command for a row of data. The code needs significant changes to make it more efficient.

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


CREATE VIEW Commands and Results are Provided

Total: 2.40

Distinguished - Creates and executes the CREATE VIEW command. Creates more than two views for your database. Code runs successfully with no errors. The code is clean and works efficiently.

Proficient - Creates and executes the CREATE VIEW command. Creates two views for your database. The code needs few changes to make it more efficient.

Basic - Creates and executes the CREATE VIEW command. Creates one view for your database. The code needs several changes to make it more efficient.

Below Expectations - Creates and executes the CREATE VIEW command. The code needs significant changes to compile and make it more efficient.

Non-Performance - The CREATE VIEW command and results are either nonexistent or lack the components described in the assignment instructions.


Normalization Analysis is Provided

Total: 2.40

Distinguished - Provides a comprehensive normalization analysis of your database.

Proficient - Provides a normalization analysis of your database. Minor details are missing.

Basic - Provides a limited normalization analysis of your database. Relevant details are missing.

Below Expectations - Attempts to provide a normalization analysis of your database; however, significant details are missing.

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


DBA Managerial Roles Required to Protect Data Security, Privacy, and Integrity as Well as Manage Impacts of Diversity in the Proposed Database are Identified

Total: 2.40

Distinguished - Provides a comprehensive description of the key DBA activities to protect data security, privacy, and manage impacts of diversity.

Proficient - Provides a description of the key DBA activities to protect data security, privacy, and manage impacts of diversity. Minor details are missing.

Basic - Provides a limited description of the key DBA activities to protect data security, privacy, and manage impacts of diversity. Relevant details are missing.

Below Expectations - Attempts to provide a description of the key DBA activities to protect data security, privacy, and manage impacts of diversity; however, significant details are missing.

Non-Performance - The key DBA activities to protect data security, privacy, and manage impacts of diversity are either nonexistent or lack the components described in the assignment instructions.


Justification for a Distributed or Centralized Database System is Provided

Total: 2.40

Distinguished - Provides comprehensive justification for the need of a centralized or distributed database.

Proficient - Provides justification for the need of a centralized or distributed database. Minor details are missing.

Basic - Provides limited justification for the need of a centralized or distributed database. Relevant details are missing.

Below Expectations - Attempts to provide justification for the need of a centralized or distributed database; however, significant details are missing.

Non-Performance - The justification for a distributed or centralized database system is either nonexistent or lacks the components described in the assignment instructions.


Written Communication: Control of Syntax and Mechanics

Total: 0.33

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: 0.33

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: 0.34

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: 3.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.