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. http://isedj.org/2017-15/ ISSN: 1545-679X. (A preliminary version appears in The Proceedings of EDSIG 2016)