Week 3 Assignment: Database Plan

Purpose

This Week 3 Assignment: Database Plan paper intends to develop a database development plan that must be submitted in Week 7 of this course. You will gain experience in addressing key elements of a database plan.

Course Outcomes

This activity enables you to meet the following course outcomes:

Utilize critical inquiry and judgment to evaluate the design, development, implementation, and outcomes of data management strategies for nursing and healthcare data. (PO 5)

Due Date

Sunday 11:59 p.m. MT at the end of Week 3

Total Points Possible

125 points

Assignment Overview

This paper presents a database plan for a nursing or healthcare problem. You will explain the problem and the reason(s) a database is needed. After explaining the problem and need for the database, address the following database plan elements:

Provide a conceptual data model for the planned database.
Name all the entities planned for the database and justify their selection.
Provide an E-R diagram that shows each entity, names the identifier for each entity, and illustrates the relationships between each entity, noting the cardinality.
Provide a narrative explanation of key parts of the E-R diagram, including how you arrived at some of the decisions on relationships and cardinality.
Include three questions planned for this database (the original questions from the discussion in Week 1 may be used).
Conclude with a recap of the paper and insights gained on databases developed from working on this assignment.
Support all decisions with scholarly literature.

Assignment Instructions

Use available software solutions to show entity relationship diagrams.
Abide by the Chamberlain College of Nursing Academic Integrity Policy.
Use scholarly sources no older than five years unless permission of the class professor was requested and granted.
Follow the grammar, spelling, word usage, punctuation, and sentence and paragraph structure rules to be consistent with formal, scholarly writing as noted in the APA Manual (current edition).
The paper length is 2-4 pages total.

Revision Process

If you do not receive at least a proficient rating in any content category, you can re-submit your assignment with a revision to that content category to improve the points earned within that specific section. Please note the following guidelines:

After receiving your assignment grade, you have one opportunity to resubmit.
In order to resubmit, your initial submission must have been a complete assignment. Rough drafts will not be graded or allowed for resubmission.
Only content sections that did not receive at least a proficient rating with the first submission may be revised to earn a better score in that content category. APA format and writing style will not be re-graded.
Points possible for revised and resubmitted work will not exceed the “proficient” rubric category (84%).
Any revision must be submitted for re-evaluation within 7 days after the assignment grade is posted. For example, if your assignment grade is posted on Friday at 12 noon MT, you have until Friday at 12 noon MT to resubmit any content area that did not earn a proficient rating.
Within 7 days of your resubmission, the class instructor will post your score for the resubmitted work.

Steps to follow for resubmission of a content section within an assignment that did not earn a proficient rating on the rubric:

Contact your class instructor privately via email, phone, or Canvas private message to inform them that you plan to resubmit a content section of the assignment that did not receive a proficient rating on the rubric.
Submit the assignment in its entirety (including the rewritten content section) within 7 days of the original assignment grade being posted.

Assignment Criteria

Assessment Criteria	Points	%	Description
Introduction	10	8%	The introduction includes information about the topic and the organization of the paper.
Problem	11	9%	The problem is described, and the reason for a database as an information-management solution is explained.
Conceptual model	12	9.6%	The conceptual data model for the planned database is described.
Entities	12	9.6%	All entities for the database are named.
Justification	12	9.6%	Justification for each entity is provided.
E-R diagram	12	9.6%	Each E-R diagram, provided separately for each entity or as a comprehensive diagram, is discussed briefly in the text and illustrated in an appendix.
Identifier	12	9.6%	Identifier for each entity is named.
Relationships	12	9.6%	Relationships between entities are discussed briefly in the text and illustrated, including cardinality, in an appendix.
Queries	12	9.6%	Three questions for the database are provided.
Conclusion	10	8%	The conclusion includes a recap of the paper and insights from completing the assignment.
Graduate-Level Writing Style	10	8%	There are no APA format, spelling, grammar, punctuation, or syntax errors, and 3 scholarly, timely references. The paper (excluding the title page, references, and appendices) is 2-4 pages long.
Total	125	100%	A quality assignment will meet or exceed the above requirements.

Grading Rubric

