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…

Many management information systems (MIS) faculty have adopted a project-oriented approach in their systems analysis and design courses. In these courses, students use a software development methodology to create a web or mobile application project, which can be based on a predefined case or developed for an external stakeholder. Because most…

The purpose of this teaching case is to develop a hands-on exercise on graph processing using a hybrid system. The paper provides a background on graph databases and how graph processing is supported in a hybrid system, SAP HANA. It also details step-by-step instructions on how to create, modify, and process a graph database using SAP HANA. The…

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…

High-quality data is essential when looking at student-level data, including data specifically focused on students with disabilities. For state education agencies (SEAs), it is critical to have a solid foundation for how data is collected and stored to achieve high-quality data. The process of integrating the Individuals with Disabilities…

This teaching tip explores the integration of AI tools into database education. The author describes how instructors can use AI tools to prepare teaching materials and how students can use AI to facilitate database development. The teaching tips provided encompass both course-level objectives and assignment-specific strategies. The inclusion of AI…

Many small organizations sponsor events and activities that could benefit from the data management and reporting capabilities provided through a centralized database. However, many of those organizations do not have the budget to afford a commercial solution or an on-going subscription to a cloud-based solution for a small scope event with limited…

This is an example of a real-world applicable case study, which includes background information on a small local business (i.e., TCS), description of functional business requirements, and sample data. Students are asked to design and develop a database to improve the management of the company's customers, products, and purchases by emphasizing…

This applied database exercise utilizes a scenario-based case study to teach the basics of Microsoft Access and database management in introduction to information systems and introduction to database course. The case includes background information on a start-up business (i.e., Carol's Travel Club), description of functional business requirements,…

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…

Data analytics is undergoing an evolution through effective data use to support both operational and learning analytics models. However, this evolution will require that institutional leaders transform their data systems to best support the needs of application modeling and use their intuition to help drive the development of better analytical…

The National Longitudinal School Database (NLSD) comprises three files, making up a near-census of all schools and districts in the United States from school years 1990-91 to 2019-20. The three files are the Public School File, Private School File, and District File. As evident by the titles, the first two files report data at the school-level for…

This teaching case addresses the design of a database that fulfills the complex requirements found at the Motion Picture Industry Pension Plan, an actual entity. With the goal of challenging students to think analytically and to apply information systems concepts and tools to real world situations, the case study was appropriately structured to…

Home visiting is an important component of the early childhood (EC) landscape. However, states often fail to prioritize home visiting data when developing their early childhood integrated data systems (ECIDS). Home visiting represents a range of services, models, and programs, each with different data requirements, so integrating the data can be…

The paper describes the concept of a federated ecosystem for Open Educational Resources (OER) in the German education system. Here, a variety of OER repositories (ROER) (Muuß-Merholz & Schaumburg, 2014) and reference platforms have been established in the recent past. In order to develop this ecosystem, not only are metadata standards…