DNP 805 Assignment EHR Database and Data Management
EHR Database and Data Management
Medical databases offer a suitable framework for collecting, analyzing, and monitoring vital health information such as tests, expenditures, invoicing and transactions, patient information, and so on. These records must be kept private from the general public while still being widely available to health care providers who rely on them to save lives (Pastorino et al., 2019). The goal of this study is to explain how a database can be used to detect chronic obstructive pulmonary disease (COPD) early.
Clinically Based Patient Problem
COPD is a prevalent chronic condition that causes acute respiratory cough, shortness of breath, coughing, and sputum secretion. Long-term exposure to hazardous substances and pollutants is frequently the cause of COPD (Agarwal et al., 2022). Approximately 85 percent of COPD patients are smokers (Asamoah-Boaheng et al., 2022). Smoking is the leading cause of lung damage and asthma. Inhaling smoke from fuel burning can also cause COPD (Choi & Rhee, 2020). If the proof is in the person’s personal files, the caretaker may ignore it. Nonsmokers are usually diagnosed with COPD as the condition worsens (Choi & Rhee, 2020). Exacerbation is defined by deteriorating health issues such as increased dyspnea, frequent sneezing, and a change in sputum color (Holmes & Murdoch, 2017). Exacerbations increase healthcare expenses, and certain medications used in therapy, such as corticosteroids, have long-term negative consequences (Asamoah-Boaheng et al., 2022). COPD can also be caused by genetic anomalies, such as severe hereditary impairment of alpha-1 antitrypsin (AATD) (Asamoah-Boaheng et al., 2022), which can go undetected in massive amounts of data.
People have acute emphysema or bronchiolitis, the severity of which varies. People who have difficulty breathing, sputum production, or a persistent cough should be evaluated for COPD (Agarwal et al., 2022). Other diagnoses for COPD include anaemia, lung cancer, persistent asthma, and so on. COPD is frequently associated with co-occurring chronic diseases like diabetes and obesity, both of which cause COPD-related symptoms like coughing and shortness of breath (Choi & Rhee, 2020). This delays the diagnosis of COPD. High-quality spirometry is the best technique for diagnosing COPD in a person. Spirometry is recommended when COPD is diagnosed, and it may be performed if the illness has advanced in a nonsmoker with concurrent diseases. The slow progression of
Early diagnosis is critical for selecting the best treatment plan based on the individual’s severity and phenotype. Early detection has been shown to improve treatment outcomes by reducing the incidence and frequency of flare-ups, lowering treatment costs, and avoiding long-term adverse effects associated with pharmaceutical treatment (Asamoah-Boaheng et al., 2022). In addition, hospitals avoid wasting money due to ineffective therapy (Choi & Rhee, 2020).
Also Read:
Assessment Description
As a DNP-prepared nurse, you may be called upon to assist in the design of a clinical 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:
- This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
- Doctoral learners are required to use APA style for their writing assignments. The APA Style Guide is located in the Student Success Center.
- Use primary sources published within the last 5 years. Provide citations and references for all sources used.
- Refer to the examples in the topic resources for health care database examples.
- You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.
- Learners will submit this assignment using the assignment dropbox in the learning management system. In addition, learners must upload this deliverable to the Learner Dissertation Page (LDP) in the DNP PI Workspace for later use.
Directions:
For this assignment, write a 1,000-1,250 word in which you:
- Select a clinically based patient problem in which using a database management approach provides clear benefit potential.
- 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 ().
- 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.
- 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?
- Provide a complete description of data entities (the objects for which you seek information, e.g., patients) and their relationships to the attributes collected for each entity (data collected for each entity, e.g., gender, birthdate, first name, last name) 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.
Attachments
EHR Database and Data Management – Rubric
Important information for writing discussion questions and participation
Welcome to class
Hello class and welcome to the class and I will be your instructor for this course. This is a -week course and requires a lot of time commitment, organization, and a high level of dedication. Please use the class syllabus to guide you through all the assignments required for the course. I have also attached the classroom policies to this announcement to know your expectations for this course. Please review this document carefully and ask me any questions if you do. You could email me at any time or send me a message via the “message” icon in halo if you need to contact me. I check my email regularly, so you should get a response within 24 hours. If you have not heard from me within 24 hours and need to contact me urgently, please send a follow up text to
I strongly encourage that you do not wait until the very last minute to complete your assignments. Your assignments in weeks 4 and 5 require early planning as you would need to present a teaching plan and interview a community health provider. I advise you look at the requirements for these assignments at the beginning of the course and plan accordingly. I have posted the YouTube link that explains all the class assignments in detail. It is required that you watch this 32-minute video as the assignments from week 3 through 5 require that you follow the instructions to the letter to succeed. Failure to complete these assignments according to instructions might lead to a zero. After watching the video, please schedule a one-on-one with me to discuss your topic for your project by the second week of class. Use this link to schedule a 15-minute session. Please, call me at the time of your appointment on my number. Please note that I will NOT call you.
Please, be advised I do NOT accept any assignments by email. If you are having technical issues with uploading an assignment, contact the technical department and inform me of the issue. If you have any issues that would prevent you from getting your assignments to me by the deadline, please inform me to request a possible extension. Note that working fulltime or overtime is no excuse for late assignments. There is a 5%-point deduction for every day your assignment is late. This only applies to approved extensions. Late assignments will not be accepted.
If you think you would be needing accommodations due to any reasons, please contact the appropriate department to request accommodations.
Plagiarism is highly prohibited. Please ensure you are citing your sources correctly using APA 7th edition. All assignments including discussion posts should be formatted in APA with the appropriate spacing, font, margin, and indents. Any papers not well formatted would be returned back to you, hence, I advise you review APA formatting style. I have attached a sample paper in APA format and will also post sample discussion responses in subsequent announcements.
Your initial discussion post should be a minimum of 200 words and response posts should be a minimum of 150 words. Be advised that I grade based on quality and not necessarily the number of words you post. A minimum of TWO references should be used for your initial post. For your response post, you do not need references as personal experiences would count as response posts. If you however cite anything from the literature for your response post, it is required that you cite your reference. You should include a minimum of THREE references for papers in this course. Please note that references should be no more than 5 years old except recommended as a resource for the class. Furthermore, for each discussion board question, you need ONE initial substantive response and TWO substantive responses to either your classmates or your instructor for a total of THREE responses. There are TWO discussion questions each week, hence, you need a total minimum of SIX discussion posts for each week. I usually post a discussion question each week. You could also respond to these as it would count towards your required SIX discussion posts for the week.
I understand this is a lot of information to cover in 5 weeks, however, the Bible says in Philippians 4:13 that we can do all things through Christ that strengthens us. Even in times like this, we are encouraged by God’s word that we have that ability in us to succeed with His strength. I pray that each and every one of you receives strength for this course and life generally as we navigate through this pandemic that is shaking our world today. Relax and enjoy the course!
Hi Class,
Please read through the following information on writing a Discussion question response and participation posts.
Contact me if you have any questions.
Important information on Writing a Discussion Question
- Your response needs to be a minimum of 150 words (not including your list of references)
- There needs to be at least TWO references with ONE being a peer reviewed professional journal article.
- Include in-text citations in your response
- Do not include quotes—instead summarize and paraphrase the information
- Follow APA-7th edition
- Points will be deducted if the above is not followed
Participation –replies to your classmates or instructor
- A minimum of 6 responses per week, on at least 3 days of the week.
- Each response needs at least ONE reference with citations—best if it is a peer reviewed journal article
- Each response needs to be at least 75 words in length (does not include your list of references)
- Responses need to be substantive by bringing information to the discussion or further enhance the discussion. Responses of “I agree” or “great post” does not count for the word count.
- Follow APA 7th edition
- Points will be deducted if the above is not followed
- Remember to use and follow APA-7th edition for all weekly assignments, discussion questions, and participation points.
- Here are some helpful links
- The is a great resource
Rubric Criteria
Criterion |
1. Unsatisfactory |
2. Less Than Satisfactory |
3. Satisfactory |
4. Good |
5. Excellent |
---|---|---|---|---|---|
Mechanics of Writing (includes spelling, punctuation, grammar, language use) Mechanics of Writing (includes spelling, punctuation, grammar, language use) |
0 points Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice or sentence construction is used. |
4 points Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register) or word choice are present. Sentence structure is correct but not varied. |
4.4 points Some mechanical errors or typos are present, but they are not overly distracting to the reader. Correct and varied sentence structure and audience-appropriate language are employed. |
4.6 points Prose is largely free of mechanical errors, although a few may be present. The writer uses a variety of effective sentence structures and figures of speech. |
5 points Writer is clearly in command of standard, written, academic English. |
Patient Problem Description Incorporates Information Needed to Manage the Problem Patient Problem Description Incorporates Information Needed to Manage the Problem |
0 points Patient problem description that incorporates information needed to manage the problem is not present. |
12 points Patient problem description that incorporates information needed to manage the problem is marginal or incomplete. |
13.2 points Patient problem description that incorporates information needed to manage the problem is present but at a perfunctory level. |
13.8 points Patient problem description that incorporates information needed to manage the problem is present in full. Discussion is convincing and defines specific elements. Information presented is from scholarly though dated sources. |
15 points Patient problem description that incorporates information needed to manage the problem is present in full. Discussion is convincing and defines specific elements. Discussion is insightful and forward-thinking. Information presented is from current scholarly sources. |
Documentation of Sources Documentation of Sources (citations, footnotes, references, bibliography, etc., as appropriate to assignment and style) |
0 points Sources are not documented. |
4 points Documentation of sources is inconsistent or incorrect, as appropriate to assignment and style, with numerous formatting errors. |
4.4 points Sources are documented, as appropriate to assignment and style, although some formatting errors may be present. |
4.6 points Sources are documented, as appropriate to assignment and style, and format is mostly correct. |
5 points Sources are completely and correctly documented, as appropriate to assignment and style, and format is free of error. |
Thesis Development and Purpose Thesis Development and Purpose |
0 points Paper lacks any discernible overall purpose or organizing claim. |
5.6 points Thesis is insufficiently developed or vague. Purpose is not clear. |
6.16 points Thesis is apparent and appropriate to purpose. |
6.44 points Thesis is clear and forecasts the development of the paper. Thesis is descriptive and reflective of the arguments and appropriate to the purpose. |
7 points Thesis is comprehensive and contains the essence of the paper. Thesis statement makes the purpose of the paper clear. |
Identification of EHR-Supplied Data as Structured or Unstructured With Explanation Identification of EHR-Supplied Data as Structured or Unstructured With Explanation |
0 points Identification of EHR-supplied data as structured or unstructured with an explanation is not present. |
8 points Identification of EHR-supplied data as structured or unstructured is present with or without an explanation but is marginal or incomplete. |
8.8 points Identification of EHR-supplied data as structured or unstructured is present with an explanation but is rendered at a perfunctory level. |
9.2 points Identification of EHR-supplied data as structured or unstructured is present with a thorough explanation. Information presented is from scholarly though dated sources. |
10 points Identification of EHR-supplied data as structured or unstructured is present with a thorough explanation. Discussion is insightful and forward-thinking. Information presented is from current scholarly sources. |
Argument Logic and Construction Argument Logic and Construction |
0 points Statement of purpose is not justified by the conclusion. The conclusion does not support the claim made. Argument is incoherent and uses noncredible sources. |
6.4 points Sufficient justification of claims is lacking. Argument lacks consistent unity. There are obvious flaws in the logic. Some sources have questionable credibility. |
7.04 points Argument is orderly, but may have a few inconsistencies. The argument presents minimal justification of claims. Argument logically, but not thoroughly, supports the purpose. Sources used are credible. Introduction and conclusion bracket the thesis. |
7.36 points Argument shows logical progressions. Techniques of argumentation are evident. There is a smooth progression of claims from introduction to conclusion. Most sources are authoritative. |
8 points Clear and convincing argument that presents a persuasive claim in a distinctive and compelling manner. All sources are authoritative. |
Paper Format (Use of appropriate style for the major and assignment) Paper Format (Use of appropriate style for the major and assignment) |
0 points Template is not used appropriately or documentation format is rarely followed correctly. |
4 points Template is used, but some elements are missing or mistaken; lack of control with formatting is apparent. |
4.4 points Template is used, and formatting is correct, although some minor errors may be present. |
4.6 points Template is fully used; There are virtually no errors in formatting style. |
5 points All format elements are correct. |
Data Relationships That Apply to the Hypothetical Database Data Relationships That Apply to the Hypothetical Database |
0 points Data relationships that apply to the hypothetical database are not described. |
12 points Data relationships that apply to the hypothetical database are described, but description is marginal or incomplete. |
13.2 points Data relationships that apply to the hypothetical database are described, but description is rendered at a perfunctory level. |
13.8 points Data relationships that apply to the hypothetical database are not described in full. Discussion is convincing and defines specific elements. Information presented is from scholarly though dated sources. |
15 points Data relationships that apply to the hypothetical database are not described in full. Discussion is convincing and defines specific elements. Discussion is insightful and forward-thinking. Information presented is from current scholarly sources. |
Structured and Unstructured Data From the EHR That Are Needed to Organize a Hypothetical Database Structured and Unstructured Data From the EHR That Are Needed to Organize a Hypothetical Database |
0 points Structured and unstructured data from the EHR needed to organize a hypothetical database are not described. |
8 points Structured and unstructured data from the EHR needed to organize a hypothetical database are described, but description is marginal or incomplete. |
8.8 points Structured and unstructured data from the EHR needed to organize a hypothetical database are described, but description is rendered at a perfunctory level. |
9.2 points Structured and unstructured data from the EHR needed to organize a hypothetical database are described in full. Discussion is convincing and defines specific elements. Information presented is from scholarly though dated sources. |
10 points Structured and unstructured data from the EHR needed to organize a hypothetical database are described in full. A discussion of the rationale behind the design development is convincing and defines specific elements. Discussion is insightful and forward-thinking. Information presented is from current scholarly sources. |
Identification of Data Needed to Manage the Patient Problem Using Information From the Electronic He Identification of Data Needed to Manage the Patient Problem Using Information From the Electronic Health Record (EHR) |
0 points Identification of data needed to manage the patient problem using information from the electronic health record (EHR) is not present. |
8 points Identification of data needed to manage the patient problem using information from the electronic health record (EHR) is marginal or incomplete. |
8.8 points Identification of data needed to manage the patient problem using information from the electronic health record (EHR) is present but at a perfunctory level. |
9.2 points Identification of data needed to manage the patient problem using information from the electronic health record (EHR) is present in full. Discussion is convincing and defines specific elements. Information presented is from scholarly though dated sources. |
10 points Identification of data needed to manage the patient problem using information from the electronic health record (EHR) is present in full. Discussion is convincing and defines specific elements. Discussion is insightful and forward-thinking. Information presented is from current scholarly sources. |
Selection of Clinically-Based Patient Problem Selection of Clinically-Based Patient Problem |
0 points Patient problem selection does not provide clear benefit potential by using a database management approach. |
8 points Patient problem selection indicates some benefit potential by using a database management approach, but the connection is marginal or incomplete. |
8.8 points Patient problem selection indicates clear benefit potential by using a database management approach, but the connection is perfunctory. |
9.2 points Patient problem selection indicates clear benefit potential by using a database management approach. Discussion is convincing. Information presented is from scholarly though dated sources. |
10 points Patient problem selection indicates clear benefit potential by using a database management approach. Discussion is insightful and forward-thinking. Information presented is from current scholarly sources. |