Assessment Criteria	Distinguished (100%)	Exceeds (92%)	Proficient (84%)	Needs Improvement (0%)
Introduction	10 Points	9 Points	8 Points	0 Points
Introduction	The introduction includes detailed information about the topic and explains the paper’s organisation.	The introduction includes most information about the topic and explains the paper’s organisation.	The introduction includes basic information about the topic and organization of the paper.	The introduction is not present.
Problem	11 Points	10 Points	9 Points	0 Points
Problem	All these criterion elements are met: · Problem is described in detail. · Reason for using a database as the information-management solution is explained in detail. · Scholarly support exceeds the minimum requirement of 3 references.	All these criterion elements are met: · Problem is stated but lacks detail. · Reason for the use of a database as the Information-management problem is stated but lacks detail in explanation. · Meets minimum requirement for scholarly support.	Two of the following criterion elements are met: · Problem is stated but lacks detail. · Reason for the use of a database as the Information-management problem is stated but lacks detail in explanation. · Meets minimum requirement for scholarly support	None of the criterion elements are met.
Conceptual Model	12 Points	11 Points	10 Points	0 Points
Conceptual Model	All these criterion elements are met: · Conceptual data model for the planned database is narrated. The model also may be illustrated (optional) and placed in an appendix. · Key elements include concept names, relationships, attributes, and business rules (if appropriate).	All these criterion elements are met: · Conceptual data model for the planned database is stated but lacks detail. · Key elements of the model are named. · The relationships are stated briefly.	Two of these criterion elements are present: · Conceptual data model for the planned database is explained. · Key elements of the model are named. · Relationships are narrated.	None of the criterion elements are met.
Entities	12 Points	11 Points	10 Points	0 Points
Entities	All entities are identified, and all match the number of concept names from the conceptual data model.	All but one entity is identified compared to the concept names from the concept model.	All but two entities are identified compared to the concept names from the concept model.	No entities are identified.
Justification	12 Points	11 Points	10 Points	0 Points
Justification	Justification for each entity is provided.	Justification is provided for all but one entity.	Justification is provided for all but two entities.	No justification is provided for the entities.
E-R Diagram	12 Points	11 Points	10 Points	0 Points
E-R Diagram	All these criterion elements are met: · E-R diagram presented separately for each entity or as a comprehensive diagram. · All identified entities are included. · Diagram is discussed briefly in the paper. · Diagram is placed in an appendix. · Appendix is named in the text of the paper.	All but 1 of these criterion elements are met: · E-R diagram presented separately for each entity or as a comprehensive diagram. · All identified entities are included. · Diagram is discussed briefly in the paper. · Diagram is placed in an appendix. · Appendix is named in the text of the paper.	All but 2 of these criterion elements are met: · E-R diagram presented separately for each entity or as a comprehensive diagram. · All identified entities are included. · Diagram is discussed briefly in the paper. · Diagram is placed in an appendix. · Appendix is named in the text of the paper.	None of these criterion elements is met: · E-R diagram presented separately for each entity or as a comprehensive diagram. · All identified entities are included. · Diagram is discussed briefly in the paper. · Diagram is placed in an appendix. · Appendix is named in the text of the paper
Identifiers	12 Points	11 Points	10 Points	0 Points
Identifiers	Identifier for each entity is named.	Identifiers for all but one entity are named.	Identifiers for all but two entities are named.	No identifiers are named.
Relationships	12 Points	11 Points	10 Points	0 Points
Relationships	Relationships between entities are discussed briefly in the text and illustrated, including cardinality, in an appendix.	Relationships between all but one of the entities are discussed briefly in the text and illustrated, including cardinality, in an appendix.	Relationships between all but two entities are discussed briefly in the text and illustrated, including cardinality, in an appendix.	No relationships are discussed in the text.
Queries	12 Points	11 Points	10 Points	0 Points
Queries	Three appropriate questions for the database are provided.	Three questions for the database are provided, but one or more questions are inappropriate.	Two appropriate questions for the database are provided.	No questions are submitted.
Conclusion	10 Points	9 Points	8 Points	0 Points
Conclusion	Conclusion thoroughly recaps the paper and discusses insights from completing the assignment.	The conclusion recaps the paper and states but does not discuss insights from completing the assignment.	The conclusion includes one but not both elements: Recap of paper Insights from completing the assignment.	The conclusion does not address the required elements or is missing.
Graduate-Level Writing Style	10 Points	9 Points	8 Points	0 Points
Graduate-Level Writing Style	The distinguished graduate-level writing style is evidenced by meeting all of the following criteria with 0-1 errors total: · Correct use of spelling, grammar, punctuation, sentence and paragraph structure · Clarity, organization, and logical flow of ideas within writing · Scholarly, professional writing tone · Synthesis of information is present with no more than one short, direct quote (15 words or less)	Graduate-level writing style exceeds expectations as evidenced by meeting the following criteria with 2-4 errors total: · Correct use of spelling, grammar, punctuation, sentence and paragraph structure · Clarity, organization, and logical flow of ideas within writing · Scholarly, professional writing tone · Synthesis of information is present with no more than one short, direct quote (15 words or less)	The proficient graduate-level writing style is evidenced by meeting the following criteria with 5-7 errors total: · Correct use of spelling, grammar, punctuation, sentence and paragraph structure · Clarity, organization, and logical flow of ideas within writing · Scholarly, professional writing tone · Synthesis of information is present with no more than one short, direct quote (15 words or less)	The graduate-level writing style needs improvement as evidenced by meeting the following criteria with 8 or more errors total: · Correct use of spelling, grammar, punctuation, sentence and paragraph structure · Clarity, organization, and logical flow of ideas within writing · Scholarly, professional writing tone · Synthesis of information is present with no more than one short, direct quote (15 words or less)