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.
|MR#||Unique identification number||Numeric||9||None||100000000-999999999|
|LName||Individuals last name||Alpha||25||None||None|
|FName||Individuals first name||Alpha||20||None||None|
|Gender||Individuals gender||Alpha||1||None||“F” or “M”|
|Bdate||Individuals 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.