The Proceedings of the Information Systems Education Conference 2007: §3124 Home Papers/Indices prev (§3123) Next (§3132)

Sat, Nov 3, 9:00 - 9:25, Ellwood 2 Paper (refereed)

Recommended Citation: Harris, R B, M Cline, and J Cooley. A Database Design and Development Case: Laophong Nang Veteran Association Reunion System. In The Proceedings of the Information Systems Education Conference 2007, v 24 (Pittsburgh): §3124. ISSN: 1542-7382. (A later version appears in Information Systems Education Journal 6(14). ISSN: 1545-679X.)

Recipient of Meritorious Student Paper Award

A Database Design and Development Case: Laophong Nang Veteran Association Reunion System

Refereed

9 pages

Ranida B. Harris    [a1] [a2]
School of Business
Indiana University Southeast    [u1] [u2]
New Albany, Indiana, USA    [c1] [c2]

Michael Cline    [a1] [a2]
School of Business
Indiana University Southeast    [u1] [u2]
New Albany, Indiana, USA    [c1] [c2]

Jeremy Cooley    [a1] [a2]
School of Business
Indiana University Southeast    [u1] [u2]
New Albany, Indiana, USA    [c1] [c2]

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

Read this refereed paper in Adobe Portable Document (PDF) format. (9 pages, 383 K bytes)
Preview this refereed paper in Plain Text (TXT) format. (28 K bytes)

CDpic
Comments and corrections to
webmaster@isedj.org