Week 4 | Database DesignThis is a Doctoral ProgramHealth InformaticsThe Tutor MUST have a good command of the English written languageDetails: As a DNP-prepared nurse, you may be called upon to assis

Week 4 | Database DesignThis is a Doctoral ProgramHealth InformaticsThe Tutor MUST have a good command of the English written languageDetails: As a DNP-prepared nurse, you may be called upon to assis
Week 4 | Database Design Details: 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: 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. You are required to submit this assignment to Turnitin. Refer to the directions in the Student Success Center. Directions: For this assignment, write a 1,000-1,250 word paper 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 (EHR). 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, 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. Apply Rubrics EHR Database and Data Management    1Unsatisfactory0.00% 2Less Than Satisfactory74.00% 3Satisfactory79.00% 4Good87.00% 5Excellent100.00% 70.0 %Content   10.0 %Selection of Clinically-Based Patient Problem Patient problem selection does not provide clear benefit potential by using a database management approach. Patient problem selection indicates some benefit potential by using a database management approach but the connection is marginal or incomplete. Patient problem selection indicates clear benefit potential by using a database management approach but the connection is perfunctory. Patient problem selection indicates clear benefit potential by using a database management approach. Discussion is convincing. Information presented is from scholarly though dated sources. 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. 10.0 %Identification of Data Needed to Manage This Patient Problem Using Information From the Electronic Health Record (EHR). Identification of data needed to manage this patient problem using information from the electronic health record (EHR) is not present. Identification of data needed to manage this patient problem using information from the electronic health record (EHR) is marginal or incomplete. Identification of data needed to manage this patient problem using information from the electronic health record (EHR) is present but at a perfunctory level. Identification of data needed to manage this 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. Identification of data needed to manage this 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. 15.0 %Patient Problem Description Incorporates Information Needed to Manage the Problem Patient problem description that incorporates information needed to manage the problem is not present. Patient problem description that incorporates information needed to manage the problem is marginal or incomplete. Patient problem description that incorporates information needed to manage the problem is present but at a perfunctory level. 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. 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. 10.0 %Identification of EHR-Supplied Data as Structured or Unstructured With Explanation Identification of EHR-supplied data as structured or unstructured with an explanation is not present. Identification of EHR-supplied data as structured or unstructured is present with or without an explanation but is marginal or incomplete. Identification of EHR-supplied data as structured or unstructured is present with an explanation but is rendered at a perfunctory level. Identification of EHR-supplied data as structured or unstructured is present with a thorough explanation. Information presented is from scholarly though dated sources. 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. 10.0 %Describes Structured and Unstructured Data From the EHR That Are Needed to Organize a Hypothetical Database Does not describe structured and unstructured data from the EHR that are needed to organize a hypothetical database. Describes structured and unstructured data from the EHR that are needed to organize a hypothetical database, but description is marginal or incomplete. Describes structured and unstructured data from the EHR that are needed to organize a hypothetical database, but description is rendered at a perfunctory level. Describes structured and unstructured data from the EHR that are needed to organize a hypothetical database in full. Discussion is convincing and defines specific elements. Information presented is from scholarly though dated sources. Describes structured and unstructured data from the EHR that are needed to organize a hypothetical database 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. 15.0 %Describes Data Relationships That Apply to the Hypothetical Database Does not describe data relationships that apply to the hypothetical database. Describes data relationships that apply to the hypothetical database, but description is marginal or incomplete. Describes data relationships that apply to the hypothetical database, but description is rendered at a perfunctory level. Describes data relationships that apply to the hypothetical database in full. Discussion is convincing and defines specific elements. Information presented is from scholarly though dated sources. Describes data relationships that apply to the hypothetical database in full. Discussion is convincing and defines specific elements. Discussion is insightful and forward-thinking. Information presented is from current scholarly sources. 20.0 %Organization and Effectiveness   7.0 %Thesis Development and Purpose Paper lacks any discernible overall purpose or organizing claim. Thesis is insufficiently developed or vague. Purpose is not clear. Thesis is apparent and appropriate to purpose. Thesis is clear and forecasts the development of the paper. Thesis is descriptive and reflective of the arguments and appropriate to the purpose Thesis is comprehensive and contains the essence of the paper. Thesis statement makes the purpose of the paper clear. 8.0 %Argument Logic and Construction Statement of purpose is not justified by the conclusion. The conclusion does not support the claim made. Argument is incoherent and uses noncredible sources. Sufficient justification of claims is lacking. Argument lacks consistent unity. There are obvious flaws in the logic. Some sources have questionable credibility. 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. Argument shows logical progressions. Techniques of argumentation are evident. There is a smooth progression of claims from introduction to conclusion. Most sources are authoritative. Clear and convincing argument that presents a persuasive claim in a distinctive and compelling manner. All sources are authoritative. 5.0 %Mechanics of Writing (includes spelling, punctuation, grammar, language use) Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice and/or sentence construction are used. 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. 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. 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. Writer is clearly in command of standard, written, academic English. 10.0 %Format   5.0 %Paper Format (Use of appropriate style for the major and assignment) Template is not used appropriately or documentation format is rarely followed correctly. Appropriate template is used, but some elements are missing or mistaken. A lack of control with formatting is apparent. Appropriate template is used. Formatting is correct, although some minor errors may be present. Appropriate template is fully used. There are virtually no errors in formatting style. All format elements are correct. 5.0 %Documentation of Sources (citations, footnotes, references, bibliography, etc., as appropriate to assignment and style) Sources are not documented. Documentation of sources is inconsistent or incorrect, as appropriate to assignment and style, with numerous formatting errors. Sources are documented, as appropriate to assignment and style, although some formatting errors may be present. Sources are documented, as appropriate to assignment and style, and format is mostly correct Sources are completely and correctly documented, as appropriate to assignment and style, and format is free of error. 100 %Total Weightage