Southern New Hampshire University
IT 204 Milestone Three Guidelines and Rubric
In this task, you will complete and submit an individual proposal for a relational database that addresses the business case of Birchwood Lane Schools. In your proposal, you should include the second and third critical elements of your final project: a business case and gap analysis, and a relational database model. Use your emerging knowledge from course materials and discussions with classmates to inform your proposal. This milestone will be graded with the Milestone Three Rubric, which is found below.
Specifically, the following critical elements must be addressed in your submission:
II.
Business Case and Gap Analysis: Analyze the client needs and how the project will address them. This type of analysis identifies the difference between a current condition and future state (i.e., gap analysis). Based on the scenario showing the current system that the school has in place to collect data: A. What information should be included in the new database solution to address the current state? Why? B. What additional information is needed to complete the business case data requirements and achieve the desired future state? Relational Database Model: Based on the scenario and the information from your introduction and your analysis: A. Design a basic relational database visual diagram with entities, attributes, and relationships based on the requirements you have identified. Be sure to include proper relationship mapping. B. Create a conceptual data model visual diagram and a logical data model visual diagram based on the entities present in your visual conceptual database.
II.
Rubric
Guidelines for Submission: The proposal should follow these formatting guidelines: double spacing, 12-point Time New Roman font, one-inch margins, and APA citations. The proposal should be 2 to 3 pages in length.
Critical Elements Business Case and Gap Analysis: Information
Exemplary (100%)
Proficient (85%) Needs Improvement (55%) Not Evident (0%) Meets "Proficient" criteria, and Identifies what information Identifies what information Does not identify what explanation demonstrates keen should be included in the new should be included to address information should be included insight on the information database solution to address the the current state, but reasoning to address the current state in needed for the proposed current state and explains contains inaccuracies or is the new database solution database solution reasoning illogical Meets "Proficient"criteria, and Describes additional information Describes additional information Does not describe additional the description demonstrates needed to complete the needed to complete the information needed to complete keen insight into how the business case data requirements business case data requirements the business case data information from the scenario and achieve the desired future but lacks key details or contains requirements should be used state inaccuracies in achieving the desired future state
Value 20
Business Case and Gap Analysis: Additional Information
20
Southern New Hampshire University
Relational Database Meets "Proficient" criteria, and Basic relational database visual Model: Basic Diagram the relational database visual diagram clearly illustrates all diagram is simply and intuitively applicable entities, attributes, organized and relati