NoSQL databases have been used in organizations for decades. Few database textbooks on the market, however, have suitable materials about NoSQL beyond general introductions for typical business students. In fact, users of the typical NoSQL systems on the software market need to have certain computer programming skills. This teaching tip introduces…

Conceptual modeling of databases is a complex cognitive activity, particularly for novice database designers. The current research empirically tests a new pedagogy for this activity. It examines an instructional approach that stresses visualizing gradual transitions between levels of abstraction in different hierarchic levels of a relational…

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…

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…

Business schools are increasingly establishing MBA business analytics programs. This article discusses the importance of a sufficient body of knowledge about databases for MBA business analytics students. It presents the pedagogical design and the teaching method of a module of database-centric OLAP (online analytical process) for an MBA business…

Structured Query Language (SQL) is still the de facto database query language widely used in industry and taught in almost all university level database courses. The role of SQL is further strengthened by the emergence of NewSQL systems which use SQL as their query language as well as some NoSQL systems, e.g., Cassandra and DynamoDB, which base…

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…

Data Mining (DM) is one of the most offered courses in data analytics education. However, the design and delivery of DM courses present a number of challenges and issues that stem from the DM's interdisciplinary nature and the industry expectations to generate a broader range of skills from the analytics programs. In this research, we identified…

Enterprise resource planning systems (ERP) are the most essential and critical information systems that are widely used to build all the functions of a business into a unified and efficient enterprise system. Although the essence of ERP systems are easy to understand, students, especially those who do not have technical experience, have difficulty…

The aim of this paper is to provide sufficient detail that other members of the IS community can incorporate the business game "Flowers for the World" (or FFTW for short) into their IS teaching portfolio. The game promotes experiential (active) learning and has been used to support discussions or project work in such diverse subjects as…

This case study follows the security breach that affected Target at the end of 2013 and resulted in the loss of financial data for over 70 million customers. The case provides an overview of the company and describes the reasons that led to one of the biggest security breaches in history. It offers a discussion on Target's vendor management…

The demand for Information Systems (IS) graduates with expertise in Structured Query Language (SQL) and database management is vast and projected to increase as "big data" becomes ubiquitous. To prepare students to solve complex problems in a data-driven world, educators must explore instructional strategies to help link prior knowledge…

In recent years, there has been a significant increase in the demand from professionals in different areas for improving the curricula regarding information security. The use of authentic case studies in teaching information security offers the potential to effectively engage students in active learning. In this paper, the authors introduce the…

Semantic integrity constraints are business-specific rules that limit the permissible values in a database. For example, a university rule dictating that an "incomplete" grade cannot be changed to an A constrains the possible states of the database. To maintain database integrity, business rules should be identified in the course of database…

The advantages of active learning methodologies have been suggested and empirically shown by a number of IS educators. Case studies are one such teaching technique that offers students the ability to think analytically, apply material learned, and solve a real-world problem. This paper presents a case study designed to be used in a database design…