The automatic code generation is the process of generating source code snippets from a program, i.e., code for generating code. Its importance lies in facilitating software development, particularly important is helping in the implementation of software designs such as engineering diagrams, in such a case, automatic code generation copes with the…

This article presents a multi-stage guided technical project coding Python scripts for utilizing Amazon Web Services (AWS) to work with a document-store database called DynamoDB. Students doing this project should have taken an introductory programming class (ideally in Python) and a database class to have experience with Python coding and…

This design case discusses the complex collaborative design reasoning processes involved in developing an online interactive learning tool for learners of all ages to explore and understand the role of flagellate plants in our society. The learning tool consists of a main website (the "Voyager") and an interactive, dynamic map of the…

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…

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…

The SQL-Explore Learning Module detailed in this teaching tip provides an opportunity for students to apply database course knowledge beyond solving traditional pre-determined Structured Query Language (SQL) coding questions. In this unique constructivist activity using the apropos 5E Instructional Model, students explore tables to locate data…

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

The National Center for Biotechnology Information Entrez Direct (EDirect) software facilitates programmatic access to numerous biomedical, chemical, and literature databases from within a Unix terminal. EDirect has traditionally been used for command line access to NCBI data within the fields of computational biology and bioinformatics. This…

The explosion in availability and variety of data requires learning experiences that reveal more of the data world faster and develop practical skills with digital technologies. Key high-level goals of the International Data Science in Schools Project (IDSSP) include having students continually immersed in the cycle of learning from data, and data…

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…

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…

Early exposure to data science skills, such as relational databases, is essential for students in statistics as well as many other disciplines in an increasingly data driven society. The goal of the presented pedagogy is to introduce undergraduate students to fundamental database concepts and to illuminate the connection between these database…

The Purdue Polytechnic Institute was created two years ago from the former College of Technology. This was more than a name change; it represented a transformation which will have an impact not only the curriculum, but on learning, and teaching methods. Students need technical skills but they must also be able to collaborate, be problem solvers,…

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 Education Program Provider Chair's objective was to create a student legacy artifact archival retrieval system. The goal was to have the database system operational by Spring Semester, 2019. The purpose of the new system was to house and index student and pre-service candidate product across performance levels reflective of the program's key…