NotesFAQContact Us
Collection
Advanced
Search Tips
Back to results
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1034056
Record Type: Journal
Publication Date: 2013
Pages: 10
Abstractor: As Provided
ISBN: N/A
ISSN: ISSN-1055-3096
EISSN: N/A
Using a Semi-Realistic Database to Support a Database Course
Yue, Kwok-Bun
Journal of Information Systems Education, v24 n4 p327-336 Win 2013
A common problem for university relational database courses is to construct effective databases for instructions and assignments. Highly simplified "toy" databases are easily available for teaching, learning, and practicing. However, they do not reflect the complexity and practical considerations that students encounter in real-world projects after their graduation. On the other hand, production databases may contain too much domain nuances and complexity to be effectively used as a learning tool. Sakila is a semi-realistic, high quality, open source, and highly available database provided by MySQL. This paper describes the use of Sakila as a unified platform to support instructions and multiple assignments of a graduate database course for five semesters. Based on seven surveys with 186 responses, the paper discusses our experience using Sakila. We find this approach promising, and students in general find it more useful and interesting than the highly simplified databases developed by the instructor, or obtained from textbooks. We constructed a collection of 124 problems with suggested solutions on the topics of database modeling and normalization, SQL query, view, stored function, stored procedure, trigger, database Web-driven application development with PHP/MySQL, Relational Algebra using an interpreter, Relational Calculus, XML generation, XPath, and XQuery. This collection is available to Information Systems (IS) educators for adoption or adaptation as assignments, examples, and examination questions to support different database courses.
Journal of Information Systems Education. e-mail: editor@jise.org; Web site: http://www.jise.org
Publication Type: Journal Articles; Reports - Research
Education Level: Higher Education; Postsecondary Education
Audience: N/A
Language: English
Sponsor: National Science Foundation
Authoring Institution: N/A
Identifiers - Location: Texas
Grant or Contract Numbers: 1060039