DATABASE INTEGRITY PLAN

DATABASE INTEGRITY PLAN

Data integrity is an area of significant concern to those who implement database solutions in virtually any setting. Organizations across all industries increasingly generate and use data to support the operations and decision-making necessary to be competitive. Therefore, data at the heart of all this activity must be valid. Yet, given the high stakes of data involving patient care, data integrity provides even more than a competitive advantage. Data integrity can be a matter of legal compliance or even a matter of life and death.

In this Assignment, you consider strategies for preventing unintended consequences related to data integrity. Specifically, you develop a plan to prevent medical record errors related to data quality and integrity in an emergency department. 

Review this scenario:

A patient named A. Watsoncox arrives alone in the emergency department with altered mental status and trauma due to a motor vehicle accident (MVA). She is registered in the emergency medical record (EMR) from a previous visit. A new encounter and record is started for A. Watsoncox.

According to the EMR, she has no allergies and is taking no medications daily.

Before being taken to surgery, she is given Rocephin, 1 gram. She has difficulty breathing and a severe rash after the medication infuses.

It is discovered after the patient is stabilized that an error was made during her last registration. Her name is A. Watson-Cox. There are two records for her in the EMR database.

RESOURCES

· Harrington, J. (2016).  Relational database design and implementation (4th ed.). Cambridge, MA: Morgan Kaufmann. 

· Chapter 25, “Data Quality” (pp. 509–521) 

ASSIGNMENT (3- TO 5-PAGE PAPER):

1) Develop a plan to prevent emergency medical record (EMR) errors related to data quality and integrity based on the scenario.

2) Your plan should contain an introduction that clearly identifies and explains data integrity and security issues relevant to the electronic medical records (EMR) in the scenario.

3) State your proposed plan, which should contain three strategies to ensure data integrity.

4) Explain your rationale for each strategy in the plan.

5) Include a brief summary that highlights how your plan can improve data handling and integrity.

6) Be specific and provide examples. Support your plan with your peer-reviewed research.

Reminder: The College of Nursing requires that all papers submitted include a title page, introduction, summary, and references. All papers submitted must use this formatting.

Written Expression and Formatting - The paper follows correct APA format for title page, headings, font, spacing, margins, indentations, page numbers, running heads, parenthetical/in-text citations, and reference list.