Summary and Learning Objectives 

As you are closing in on the end of your scouting report, your goal is to bring back a working database. Your first task is to set up the database based on the SQL script provided by Jackie’s database administrator. The script will create all the necessary tables and populate some data for a quick start. Next, you will develop a database application with CRUD functionalities. To test the CRUD functionalities of your database application, you will fill out the CRUD forms to track additional customers in the hotdog stand simulation model. Lastly, once the application is tested for CRUD functionalities you will create reports and visualizations in your application for data insight. Jackie’s “Dog and Shake” is in the later stage of preparing for a small test team to start a branch in Atlanta. The database application you will develop will help to track multiple hotdog branches under Jackie’s Dog and Shake. The figure below shows a snapshot of an immersive simulation model of the hotdog stand, which we will treat as the “real” system in this module. 

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. 
4. Create database reports and visualizations. 

Keywords 

Database, Application Development, Tables, SQL, Visualization, Report 

Discipline(s): 

Data Analytics; Information Science; Computer Science; Software Engineering 

Potential related courses/topics 

Database design 

Recommended educational level and audience 

Undergraduate; Graduate; Introductory, nonmajors or majors 

Prerequisites 

None. 

(Suggested related module: 1. Spreadsheet Tables and Normalization, 2. Entity Relationship Diagram and Relational Schema, 3. Creating and Querying Hot Dog Stand Database)

Necessary student resources 

Software/hardware: A computer with Simio installed on it. A database management system such as Oracle or MySQL. Integrated development environment to develop database application such as Oracle APEX, NetBeans or Microsoft Visual Studio. 

Immersion level 

The module supports both “low-immersion” (3D view on a typical display) and “high-immersion” (virtual reality using an Oculus Rift VR headset). 

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

Yes, but the solution of the system might be different. 

Recommended time frame and activity format 

Total time: 170 minutes (Part 1: 10 minutes; Part 2: 40 minutes; Part 3: 35 minutes; Part 4: 30 minutes; Part 5: 30 minutes; Bonus: 20 minutes) 

Download module material (problem description and immersive simulation model) 

Students:
Problem description
Simulation model (Simio file) – Day Shift
Simulation model (Simio file) – Night Shift
SQL Script (Oracle Version)
SQL Script (MS SQL Version)
SQL Script (MySQL version)

Instructors: Click here to request access to instructor copy.