WGU C792 Task 2: Entity Relationship Diagram (ERD) Beverly Ballard, SXM2 ERD Reflection Final | 2026 Update with complete solutions.

1

WGU C792 Task 2: Entity Relationship Diagram (ERD)
k k k k k k k




Beverly Ballard, SXM2 ERD Reflection Final | 2026 Update with
k k k k k k k k k




complete solutions. k k




Entity Relationship Diagram (ERD) Reflection
k k k k




College of Health Professions, Western Governors University C792
k k k k k k k




kTask 2: Entity Relationship Diagram (ERD)
k k k k k




Beverly Ballard k




kJuly 27, 2025 k k

, 2


Entity Relationship Diagram (ERD) Reflection k k k k




k See Figure 1 for screenshot of ERD diagram
k k k k k k k




k Evolution of Thought k k




I have had the opportunity to design, test, train, and implement an EHR in my current work
k k k k k k k k k k k k k k k k




kenvironment. I did not have the training provided during my WGU coursework to assist me in
k k k k k k k k k k k k k k k




kcreating systems that are well-designed from the start, and, as such, multiple failures were required
k k k k k k k k k k k k k k




kto get to the end outcome. The lack of background resulted in confusion among the staff and
k k k k k k k k k k k k k k k k




kadditional training that leadership could have avoided. The task of creating the ERD assisted in my
k k k k k k k k k k k k k k k




kunderstanding of relationships between data and creating inputs that reduce either errors in the
k k k k k k k k k k k k k




kcoding process/or documentation lacking clarity, resulting in possible patient harm. For example,
k k k k k k k k k k k




kin this ERD, several survey questions ask how often symptoms are present, but each participant
k k k k k k k k k k k k k k




kcan only choose one option from the "HowOftenID". If multiple inputs were available, it would
k k k k k k k k k k k k k k




kcreate confusion for both the parent inputting the data and poor results for the provider to review,
k k k k k k k k k k k k k k k k




kas it would lead to a non-specific frequency of the symptoms, leading to possible misdiagnosis
k k k k k k k k k k k k k k




kand/or treatment. Learning about the use of crow's foot notation helped me visualize and explain
k k k k k k k k k k k k k k




kthe relationships between tables clearly.
k k k k




Survey Interoperability k




Interoperability plays a vital role in supporting the sharing of health assessment information. In my
k k k k k k k k k k k k k k




kfield, we use two assessment tools daily, the PHQ-9 and Columbia Suicide Rating Scale.
k k k k k k k k k k k k k




Both are evidence-based practices and contain the same assessment questions among behavioral
k k k k k k k k k k k




khealth organizations. Establishing assessment interoperability allows different health information
k k k k k k k k




ksystems to access, exchange, and use the data effectively. If interoperability were not present, two
k k k k k k k k k k k k k k




ksystems, which may not share the same operating software, could not securely exchange
k k k k k k k k k k k k




kinformation. When a patient is seen by a provider running off a different electronic health record
k k k k k k k k k k k k k k k