Information Systems Education Journal

Volume 15

V15 N2 Pages 40-47

March 2017

Tourism through Travel Club: A Database Project

Renee Pratt
University of Massachusetts Amherst
Amherst, MA 01003, USA

Cindi Smatt
University of North Georgia
Dahlonega, GA 30597, USA

Donald Wynn, Jr.
University of Dayton
Dayton, OH 45469, USA

Abstract: 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, and sample data. Carol is a young entrepreneur who wishes to start her own business. Starting a new business has required Carol to be more efficient with her resources. She desires a way to organize her data and would like a computerized database management system. Students are asked to design and develop a database to help her manage the new company’s customers, products, and purchases by emphasizing effective business rules and professional database development. In addition, this case will explore the benefits of working with MS Access, data population, creation and development of forms, queries, reports and a switchboard to complete the requirements expressed by Carol’s Travel. This case can be used in a course where the students have little or no prior relational database experience, as well as a more intermediate/advance level of experience. Teaching notes containing suggested guidelines, deliverables, and the resulting database containing data, forms, queries, reports, and switchboard are provided upon request.

Keywords: Introduction to Database, Introduction to MIS, Systems Design and Analysis

Download this article: ISEDJ - V15 N2 Page 40.pdf

Recommended Citation: Pratt, R., Smatt, C., Wynn, Jr., D. (2017). Tourism through Travel Club: A Database Project. Information Systems Education Journal, 15(2) pp 40-47. ISSN: 1545-679X. (A preliminary version appears in The Proceedings of EDSIG 2016)