Skip to content

Database Application Development Using Object Oriented Programming – Manufacturing Assembly

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:

  1. Import data into the database using SQL scripts.
  2. Create a CRUD application.
  3. 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.

Published inComputer ScienceData AnalyticsIndustrial EngineeringSystems EngineeringVR Based

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Skip to toolbar