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 develop a simple GUI that will allow users to perform CRUD functionalities. You will be provided two tables and their attributes. You will have to create the tables through flyway using SQL commands. 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 with GUI.
3. Test application with real/simulated events.

Keywords

Table Creation, Database, SQL, Java, GUI

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. 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: 290 minutes (Part 1: 20 minutes; Part 2: 90 minutes; Part 3: 120 minutes; Part 4: 60 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)

AddressBookDAOFlyGUI (Starter Project File)

Hospital Emergency Department Simulation (Simio File)

LGoodDatePicker (LGoodDatePicker jar File, Tested with NetBeans 8.2)

Instructors: Click here to request access to instructor copy.