WGU C792 Task 2: Entity Relationship Diagram (ERD) Reflection | 2025 Update with complete solutions.

1
Running head: DATA MODELING AND DATABASE MANAGEMENT SYSTEMS
1q 1q 1q 1q 1q 1q 1q




Data Modeling and Database Management Systems Caitlin
1q 1q 1q 1q 1q 1q




Galvin
1q




Western Governors University
1q 1q

, 2
DATA MODELING AND DATABASE MANAGEMENT SYSTEMS
1q 1q 1q 1q 1q




Data Modeling and Database Management Systems
1q 1q 1q 1q 1q




Flowchart Aspects 1q




Flowcharts are a useful tool to illustrate a visual representation of a certain process and to
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




help understand the existing process and find potential ways to improve it (Institution for
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




Healthcare Improvement, 2020). Healthcare organizations may benefit from the use of flowcharts
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




by offering a step-by-step analysis and identifying insufficiencies (Digital Healthcare Research,
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




2020). This particular flowchart outlines the workflow process for emergency severity index
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




(ESI) Level 3 patients. In the flowchart, the steps of the process are represented by different
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




shapes, each which symbolize a different action. The flowchart starts with an oval indicating the
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




beginning or end of the workflow. The rectangle symbolizes a process taking place, the diamond
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




indicates a decision is to be made, the bullet shape represents a delay in the process, and lastly,
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




the flowchart ends with another oval to represent the end of the workflow process.
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




The workflow begins upon a patient’s arrival to the emergency department (ED). The
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




process starts with 5 patients who are then registered by the receptionist into the healthcare
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




information system (HIS). This step takes about 21.4 minutes to complete. After the registration,
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




the patient must wait 32.6 minutes, which increases their time spent in the ED. The triage nurse
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




will then initiate the patient’s chart, taking another 24.8 minutes to complete. Next, the triage
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




nurse will escort the patient to the ED room and bed and will then give report to the ED nurse
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




who will then assume the patient’s care. This step takes 14.8 minutes to complete. The patient
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




then must wait another 43.2 minutes to be seen by the ED provider. The ED provider will then
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




conduct an examination of the patient that takes 17.8 minutes. Based on the examination
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q




findings, the ED provider will then give orders. The orders could be labs, CT, radiology, or for a
1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q 1q