In this article we discuss the use of RapidMiner, a data science software platform, in a Database Management Systems course. For further understanding of the database and the skill learned, students are given an assignment to complete, to not only use another software beside SQL Server Management Studio but also translate their findings in a more…

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…

This case describes a real-world scenario based on a fictional new commuter airline seeking to develop a database to support their operations. Students are asked to design and develop a database to allow the airline to track flights, passengers, bookings, and more, based on a set of business rules, default data, and other requirements. The case…

This teaching case describes the functionality of an applicant processing system designed for a fictitious hotel chain. The system detailed in the case includes a webform where applicants complete and submit job applications. The system also includes a desktop application used by hotel managers and Human Resources to track applications and process…

The following is an applied database scenario based on a single season in the FIA Formula One (F1) World Championship of auto racing. This scenario builds database understanding and skills through data modeling, data acquisition, creation of a database schema through a database management system, query construction, and report creation. In the…

This article presents a case scenario that may be used in system analysis and design, database management, and business analytics classes. The case document includes realistic, detailed information on the operations at the American Guild of Musical Artists (AGMA). Examples of assignments for each class and suggested reading are presented. In each…