Summary and Learning Objectives

You are hired as a software engineer to develop an information system using an object-oriented programming language for Jackie’s “Dog and Shake”.  Your team is assigned to observe the hotdog stand location 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 hot dog stand, 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 – Hotdog Stand, 2. Database Application Development Using Object Oriented Programming – Hotdog Stand)

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)

Hotdog Stand Simulation (Simio File)

LGoodDatePicker (LGoodDatePicker jar File, Tested with NetBeans 8.2)

Instructors: Click here to request access to instructor copy.