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…

"Not only SQL" (NoSQL) databases have become widespread across organizations, enabling sophisticated, data-driven applications to be highly available, distributed, and cloud-based, such as e-commerce, social media, online multiplayer games, and video streaming. However, NoSQL is still sparsely found in MIS and analytics curricula. This…

In this paper, we describe a Relational Algebra Query Language (RAQL) and Relational Algebra Query (RAQ) software product we have developed that allows database instructors to teach relational algebra through programming. Instead of defining query operations using mathematical notation (the approach commonly taken in database textbooks), students…

This paper describes the use and benefits of Microsoft's Adventure Works (AW) database to teach advanced database skills in a hands-on, realistic environment. Database management and querying skills are a key element of a robust information systems curriculum, and active learning is an important way to develop these skills. To facilitate active…

The patients receiving treatment from a hospital need to interact with multiple entities when claiming reimbursements. The complexities of the medical service supply chain can be simplified with an electronic clearance management system that allows hospitals, medical insurance bureau, bank, and patients to interact in a seamless and cashless…

Researchers are often distressed to discover that the data they wanted to use in their landmark study is not configured in a way that is usable by a Statistical Analysis Software Package (SASP). For example, the data needed may come from two or more sources and it may not be clear to the researcher how to get them combined into one analyzable…

"Reflective Database Access Control" (RDBAC) is a model in which a database privilege is expressed as a database query itself, rather than as a static privilege contained in an access control list. RDBAC aids the management of database access controls by improving the expressiveness of policies. However, such policies introduce new interactions…

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…

Remote laboratories are technologies that aim to increase the effectiveness of educational programs. European Remote Radio Laboratory (ERRL) is an e-learning project for students, teachers and technicians who will use very important devices of a radio frequency laboratory remotely. As a solution we have developed an e-learning system which aims to…

Remote laboratories are technologies that aim to increase the effectiveness of educational programs. European Remote Radio Laboratory (ERRL) is an e-learning project for students, teachers and technicians who will use very important devices of a radio frequency laboratory remotely. As a solution we have developed an e-learning system which aims to…

This description of ways in which database management systems can be helpful in instructional media centers explains the basic terminology involved and how to plan, create, modify, maintain, and use databases. Examples provided include an equipment distributions form and the structure for a film/video rental database. (LRW)

This guide was developed as a "how to" training device for merging database and word processing files using Appleworks and the Apple IIe computer with a Duodisk or two disk drives. Step-by-step directions are provided for transferring the database file, printing the file, moving to the word processor file, and merging documents. Also…

A chart of 40 alumni-development database systems provides information on vendor/Web site, address, contact/phone, software name, price range, minimum suggested workstation/suggested server, standard reports/reporting tools, minimum/maximum record capacity, and number of installed sites/client type. (DB)

Business intelligence derived from data warehousing and data mining has become one of the most strategic management tools today, providing organizations with long-term competitive advantages. Business school curriculums and popular database textbooks cover data warehousing, but the examples and problem sets typically are small and unrealistic. The…

The process of maintaining mailing lists and other informational files on outdoor program participants is, plainly and simply, a pain in the neck. Mailing list maintenance is particularly difficult for programs that deal with university students, due to their frequent moves. This paper describes a new software program, the Outdoor Program Data…