Information Systems Education Journal

Volume 13

V13 N2 Pages 26-38

March 2015

A Database Management Case Project: The Cocoa Shop

Renee Pratt
Washington and Lee University
Lexington, VA 24450, USA

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

Abstract: 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 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 express by TCS. 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. These teaching notes contain suggested target courses in which to use the case, specific learning objectives, associated information systems and database theory, suggested implementation guidelines and rubrics, a possible entity-relationship model, the resulting physical database structures, and the solution to the forms, queries, reports, and switchboard.

Keywords: Intro to MIS, Database Management, Systems Analysis and Design

Download this article: ISEDJ - V13 N2 Page 26.pdf

Recommended Citation: Pratt, R., Smatt, C. (2015). A Database Management Case Project: The Cocoa Shop. Information Systems Education Journal, 13(2) pp 26-38. ISSN: 1545-679X. (A preliminary version appears in The Proceedings of ISECON 2014)