Summary and Learning Objectives
ACME Manufacturing has hired you as a software engineer to develop an information system for their manufacturing assembly to track their items and worker performance. The manufacturing assembly has an assembly line, multiple storage racks, a rework area, a packaging area, and two docks. Your team is assigned to observe the manufacturing assembly 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 manufacturing assembly, 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:
- Import data into the database using SQL scripts.
- Create a CRUD application.
- 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 – Manufacturing Assembly, 2. GUI Database Application Development Using Object Oriented Programming – Manufacturing Assembly)
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)
Manufacturing Assembly Simulation (Simio File)
Instructors: Click here to request access to instructor copy.
Be First to Comment