Summary and Learning Objectives

Alfie Medical Hospital has hired you as a software engineer to develop an information system for their Emergency Department to track their patients. This department has 4 visit rooms, 6 additional visit beds, a radiology area, triage, registration, and billing. Your team is assigned to observe the emergency department and create a database of the system and develop a database application of the system. You must create the database and test it before developing a database application. After testing the database, you need to work on a database application by modifying a given database application code template. The following figure shows a simulation model of the hospital emergency department, which we will treat as the “real” system in this assignment.

After successful completion of this Immersive Simulation-Based Learning (I-SBL) module, the student will be able to:

1. Import data into the database using SQL scripts.
2. Create a CRUD application.
3. Test application with real/simulated events.

Keywords

Table Creation, Database, SQL, Java

Discipline(s):

Data Analytics; Information Science; Computer Science; Software Engineering

Potential related courses/topics

Data collection and requirements gathering, database tables, normalization.

Recommended educational level and audience

Undergraduate; Graduate; Introductory, nonmajors or majors

Prerequisites

Familiarity with NetBeans and Java.

(Suggested related module: 1. Pseudocode and UML Diagram – Hospital Emergency Department, 2. GUI Database Application Development Using Object Oriented Programming – Hospital Emergency Department)

Necessary student resources

Software/hardware: A computer with Simio installed on it. A NetBeans version 8.2. A basic understanding of Java and SQL.

Immersion level

The module supports “low-immersion” (3D view on a typical display).

Can it be used as a traditional PBL module without the immersive simulation model?

No. Students need Simio to solve these problems.

Recommended time frame and activity format

Total time: 110 minutes (Part 1: 20 minutes; Part 2: 45 minutes; Part 3: 45 minutes)

Can be done as a homework assignment.

Can be done in groups or individually.

Download module material (problem description and immersive simulation model)

Students:
Problem description (PDF File)

AddressBookDAO(fly) (Starter Project File)

Hospital Emergency Department Simulation (Simio File)

Instructors: Click here to request access to instructor copy.