IT 650 Prinicples of Database Design

IT 650 Milestone Four Rubric Submit a detailed data model of the database with analysis and justification based on a specific group or department within the organization. Select one particular group or department (such as Sales or Human Resources) within the organization in your chosen scenario from the Final Project Case Study Scenarios doccument. Then develop and illustrate a comprehensive enterprise data model for the selected group. Articulate the operating rules within the group to allow for an application model. Assess the extent to which your data model reflects the operating rules of the organization. Specifically, the following critical elements must be addressed:

 Data Model: For the three sections of this element, you will focus on a particular group or department within the organization (such as Sales or Human Resources).

A. Enterprise Data Model: Develop and illustrate a comprehensive enterprise data model for the selected group. B. Operating Rules: Articulate the operating rules within the group to allow for an applicable model. C. Rule Reflection: Assess the extent to which your data model reflects the operating rules of the organization.

Guidelines for Submission: Your paper must be submitted as a four- to six-page Microsoft Word document using appropriate modeling language and/or diagrams. It should use double spacing, 12-point Times New Roman font, and one-inch margins. It should include at least three sources, which should be cited in APA format.

Critical Elements Exemplary Proficient Needs Improvement Not Evident Value

Data Model: Enterprise Data Model

Meets “Proficient” criteria and evidences keen ability to narrow the enterprise/organizational perspective to the needs of key operational groups to ensure needs are met (100%)

Develops and illustrates a comprehensive enterprise data model that meets the general operational and technological needs of the selected group (90%)

Develops and illustrates an enterprise data model that would not meet the general operational and technological needs of the selected group, or lacks necessary detail (70%)

Does not develop and illustrate an enterprise data model for the selected group (0%)

30

Data Model: Operating Rules

Articulates the operating rules within the group to establish basis for the model (100%)

Articulates operating rules within the group but lacks detail, full representation, or clarity needed to establish basis for the model (70%)

Does not articulate operating rules within the group (0%)

30

Data Model: Rule Reflection

Meets “Proficient” criteria and evidences keen insight into complexities, intricacies, and nuances of departmental operating rule applications (100%)

Accurately assesses the extent to which the data model reflects the operating rules of the organization (90%)

Assesses the extent to which the data model reflects the operating rules of the organization with gaps in accuracy or detail (70%)

Does not assess the extent to which the data model reflects the operating rules of the organization (0%)

30

Articulation of Response

Submission is free of errors related to citations, grammar, spelling, syntax, and organization and is presented in a professional and easy to read format (100%)

Submission has no major errors related to citations, grammar, spelling, syntax, or organization (90%)

Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas (70%)

Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas (0%)

10

Total 100%