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

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




Data Modeling and Database Management Systems
w2 w2 w2 w2 w2




w2Caitlin Galvin
w2




Western Governors University
w2 w2

, 2
DATA MODELING AND DATABASE MANAGEMENT SYSTEMS
w2 w2 w2 w2 w2




Data Modeling and Database Management Systems
w2 w2 w2 w2 w2




Flowchart Aspects w2




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




w2help understand the existing process and find potential ways to improve it (Institution for
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2Healthcare Improvement, 2020). Healthcare organizations may benefit from the use of
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2flowcharts by offering a step-by-step analysis and identifying insufficiencies (Digital Healthcare
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2Research, 2020). This particular flowchart outlines the workflow process for emergency severity
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2index (ESI) Level 3 patients. In the flowchart, the steps of the process are represented by
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2different shapes, each which symbolize a different action. The flowchart starts with an oval
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2indicating the beginning or end of the workflow. The rectangle symbolizes a process taking
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2place, the diamond indicates a decision is to be made, the bullet shape represents a delay in the
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2process, and lastly, the flowchart ends with another oval to represent the end of the workflow
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2process.

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




w2process starts with 5 patients who are then registered by the receptionist into the healthcare
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2information system (HIS). This step takes about 21.4 minutes to complete. After the registration,
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




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




w2will then initiate the patient’s chart, taking another 24.8 minutes to complete. Next, the triage
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2nurse will escort the patient to the ED room and bed and will then give report to the ED nurse
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2who will then assume the patient’s care. This step takes 14.8 minutes to complete. The patient
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




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




w2conduct an examination of the patient that takes 17.8 minutes. Based on the examination
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2




w2findings, the ED provider will then give orders. The orders could be labs, CT, radiology, or for a
w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2 w2