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…

Customer Service is important for a myriad of reasons, such as retaining customers, building customer loyalty, getting customer referrals, improving employee happiness, and remaining competitive. However, as a company grows, the focus may be on sales and production, with customer service efficiency and effectiveness being seen as an overhead…

A nationally prominent woman's advocacy organization is featured in this case study. The scenario may be used as a teaching case, an assignment, or a project in systems analysis and design as well as database design classes. Students are required to document the system operations and requirements, apply logical data modeling concepts, and design…