ERIC Number: EJ831386
Record Type: Journal
Publication Date: 2008
Abstractor: As Provided
Reference Count: 0
The Recovery Care and Treatment Center: A Database Design and Development Case
Harris, Ranida B.; Vaught, Kara L.
Journal of Information Systems Education, v19 n3 p277-280 2008
The advantages of active learning methodologies have been suggested and empirically shown by a number of IS educators. Case studies are one such teaching technique that offers students the ability to think analytically, apply material learned, and solve a real-world problem. This paper presents a case study designed to be used in a database design and development course. The case is about the Recovery Care and Treatment Center System, a real-world organization with names changed. The case is challenging, presents a real-world exercise, and allows students to apply a number of the skills they discuss and learn in class. The case provides sufficient information to be demanding and thought-provoking, but not so much that the case becomes overwhelming in terms of its challenges. The project may be structured as a group or individual project. Additionally, the structure of assigned work from the case can be an overall project, multiple deliverables, or even singular assignments if aspects of the database are separated. Suggested deliverables include relational schema, normalized relational schema, design of entity-relationship diagrams, data dictionary, SQL queries, forms and reports, and other system documentations.
Descriptors: Database Design, Active Learning, Databases, Case Studies, Clinics, Teaching Methods, Drinking, Alcoholism, Alcohol Abuse, Patients, Drug Abuse, Drug Addiction
Journal of Information Systems Education (JISE). c/o Al Harris, JISE Editor, Department of Computer Information Systems, Walker College of Business, Appalachian State University, Boone, NC 28608. Tel: 828-262-6180; Fax: 828-262-6190; e-mail: firstname.lastname@example.org; Web site: http://www.jise.appstate.edu/index.htm
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Authoring Institution: N/A