ERIC Number: EJ1135412
Record Type: Journal
Publication Date: 2017-Mar
Pages: 8
Abstractor: As Provided
ISBN: N/A
ISSN: EISSN-1545-679X
EISSN: N/A
Available Date: N/A
Tourism through Travel Club: A Database Project
Pratt, Renée M. E.; Smatt, Cindi T.; Wynn, Donald E.
Information Systems Education Journal, v15 n2 p40-47 Mar 2017
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.
Descriptors: Tourism, Database Management Systems, Database Design, Information Systems, Entrepreneurship, Case Method (Teaching Technique), Student Projects, Courseware, Computer System Design, Design Requirements, Teaching Methods
Information Systems and Computing Academic Professionals. Box 488, Wrightsville Beach, NC 28480. e-mail: publisher@isedj.org; Web site: http://isedj.org
Publication Type: Journal Articles; Reports - Descriptive; Guides - Classroom - Teacher
Education Level: N/A
Audience: Teachers
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A
Author Affiliations: N/A