WGU C792 DATA MODELING AND DATABASE
MANAGEMENT SYSTEMS EXAM QUESTIONS AND
CORRECT VERIFIED ANSWERS WITH RATIONALES
100% GUARANTEED PASS!!
<LATEST VERSION>
Question 1
An emergency department wants to document the workflow of an ESI Level 3
patient from arrival through discharge. The team wants the diagram to clearly show
which activities are performed by the registration clerk, triage nurse, provider,
laboratory, and patient.
Which modeling approach is most appropriate?
A. Entity-relationship diagram
B. Cross-functional flowchart with swim lanes
C. Relational schema
D. Data dictionary
Answer: B
Rationale: A cross-functional flowchart uses swim lanes to separate activities
according to the person, department, or organizational role responsible for them.
This makes responsibility transfers and workflow handoffs visible. An ERD
models data relationships rather than operational workflow.
,Question 2
During an ED workflow review, the analyst observes the following sequence:
1. Patient arrives.
2. Registration information is entered.
3. Patient waits for triage.
4. Triage assessment is completed.
5. Patient waits for provider evaluation.
6. Provider orders laboratory testing.
7. Laboratory results become available.
8. Provider reviews results.
The longest delay occurs between steps 3 and 4 because only one triage nurse is
available during peak hours.
What should the analyst identify this point as?
A. Data dependency
B. Referential constraint
C. Workflow bottleneck
D. Transitive dependency
Answer: C
Rationale: A bottleneck occurs when a constrained resource limits the flow of an
otherwise sequential process. Here, limited triage capacity creates the delay. The
other choices describe database concepts rather than an operational workflow
constraint.
,Question 3
A process diagram begins when an ED patient arrives and ends when the patient is
discharged. The analyst needs symbols that clearly distinguish the beginning and
ending points from activities performed during the workflow.
Which flowchart symbol should represent the beginning and ending points?
A. Diamond
B. Rectangle
C. Terminator
D. Document
Answer: C
Rationale: The terminator symbol represents the start or end of a flowchart
process. Rectangles generally represent processes, diamonds represent decisions,
and document symbols identify documents or reports.
Question 4
A workflow contains the following decision:
“Are the patient's laboratory results available?”
If the answer is No, the process continues to a waiting step. If the answer is Yes,
the provider reviews the results.
Which flowchart symbol should represent this point?
A. Diamond
B. Rectangle
C. Terminator
D. Document
Answer: A
Rationale: A diamond represents a decision point with alternative paths, such as
Yes/No outcomes. The resulting branches allow the workflow to represent
different actions depending on the condition.
, Question 5
A hospital database contains the following table:
PatientID PatientName PhoneNumber Diagnosis
1001 Maria Lopez 555-1000 Asthma
1001 Maria Lopez 555-1000 Hypertension
The database designer wants each patient to appear only once while still allowing a
patient to have multiple diagnoses.
Which redesign best supports this requirement?
A. Store all diagnoses in one comma-separated field
B. Create a Patient table and a separate Diagnosis/Patient-Diagnosis structure
C. Duplicate the patient's demographic information for every diagnosis
D. Remove PatientID from the table
Answer: B
Rationale: Separating patient demographic data from repeating clinical
relationships reduces redundancy and allows multiple diagnoses to be associated
with one patient. Storing multiple values in one field violates atomicity and makes
querying difficult.
MANAGEMENT SYSTEMS EXAM QUESTIONS AND
CORRECT VERIFIED ANSWERS WITH RATIONALES
100% GUARANTEED PASS!!
<LATEST VERSION>
Question 1
An emergency department wants to document the workflow of an ESI Level 3
patient from arrival through discharge. The team wants the diagram to clearly show
which activities are performed by the registration clerk, triage nurse, provider,
laboratory, and patient.
Which modeling approach is most appropriate?
A. Entity-relationship diagram
B. Cross-functional flowchart with swim lanes
C. Relational schema
D. Data dictionary
Answer: B
Rationale: A cross-functional flowchart uses swim lanes to separate activities
according to the person, department, or organizational role responsible for them.
This makes responsibility transfers and workflow handoffs visible. An ERD
models data relationships rather than operational workflow.
,Question 2
During an ED workflow review, the analyst observes the following sequence:
1. Patient arrives.
2. Registration information is entered.
3. Patient waits for triage.
4. Triage assessment is completed.
5. Patient waits for provider evaluation.
6. Provider orders laboratory testing.
7. Laboratory results become available.
8. Provider reviews results.
The longest delay occurs between steps 3 and 4 because only one triage nurse is
available during peak hours.
What should the analyst identify this point as?
A. Data dependency
B. Referential constraint
C. Workflow bottleneck
D. Transitive dependency
Answer: C
Rationale: A bottleneck occurs when a constrained resource limits the flow of an
otherwise sequential process. Here, limited triage capacity creates the delay. The
other choices describe database concepts rather than an operational workflow
constraint.
,Question 3
A process diagram begins when an ED patient arrives and ends when the patient is
discharged. The analyst needs symbols that clearly distinguish the beginning and
ending points from activities performed during the workflow.
Which flowchart symbol should represent the beginning and ending points?
A. Diamond
B. Rectangle
C. Terminator
D. Document
Answer: C
Rationale: The terminator symbol represents the start or end of a flowchart
process. Rectangles generally represent processes, diamonds represent decisions,
and document symbols identify documents or reports.
Question 4
A workflow contains the following decision:
“Are the patient's laboratory results available?”
If the answer is No, the process continues to a waiting step. If the answer is Yes,
the provider reviews the results.
Which flowchart symbol should represent this point?
A. Diamond
B. Rectangle
C. Terminator
D. Document
Answer: A
Rationale: A diamond represents a decision point with alternative paths, such as
Yes/No outcomes. The resulting branches allow the workflow to represent
different actions depending on the condition.
, Question 5
A hospital database contains the following table:
PatientID PatientName PhoneNumber Diagnosis
1001 Maria Lopez 555-1000 Asthma
1001 Maria Lopez 555-1000 Hypertension
The database designer wants each patient to appear only once while still allowing a
patient to have multiple diagnoses.
Which redesign best supports this requirement?
A. Store all diagnoses in one comma-separated field
B. Create a Patient table and a separate Diagnosis/Patient-Diagnosis structure
C. Duplicate the patient's demographic information for every diagnosis
D. Remove PatientID from the table
Answer: B
Rationale: Separating patient demographic data from repeating clinical
relationships reduces redundancy and allows multiple diagnoses to be associated
with one patient. Storing multiple values in one field violates atomicity and makes
querying difficult.
