Wgu C792 Task 2: Data Modeling And Database Management Systems| 2025 Update With Complete Solutions

1
Runninghead:DATAMODELINGANDDATABASEMANAGEMENTSYSTEMS
i i i i ii i i




DataModelingandDatabaseManagementSystems Caitlin
i i i i i ii




Galvin
ii




WesternGovernorsUniversity
i i

, 2
DATAMODELINGAND DATABASE MANAGEMENT SYSTEMS
i i ii ii ii




DataModelingand DatabaseManagement Systems i i ii i ii




Flowchart Aspects ii




Flowchartsareausefultoolto illustrateavisualrepresentationofacertainprocessandto help ii i i ii i ii i ii i i i ii ii ii ii ii




ii understand the existing process and find potential ways to improve it (Institution for Healthcare
ii ii ii ii ii ii ii ii ii ii ii ii ii




ii Improvement, 2020). Healthcare organizations may benefit from the use of flowcharts by offering a ii ii ii ii ii ii ii ii ii ii ii ii ii




ii step-by-step analysis and identifying insufficiencies (Digital Healthcare Research, 2020).This ii ii ii ii ii ii ii ii i




ii particular flowchart outlines theworkflow process for emergency severity index (ESI) Level 3
ii ii ii ii ii ii ii ii ii ii ii ii




ii patients. In the flowchart, the steps of the process are represented by different shapes, each which
ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii




ii symbolize a different action. The flowchart starts with an oval indicating the beginning or end of the
ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii




ii workflow. The rectangle symbolizes a process taking place, the diamond indicates a decision is to be
ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii




ii made, the bullet shape represents a delay in the process, and lastly, the flowchart ends with another oval
ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii




ii to represent the end of the workflow process.
ii ii ii ii ii ii ii




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




ii starts with 5 patients who are then registered by the receptionist into the healthcare informationsystem
ii ii ii ii ii ii ii ii ii ii ii ii ii ii i




(HIS).Thissteptakesabout21.4minutestocomplete.Aftertheregistration, the patient must wait 32.6
i i ii i ii i i i i i ii i ii ii ii ii ii




ii minutes, which increases their time spent in the ED. The triage nurse will then initiate the patient’s
ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii




ii chart, taking another 24.8 minutes to complete. Next, the triage nurse will escort the patient to the ED
ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii




ii room and bed and will then give report to the ED nurse who will then assume the patient’s care. This step
ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii




ii takes 14.8 minutes to complete. The patient then must wait another 43.2 minutes to be seen by the ED
ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii




ii provider. The ED provider will then conduct an examination of the patient that takes 17.8 minutes.
ii ii ii ii ii ii ii ii ii ii ii ii ii ii ii




ii Based on the examination findings, theEDproviderwillthengive orders.The orders could belabs, CT,
ii ii ii ii ii i ii ii i i ii i ii ii ii ii ii




radiology,or for a
i ii ii ii