Continuing to fill the literature gap, this research replicated and expands a prior study of student performance in database normalization in an introductory database course. The data was collected from four different universities, each having different prerequisite courses for their database course. Student performance on a database normalization…

The pet care service industry is booming. The U.S. Census Bureau (2019) recorded pet service industry payroll numbers at almost $11.2 billion (excluding veterinarian services). In this teaching case, Mark, the owner of a successful dog boarding business, is looking to capitalize on that growth as he expands his customer demographic to welcome cats…

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…

Many organizations are dealing with the increasing demands of big data, so they are turning to NoSQL databases as their preferred system for handling the unique problems of capturing and storing massive amounts of data. Therefore, it is likely that employees in all sizes of organizations will encounter NoSQL databases. Thus, to be more job-ready,…

The Slushie World case study is designed to teach the basics of Microsoft Access and database management over a series of three 75-minute class sessions. Students are asked to build a basic database to track sales and inventory for a small business. Skills to be learned include table creation, data entry and importing, form and report design,…

Information systems curricula are increasingly using active learning methodologies to help students learn "through" technology rather than just "about" technology. While one way to achieve this is through the assignment of semester-long projects, previous research suggests that real-world projects provide more meaningful…

In this paper, we describe how database instructors can teach Relational Algebra and Structured Query Language together through programming. Students write query programs consisting of sequences of Relational Algebra operations vs. Structured Query Language SELECT statements. The query programs can then be run interactively, allowing students to…

All Computer Information Systems programs require a database course for their majors. This paper describes an approach to such a course in which real world examples, both design projects and actual database application projects are incorporated throughout the semester. Students are expected to apply the traditional database concepts to actual…

The launch of HealthCare.gov, the website of the Affordable Care Act (AKA Obamacare), was a major public relations disaster for the Obama administration. This case examines some of the factors that contributed to the failure of the launch and then details how Optum, an information technology service provider, considered the opportunity provided by…

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…

This research paper presents a database management system for tracking course assessment data and reporting related outcomes for program assessment. It improves on a database system previously presented by the authors and in use for two years. The database system presented is specific to assessment for ABET (Accreditation Board for Engineering and…

This case describes a database redesign project for the United States Department of Agriculture's National Animal Germplasm Program (NAGP). The case provides a valuable context for teaching and practicing database analysis, design, and implementation skills, and can be used as the basis for a semester-long team project. The case demonstrates the…

States have made dramatic progress in the past few years in implementing longitudinal data systems (LDS) to improve student achievement. These systems collect and house student educational data that make it easy for policymakers and practitioners to access and use it for reporting, policymaking and decision making. So much has happened in states…

The American Recovery and Reinvestment Act (ARRA) provides several funding opportunities that can assist states in designing, developing, and implementing statewide education longitudinal data systems. These new and enhanced information systems will enable states to track student progress within and across the secondary and postsecondary education…

This document contains abstracts of papers on database design and management which were presented at the 1986 mid-year meeting of the American Society for Information Science (ASIS). Topics considered include: knowledge representation in a bilingual art history database; proprietary database design; relational database design; in-house databases;…