Lab: Block Diagram Project
In this project, you will be planning the Emergency Department Information System for Medical Center at DeVry.
Using Microsoft Visio, you will draw a block diagram that identifies the information system environment, boundaries, inputs, outputs, component parts, and relationships among components. The system consists of a computerized encounter form, automated triage system, bed assignment system, and scheduling system. Your diagram will show how the components interact with each other in various ways.
In order to access Microsoft Visio, you must log into the Citrix Lab. You will click on the Microsoft Office 2010. Applications and then Microsoft Visio 2010. If you own Microsoft Visio 2010, you may use your own personal copy; however, please be certain that it is the 2010 version because this is the only acceptable file format for submission.
Lab: Data Flow Diagram
In this project, you will be preparing the data flow diagram for an outpatient radiology examination at the Medical Center at DeVry.
Using Microsoft Visio, you will prepare a data flow diagram that documents the external entities, processes, data stores, and data flows for the outpatient radiology scheduling and registration process.
Lab: Entity-Relationship Diagram
In this project, you will prepare the entity-relationship diagram for a relational database used in the patient admission process.
Written Assignment: Data Evaluation
Your system has been implemented at the Medical Center of DeVry and you have been requested to produce a report of data from the system.
Using a data dictionary, you will write an SQL command to satisfy a data retrieval request. The sample dictionary and data request are as follows.
Data Dictionary
Patient Table
Element | Definition | Typr | Length | Default | Constraints |
MR# | Unique identification number | Numeric | 9 | None | 100000000-999999999 |
LName | Individual’s last name | Alpha | 25 | None | None |
FName | Individual’s first name | Alpha | 20 | None | None |
Gender | Individual’s gender | Alpha | 1 | None | “F” or “M” |
Bdate | Individual’s birth date | Date | 8 | None | None |
Data Retrieval Request
List all patients with the last name of “Johnson”.
List all patients who are female.
List all patient last names and the medical record number of each.
Expert Solution Preview
Introduction: In this medical college course, students are required to complete various assignments and assessments to enhance their understanding of information systems and data management in healthcare.
Answer:
The lab assignments in this course include the Block Diagram, Data Flow Diagram, and Entity-Relationship Diagram projects. The Block Diagram project requires students to use Microsoft Visio to draw a diagram that identifies the components, inputs, outputs, and relationships of the Emergency Department Information System for Medical Center at DeVry. The Data Flow Diagram project involves preparing a diagram that documents the entities, processes, data stores, and data flows of the outpatient radiology examination process. The Entity-Relationship Diagram project requires students to create a diagram for the database used in patient admission.
The written assignment in this course is focused on data evaluation. Students are expected to produce a report of data from the system using a provided data dictionary. The report should include a SQL command to satisfy specific retrieval requests, such as listing all female patients or all patients with the last name of “Johnson.” Through these assignments and assessments, students will develop their skills in designing and managing information systems and analyzing data in healthcare settings.