ERIC Number: EJ1281540
Record Type: Journal
Publication Date: 2020
Pages: 18
Abstractor: As Provided
ISBN: N/A
ISSN: ISSN-1055-3096
EISSN: N/A
Improved Teaching of Database Schema Modeling by Visualizing Changes in Levels of Abstraction
Katz, Adi
Journal of Information Systems Education, v31 n4 p294-311 Fall 2020
Conceptual modeling of databases is a complex cognitive activity, particularly for novice database designers. The current research empirically tests a new pedagogy for this activity. It examines an instructional approach that stresses visualizing gradual transitions between levels of abstraction in different hierarchic levels of a relational database schema. The new approach builds on a four-level TSSL model from the field of human-computer interaction. TSSL, an acronym for the Task, Semantics, Syntax, and Lexical levels, is applied here to describe the levels of conceptual database modeling and to explain how improved instructional design can help minimize extraneous cognitive load during the design of database schemas. We tested the effectiveness of the proposed instructional approach via a controlled experiment carried out on IS students. We divided students into two groups, those exposed to a visual emphasis on the syntax of gradual transitions in a schema structure and those not exposed to it. We then measured performance in terms of errors in students' solutions while also recording their perceptions and attitudes toward the instructional approach and the activity of database modeling. Our results show that the new approach is an effective tool for teaching database modeling.
Descriptors: Databases, Database Design, Information Science Education, Teaching Methods, Models, Cognitive Processes, Difficulty Level, Instructional Effectiveness, Visual Aids, Student Attitudes, Error Patterns, Vertical Organization, College Students, College Instruction
Journal of Information Systems Education. e-mail: editor@jise.org; Web site: http://www.jise.org
Publication Type: Journal Articles; Reports - Research; Tests/Questionnaires
Education Level: Higher Education; Postsecondary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A