three lab diagram and a written assignment data evaluation

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



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.