Summary and Learning Objectives

The construction of a new airport terminal in a small town has recently been completed. The terminal has eight self-check-in machines, one clerk check-in, one ID check and two advanced imaging technology (AIT) units for scanning passengers and their luggage. You are hired as a software engineer to develop an information system using an object-oriented programming language. Your team is assigned to observe the airport 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 airport, 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 – Airport Terminal, 2. Database Application Development Using Object Oriented Programming – Airport Terminal)

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)

Airport Terminal Simulation (Simio File)

LGoodDatePicker (LGoodDatePicker jar File, Tested with NetBeans 8.2)

Instructors: Click here to request access to instructor copy.