Reference no: EM133314956

EHR Database and Data Management

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 increased CHF readmission rate reduction. 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 information is sought, 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. Use a concept map similar to the "Database Concept Map" resource, to describe the relationships between each entity and its attributes.