NR542 week 3 Project Database Plan

Project: Database Plan

Guidelines with Scoring Rubric

Purpose

This paper is intended to produce a plan for developing the database that must be submitted in Week 7 of this course. Students will gain experience in addressing key elements of a database plan.

Course Outcomes

Through this assignment, the student will demonstrate the ability to:

(CO#5) Utilize contemporary communication modalities to explain the sources, requirements, attributes, and implications of data representations found in healthcare. (PO 3)

Due Date: Sunday 11:59 p.m. (MT) at the end of Week 3

Total Points Possible: 125

Requirements:

This 2-to-4 page paper presents a database plan for a nursing or healthcare problem dealt with in the past or active in the present. Explain the problem and the reason(s) a database is needed. Provide a conceptual data model for the planned database. Name all the entities planned for the database and justify their selection. In an appendix, 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. In the paper, write 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). Provide a recap of the paper and discuss insights on databases developed as a result of working on this assignment. Support all decisions from the scholarly literature.

Preparing the paper

Criteria for Content:

1. An introduction informs about the topic of the paper and how it is organized.

2. Explanation of the selected problem and why it needs a database as an information-management solution

3. Explanation of a conceptual data model for the planned database

4. All entities planned for the database are named.

5. A justification or rationale for each entity is provided.

6. The E-R diagram for each entity is discussed briefly in the text and is found in an appendix. The E-R diagrams can be created for individual entities mapped to all other relevant entities or a single E-R diagram showing all entities and their relationships may be provided.

7. The identifier for each entity is named. The identifier can be narrated in the paper or included with the E-R diagram in the appendix.

8. The relationships between entities are discussed briefly in text and illustrated, including cardinality, in the E-R diagram in the appendix or in a separate appendix.

9. Three questions planned for the database are provided. The original questions presented in week 1 discussion may be used, or revised questions may be presented.

10. A conclusion that recaps the paper and discusses insights gained from working on this assignment is presented.

Criteria for Paper Format and Special Instructions:

1. E-R diagrams will be in an appendix

2. Illustrations of entity relationships will be in an appendix

3. Drawings can be done manually, with Microsoft Office tools, or with third-party software

4. All aspects of the paper must be in APA format as expressed in the 6th edition

5. Only scholarly literature is used to support decisions

6. The paper (excluding the title page, references, and appendices) must be 2-4 pages.

7. A minimum of 3 references are required. One of the course texts may be used as a reference.

8. Grammar, spelling, punctuation, citations, and references are consistent with formal academic writing.

Category

Points

%

Description

Introduction

10

0.08%

Introduction includes information about the topic and the organization of the paper

Problem

11

0.09%

Problem is described, and reason for a database as an information-management solution is explained

Conceptual model

12

0.96%

Conceptual data model for the planned database is narrated

Entities

12

0.96%

All entities for the database are named

Justification

12

0.96%

Justification for each entity is provided

E-R diagram

12

0.96%

Each E-R diagram, provided separately for each entity or as a comprehensive diagram, is discussed briefly in text and found in an appendix

Identifier

12

0.96%

Identifier for each entity is named

Relationships

12

0.96%

Relationships between entities are discussed briefly in text and illustrated, including cardinality, in an appendix

Queries

12

0.96%

Three questions for the database are provided

Conclusion

10

0.08%

Conclusion includes a recap of the paper and insights from completing the assignment

APA format

References

Writing Mechanics

10

0.08%

No APA-format, spelling, grammar, punctuation, and syntax errors and 3 scholarly, timely references are present.

Total

125

A quality assignment will meet or exceed all of the above requirements.