NR542 Projects Latest 2022 September (Full)

NR542 Managing Data and Information

Week 3 Project  

Database Plan

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#1) Utilize critical inquiry and judgment to evaluate the design, development, implementation, and outcomes of data management strategies for nursing and healthcare data. (PO 5)

Please Note: The database project will be developed in Microsoft Excel or Access

Preparing the Paper

Criteria for Content:

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

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

Explanation of a conceptual data model for the planned database

All entities planned for the database are named.

A justification or rationale for each entity is provided.

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.

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.

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.

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.

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

Criteria for Paper Format and Special Instructions:

E-R diagrams will be in an appendix with your 3 questions on the document

Illustrations of entity relationships will be in an appendix

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

The database project will be developed in Microsoft Ecxel or Access

All aspects of the paper must be in APA format as expressed in the current edition

Only scholarly literature is used to support decisions

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

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

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

NR542 Managing Data and Information

Week 5 Project  

Relational Schema

Purpose

This paper is intended to facilitate the database project through identification of the relational schema underlying the planned database.

Course Outcomes

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

(CO#4) Synthesize contributions of the data-information-knowledge-wisdom model and database principles and practices to the support of evidence-based practice (PO 11)

Requirements

In a 2-to-3-page paper, explain the concept of relational tables and submit all of the relational tables for the database. Provide at least one data characteristic for each attribute. Explain how the tables relate to each other. Name the primary key for each table. Confirm any secondary keys and explain why they are used.

Preparing the Assignment

Please Note: The database project will be developed in Microsoft Excel or Access.  Your three questions should be included on the diagram.

Criteria for Content:

An introduction informs the reader about the topic of the paper and how the paper will be organized

The concept of relational tables is explained briefly

The complete Entity-Relationship diagram will be updated from the initial diagram included in your Week 3 assignment incorporating any changes that were necessary to address your three questions and from your relational table work in this Week 5 assignment.  Your three questions should be included on the diagram. The updated diagram will include the necessary entities, attributes including primary and secondary keys, and cardinality rules (i.e. properly drawn lines and symbols). If possible, please indicate which entities and/or attributes will utilize standard nomenclature.

Relational tables, each with a unique name, are presented in standard relational-table format

For each relational table, attributes are named, along with one data characteristic for each attribute. This content can be presented in narrative form, as individual tables, or in vertical lists

The primary key and any secondary keys for each table are identified. If secondary keys are used, a rationale is provided

The paper concludes with a recap of the content and insights gained from working on this assignment.

Criteria for Paper Format and Special Instructions:

All aspects of the paper are in APA format as expressed in the current edition, unless otherwise noted

Only scholarly literature is used to support decisions

The paper (excluding the title page, references, and appendix) is 2-3 pages in length

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

Grammar, spelling, punctuation, and APA formats are consistent with formal academic writing.

NR542 Managing Data and Information

Week 7 Project  

Final Report

Purpose

The purpose of this assignment is to present the results of the database project.

Course Outcomes

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

(CO#1) Utilize critical inquiry and judgment to evaluate the design, development, implementation, and outcomes of strategies for managing healthcare-related information (PO#4)

Assignment Overview

Submit a PowerPoint presentation of the database project (12-15 slides).

Use the database plan as a guide, updating as needed. All work done during this course, including discussion threads, assignment papers, appendices, and references, may be used to develop this report. Corrections and updates based on feedback are expected.

Provide the reason(s) for the database, including any supporting evidence. Describe the database developed for the course, showing or narrating the three models: conceptual, logical, and physical. Show the relational tables. Include 3 questions that guided database design. Report the results of testing the database and any revisions needed to the database as a result of testing. Conclude with a recap of the database project and insights gained from working on this project. The presentation and speaker notes must follow APA guidelines.

Assignment Instructions

Abide by the Chamberlain College of Nursing Academic Integrity Policy.

Upload a copy  of the (Excel/Access/Libre ) database that was developed for your project,  Please note if you do not attach the database that was developed for your project to the assignment, 20 points will be deducted.

Develop Power Point providing an overview of the project including:

Introduction establishes topic and organization of presentation

Reason for database is provided, including supporting evidence

Structure of the database developed for this project is described, including conceptual, logical, and physical models; can be presented as text, graphics, or a combination

Relational tables are presented in standard format, with primary keys identified, any secondary keys identified if used, attributes with one data characteristic for each attribute, and normalization issues identified and resolved

Three questions developed for database plan

Description of how database was tested

Results of testing, including any needed changes

Recap of entire project

Insights on information management developed from working on project

Speaker Notes are provided for each slide, except for title and references slides, and provide sufficient depth to allow someone else to take over the presentation.

Criteria for Format and Special Instructions

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

APA format is used correctly for citations and references

Create 12 - 15 slides, not counting title or references slides

Citations are not included in slides but are part of Speaker Notes