Journal of Information Systems Education (JISE)

Volume 23

Volume 23 Number 1, Pages 19-28

Spring 2012


Teaching Case
The Animal Genetic Resource Information Network (AnimalGRIN) Database: A Database Design & Implementation Case


Gretchen Irwin
Colorado State University
Fort Collins, CO 80523, USA

Lark Wessel
Houston, TX 77004, USA

Harvey Blackburn
USDA, National Center for Genetic Resources
Fort Collins, CO 80521, USA

Abstract: This case describes a database redesign project for the United States Department of Agriculture’s National Animal Germplasm Program (NAGP). The case provides a valuable context for teaching and practicing database analysis, design, and implementation skills, and can be used as the basis for a semester-long team project. The case demonstrates the broad applicability of database skills to domains outside typical business applications. The functional requirements for the NAGP’s information system are documented with a detailed set of use cases, which are commonly used in practice and which provides a link between the database course and the systems analysis and design course in many information systems curricula. The NAGP database redesign project was initiated because the original database design was not flexible or rigorous enough to handle the ways in which the organization’s needs grew. The case provides several opportunities to emphasize design flexibility and data integrity controls.

Keywords: Database design & development, Entity-relationship modeling/diagram, Structured query language

Download this article: JISE - Volume 23 Number 1, Page 19.pdf


Recommended Citation: Irwin, G., Wessel, L., & Blackburn, H. (2012). Teaching Case: The Animal Genetic Resource Information Network (AnimalGRIN) Database: A Database Design & Implementation Case. Journal of Information Systems Education, 23(1), 19-28.