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.