Task 4-1

As a DNP-prepared nurse, you may be called upon to assist in the design of a clinical database for your organization. This assignment requires you to integrate a clinical problem with data technologies to better understand the components as well as how those components can lead to better clinical outcomes.
General Guidelines:
Use the following information to ensure successful completion of the assignment:

• Doctoral      learners are required to use APA style for their writing assignments.
• Use      primary sources published within the last 5 years. Provide citations and      references for all sources used.

Directions:
For this assignment, write a 1,000-1,250 word paper in which you:

1. Select      a clinically based patient problem in which using a database management      approach provides clear benefit potential.
2. Consider      how a hypothetical database could be created to assist with this      clinically based patient problem. Identify and describe the data needed to      manage this patient problem using information from the electronic health      record (EHR).
3. Include      a brief description of the patient problem that incorporates information      needed to manage the specific problem. Describe what information is      required for the patient to manage the condition and how the database and      health care provider can be incorporated into the approach for better      health outcomes.
4. Describe      each entity (data or attribute) that will be pulled from the EHR as either      structured or unstructured and provide an operational definition for each.      Structured data is more easily searchable and specifically defined. For      example, structured data can be placed in a drop-down menu like hair      color: brown, black, grey, salt and pepper, blonde, platinum, etc.      Unstructured data is data that would be included in a nurse’s notes. An      operational definition is how a researcher or informatics specialist      decides to measure a variable. For example, when the nurses enter height      into the EHR, do they enter height as measured in inches or centimeters or      in feet and inches?
5. Provide      a complete description of data entities (the objects for which you seek      information, i.e., patients) and their relationships to the attributes      collected for each entity (data collected for each entity, i.e., gender,      birthdate, first name, last name, etc.) that apply to the hypothetical      database. You can use a concept map similar to the “Database Concept Map”      resource, to help you describe the relationships between each entity and      its attributes.