In this article we discuss the use of RapidMiner, a data science software platform, in a Database Management Systems course. For further understanding of the database and the skill learned, students are given an assignment to complete, to not only use another software beside SQL Server Management Studio but also translate their findings in a more…

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…

This applied database exercise utilizes a scenario-based case study to teach the basics of Microsoft Access and database management in introduction to information systems and introduction to database course. The case includes background information on a start-up business (i.e., Carol's Travel Club), description of functional business requirements,…

This article presents a case scenario that may be used in system analysis and design, database management, and business analytics classes. The case document includes realistic, detailed information on the operations at the American Guild of Musical Artists (AGMA). Examples of assignments for each class and suggested reading are presented. In each…

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…

The case provides a realistic scenario that can be used in a systems analysis and design, accounting information systems or graduate level management information systems course. The case details the steps in the revenue and expense cycle processes of a health supply wholesale company providing students with the opportunity to map the business…

Coastal Pacific Doctor Associates (CPDA) is a multi-physician medical practice located along the west coast. CPDA decided to replace their inadequate and outdated medical office system during a time of tremendous restructuring in the medical software industry. In their impatience, CPDA chose an electronic medical record (EMR) and practice…

This case consists of a business scenario of a small video rental store, Home Theater Video, which provides background information, a description of the functional business requirements, and sample data. The case provides sufficient information to design and develop a moderately complex database to assist Home Theater Video in solving their…

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 article argues that a design studio can be a dynamic medium to explore the creative potential of the complexity of sustainability from its technological to social ends. The study seeks to determine the impact of an interior design/architecture studio experience that was initiated to teach diverse meanings of sustainability and to engage the…

This discussion of the design of data files for databases to be created by secondary school students uses AppleWorks software as an example. Steps needed to create and use a database are explained, the benefits of group activity are described, and other possible projects are listed. (LRW)

Presents guidelines for creating student database files that supplement classroom teaching. Highlights include determining educational objectives, planning the database with computer specialists and subject area specialists, data entry, and creating student worksheets. Specific examples concerning elements of the periodic table and…

Outlines techniques used in the context of a sixth grade science class to teach database structure and search strategies for science using the AppleWorks program. Provides templates and questions for class and element databases. (Author/YP)

This learning activity packet (LAP) contains nine self-paced study lessons that allow students to proceed along a a 43-hour course of study for dBase III Plus at their own pace. The lessons are organized in the following way: objectives, completion standard, performance standard, a list of required materials, unit test, and exercises (applications…

This learning activity packet (LAP) contains five self-paced study lessons that allow students to proceed along a 22-hour course of study for dBase III Plus Advanced at their own pace. It continues the introductory dBase III Plus course. The lessons are organized in the following way: objectives, completion standard, performance standard, a list…