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 case study consists of a real database project for a charter school--Scholar's Academy--and provides background information on the school and its cafeteria processing system. Also included are functional requirements and some illustrative data. Students are tasked with the design and development of a database for the purpose of improving the…

This case describes the situation of Smile Land Academy (SLA), a real-world based childcare center. SLA has grown from a very small company to a fairly large-sized organization (30 employees with 150 children). Unfortunately, its system for record-keeping, summarization of data, and reporting has not kept pace. The hard copies and spreadsheet…

This case provides a real-world project-oriented case study for students enrolled in a management information systems, database management, or systems analysis and design course in which database design and development are taught. The case consists of a business scenario to provide background information and details of the unique operating…