About this paper

Appears in:
Page: 7219 (abstract only)
Publication year: 2017
ISBN: 978-84-697-3777-4
ISSN: 2340-1117
doi: 10.21125/edulearn.2017.0276

Conference name: 9th International Conference on Education and New Learning Technologies
Dates: 3-5 July, 2017
Location: Barcelona, Spain

A STUDY ON THE EFFECT OF VISUALIZATION IN TEACHING ENTITY-RELATIONSHIP DIAGRAM (ERD) TO RELATIONAL SCHEMA MAPPING

L. Yang, L. Cao

University of West Georgia (UNITED STATES)
Database design at the conceptual level using the Entity-Relationship (ER) model is often a difficult and complex task for novices. The subsequent step to map a conceptual data model to a logical one (e.g. relational data model) is not easy for beginners, either. Our experience with first-time learners shows that they often mechanically follow the mapping algorithms to perform the conversion without fully understanding the principles behind it. The end result is often wrong or incomplete. There seems to be a gap between their perceptions of the conceptual model and the logical model, which hinders their understanding of the mapping. This paper presents a study that evaluates the effect of a visualization tool, MySQL Workbench, in helping students advance their understanding and performance on mapping an Entity-Relationship Diagram (ERD) to a relational schema. Our study shows that a visualization tool like MySQL Workbench made learning more fun and students more engaged in the learning process, though some complained about the learning curve of the tool. Through the tool, students were able to see a connection between the two models, which helped them improve their performance on some mapping aspects. Our survey shows that, inadvertently, the tool also helped some students gain a better understanding of the conceptual data model. Based on our experience, the paper also presents recommendations on how to use the tool more effective in teaching ERD-relational schema mapping.
@InProceedings{YANG2017AST,
author = {Yang, L. and Cao, L.},
title = {A STUDY ON THE EFFECT OF VISUALIZATION IN TEACHING ENTITY-RELATIONSHIP DIAGRAM (ERD) TO RELATIONAL SCHEMA MAPPING},
series = {9th International Conference on Education and New Learning Technologies},
booktitle = {EDULEARN17 Proceedings},
isbn = {978-84-697-3777-4},
issn = {2340-1117},
doi = {10.21125/edulearn.2017.0276},
url = {http://dx.doi.org/10.21125/edulearn.2017.0276},
publisher = {IATED},
location = {Barcelona, Spain},
month = {3-5 July, 2017},
year = {2017},
pages = {7219}}
TY - CONF
AU - L. Yang AU - L. Cao
TI - A STUDY ON THE EFFECT OF VISUALIZATION IN TEACHING ENTITY-RELATIONSHIP DIAGRAM (ERD) TO RELATIONAL SCHEMA MAPPING
SN - 978-84-697-3777-4/2340-1117
DO - 10.21125/edulearn.2017.0276
PY - 2017
Y1 - 3-5 July, 2017
CI - Barcelona, Spain
JO - 9th International Conference on Education and New Learning Technologies
JA - EDULEARN17 Proceedings
SP - 7219
EP - 7219
ER -
L. Yang, L. Cao (2017) A STUDY ON THE EFFECT OF VISUALIZATION IN TEACHING ENTITY-RELATIONSHIP DIAGRAM (ERD) TO RELATIONAL SCHEMA MAPPING, EDULEARN17 Proceedings, p. 7219.
User:
Pass: