WGU module 3 SXM1 — SXM1 TASK 2: ENTITY RELATIONSHIP DIAGRAM
For this assessment, you will construct an ERD for a database management system (DBMS) using Microsoft Visio or an equivalent drawing tool. Your ERD will contain one parent table, one child table, and three lookup tables. After you have constructed your ERD, you will reflect on your experience in a written paper.
You are a nurse informatics specialist at a regional health center in the Midwest where the emergency department (ED) has recently experienced an increased number of asthma-related symptom complaints from school-age children. An ED pediatric nurse practitioner 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 providers, community pediatricians, nurses, and health educators were called to brainstorm ideas.
The team is currently developing an asthma intervention program for children with asthma. To measure the effectiveness of their work, the team decided to collect and analyze data to establish a baseline before implementing the new asthma intervention pr