SQL is taught in almost all university level database courses, yet SQL has received relatively little attention in educational research. In this study, we present a database management system independent categorization of SQL query errors that students make in an introductory database course. We base the categorization on previous literature,…

Aim/Purpose: The study aimed to investigate the effect of using the gamified flipped classroom instructional method on the students' overall achievement compared to the traditional non-gamified, non-gamified flipped classroom, and traditional gamified instructional methods. Background: Flipped classroom is helpful to address limited class time,…

Faced the vast amount of information, choosing the appropriate materials is a prerequisite for effective self-directed learning. The recommendation algorithm is a kind of intelligent technology that can accurately locate the required information which the users care about most. However, many recommendation techniques experience can not be trained…

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…

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…

Aim/Purpose: The complexity of today's organizational databases highlights the importance of hard technical skills as well as soft skills including teamwork, communication, and problem-solving. Therefore, when teaching students about databases it follows that using a team approach would be useful. Background: Team-based learning (TBL) has been…

Aim/Purpose: This paper addresses the lack of a standardized approach to information dashboard design and the absence of integrated Information Governance (IG) principles in this context. Background: This study addresses the critical role of IG principles in ensuring dashboards are reliable, secure, and effective. By integrating IG principles into…

The main objective of the Fiscal Year (FY) 2025 Federal Information Security Modernization Act of 2014 (FISMA) audit was to determine whether the United States Department of Education (Department)'s overall information security program and practices are effective as they relate to federal information security requirements. To meet this objective,…

This study investigates how article downloads from ScienceDirect changed after Temple University Libraries downsized its all-inclusive Elsevier big deal bundle to a selective custom package. After the libraries lost current-year access to nearly half of Elsevier's active journals, the total downloads from Elsevier journals declined by 16.2 percent…

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…

Tracking and using data to inform decisions pays off for college success programs on multiple levels. Having data allows program staff to monitor the progress of individual students and tailor support to their particular needs. It enables staff to understand the effectiveness of program activities and make improvements as necessary. Most…

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…

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,…

A common problem encountered when teaching database courses is that few large illustrative databases exist to support teaching and learning. Most database textbooks have small "toy" databases that are chapter objective specific, and thus do not support application over the complete domain of design, implementation and management concepts…

Teachers' use of student data to inform instruction is commonly accepted as sound educational practice, and this data use is only likely to grow as more data, as well as more-complex data, become increasingly available to educators. However, numerous studies reveal inconsistent data use among teachers and an overall lack of the preparation and…