ISEDJ

Information Systems Education Journal

Volume20

V20 N3 Pages 12-18

Jun 2022


Here We Grow Again! An Expansion for Mark’s Doggy Day Care: A Database Design and Development Case


Dana Schwieger
Southeast Missouri State University
Cape Girardeau, MO USA

Abstract: The pet care service industry is booming. The U.S. Census Bureau (2019) recorded pet service industry payroll numbers at almost $11.2 billion (excluding veterinarian services). In this teaching case, Mark, the owner of a successful dog boarding business, is looking to capitalize on that growth as he expands his customer demographic to welcome cats and rabbits, provide rehabilitative pet care, as well as better address the increasing needs of his longtime customers. This is a follow-up case to the Mark’s Doggy Daycare case that focused upon developing a database for Mark’s new entrepreneurial venture. The database created in the first case was not constructed for keeping track of repeated health care services administered to his clients throughout their stay nor to allow for other types of pets. In this case, Mark meets with the systems analyst consultant to discuss the requirements for modifying his database. He describes in detail the organization’s business processes, thus allowing the case to standalone without the need to reference the original case. Processes described in the case include customer management, reservations, invoicing, inventory management, and accounts receivables.

Download this article: ISEDJ - V20 N3 Page 12.pdf


Recommended Citation: Schwieger, D., (2022). Here We Grow Again! An Expansion for Mark’s Doggy Day Care: A Database Design and Development Case. Information Systems Education Journal20(3) pp 12-18. http://ISEDJ.org/2022-3/ ISSN : ISSN: 1545-679X. A preliminary version appears in The Proceedings of EDSIGCON 2021