ENTITIES RELATIONSHIP DIAGRAM

SCENARIO You are a nurse informatics specialist at a regional health center in the Midwest where the emergency department (ED) has recently experienced an alarming number of asthma-related symptom complaints from school-age children. The ED doctors noted a pattern in these complaints that indicated asthma symptoms were not being well managed. To address this community-wide issue, an interprofessional team of ED doctors, pediatricians, nurses, and health educators was called to brainstorm ideas. The team is currently developing a symptom management intervention program for parents of children with asthma. However, in order to measure the effectiveness of their work, the team decided to collect and analyze data before they put their program in place. Later they plan to compare this initial data to additional data they will collect after implementing their program. To collect their initial data, the team created a paper-based data-collection form and distributed it to all parents of children attending schools in the county. The form was designed to capture information on personal identifying factors, demographics, relevant medical history, and asthma symptoms. The team received more than 500 responses and quickly realized they did not have the knowledge, skills, or abilities to manage the data for this project. The team then came to you for help with designing a system to collect, manage, and analyze survey data. They handed you the data-collection survey form and indicated that they need the database management system as soon as possible. You reviewed the form and created the attached “Code Sheet for ERD” with all the data elements on the form. You then began the process of clustering the data elements into tables. You determined that there will be one parent table that will contain personal identifying information and demographics. You have also determined that there will be one child table that will contain repeated surveys—pre- and post-intervention. In addition, you noted that the system will need three lookup tables for drop-down boxes. By creating the correct relationship between the parent and child tables, it will be possible to conduct statistical analyses that will determine the effectiveness of the educational program by comparing pre-intervention survey responses to post-intervention responses. After clustering data elements, and determining relationships, it is time to create a logical data model of the database. To create the data model, you will use Visio ,Word, or Excel to generate an ERD. You will present this model to the team to make sure the system will include all the information needed and that the system will function efficiently. You will then begin the process of building an Access DBMS using the information in Unit 4 of your course. REQUIREMENTS A. Create a logical ERD using appropriate entities and data elements by doing the following: 1. Create one parent table that incorporates the following points: • correct labels • an established primary key • data elements, related to the entity, entered in the attribute cells 2. Create one child table that incorporates the following points: • correct labels • correctly identified primary and foreign keys • data elements, related to the entity, entered in the attribute cells 3. Create three lookup tables that each incorporate the following points: • correct labels • correctly identified primary keys • data elements, related to the entity, entered in the attribute cells 4. Indicate appropriate relationships with ordinality and cardinality between entities using crow’s foot notations. B. In a Word document, provide a written reflection (suggested length of 4–5 pages) of your experiences modeling and building a DBMS by doing the following: 1. Discuss your successes and challenges in completing the design and development of a DBMS for this assessment. 2. Explain how your thinking regarding data modeling and database management systems evolved over time while working on this assessment. 3. Explain how the knowledge and skills you have acquired during this course inform the roles and responsibilities of a nurse informaticist in a work setting. 4. Embed a screen shot of your ERD. 5. Embed a screen shot of the Mircosoft Access form you created in your DBMS. C. Acknowledge sources, using APA-formatted in-text citations and references, for content that is quoted, paraphrased, or summarized. D. Demonstrate professional communication in the content and presentation of your submission.