Teaching Case: Widgets-R-Us: Using IoT to Monitor Part Levels

This teaching case describes the functionality of a system employing IoT sensors to monitor part levels for a fictitious auto parts manufacturer. Data from the sensors are used to populate a centralized database and generate a dashboard for management. The system also generates tiered alerts to notify part runners and managers of pending part shortages. The case is based on an actual systems development project that students completed for a real auto parts manufacturer. Material in the case can be used for assignments in systems analysis and design, database management, and data analytics courses. Teaching notes, including an entity-relationship diagram (ERD), data dictionary, data flow diagrams, prototype dashboard, and discussion questions are available through the JISE website.