Volume 6
Volume 6, Number 14 |
February 14, 2008 |
|
Ranida B. Harris
Michael Cline
Jeremy Cooley
|
Abstract: Many IS educators have suggested and empirically shown the benefits of active learning methodologies. One such technique involves the use of case studies, as they enable students to think analytically and solve a real-world problem. This paper presents a case designed to be used for group projects in a database design and development course. The case is about the Laophong Nang Veteran Association Reunion System, which is adapted from a real-world problem with names being changed. The case provides students with a challenging real-world exercise in relational database design. The case provides enough information to be stimulating and demanding, but not so much that students are overwhelmed with the challenges in the case. The project can be structured as an overall project, multiple deliverables, or even singular tasks if aspects of the system are separated. Suggested deliverables include the design of entity-relationship diagrams, relational schema, normalized relational schema, data dictionary, SQL query, forms and reports, stored procedures and triggers, and system documentations.
Keywords: database design, database development, normalization, entity-relationship diagram, case
Download this issue: ISEDJ.6(14).Harris.pdf (Adobe PDF, 11 pages, 546 K bytes)
Preview the contents: Harris.c.txt (ASCII txt, 28 K bytes)
Recommended Citation: Harris, Cline, and Cooley (2008). A Database Design and Development Case: Laophong Nang Veteran Association Reunion System. Information Systems Education Journal, 6 (14). http://isedj.org/6/14/. ISSN: 1545-679X. (A preliminary version appears in The Proceedings of ISECON 2007: §3124. ISSN: 1542-7382.)