The Effect of MySQL Workbench in Teaching Entity-Relationship Diagram (ERD) to Relational Schema Mapping

Full Text (PDF, 432KB), PP.1-12

Views: 0 Downloads: 0

Author(s)

Li Yang 1,* Li Cao 2

1. University of West Georgia/ Department of Computer Science, Carrollton, GA, USA

2. University of West Georgia, Carrollton/Department of Educational Technology and Foundations, GA, USA

* Corresponding author.

DOI: https://doi.org/10.5815/ijmecs.2016.07.01

Received: 11 Apr. 2016 / Revised: 12 May 2016 / Accepted: 2 Jun. 2016 / Published: 8 Jul. 2016

Index Terms

Entity-relationship model, relational model, relational schema, entity-relationship diagram, visualization, ERD-relational schema mapping

Abstract

While designing a database at the conceptual level using the Entity-Relationship (ER) model is challenging for novices, mapping an Entity-Relationship Diagram (ERD) to a relational schema is not an easy task, either. One of the problems is students’ lack of understanding of the underlying mapping principles. The mental gap between the two models in students also makes it difficult for them to perform the conversion. This paper describes two studies that aimed at helping students fill the gap and improve their ERD-Relational schema mapping performance by the use of a visualization tool, MySQL Workbench. We investigated the effect of using MySQL Workbench in teaching ERD-Relational schema mapping. We identified the pros and cons of using visualization in teaching the topic. Our results show that visualization can increase student interest and engagement, and facilitate students connecting the concepts in the two models. With an instructional delivery method that emphasizes the underlying mapping principles, a visualization tool could help undergraduate students improve their performance on ERD-relational schema mapping and facilitate their understanding of the ER model.

Cite This Paper

Li Yang, Li Cao, "The Effect of MySQL Workbench in Teaching Entity-Relationship Diagram (ERD) to Relational Schema Mapping", International Journal of Modern Education and Computer Science(IJMECS), Vol.8, No.7, pp.1-12, 2016. DOI:10.5815/ijmecs.2016.07.01

Reference

[1]Computer Science Curricula 2013 report, http://ai.stanford.edu/users/sahami/CS2013/final-draft/ CS2013-final-report.pdf, retrieved March 28, 2016.
[2]Ahrens, J., & Song, I., EER data modeling aids for novice database designers. Proceedings of the 2nd Int. Conf Information Resources Association, 99-114, 1991.
[3]Barrows, H. S. (1996). Problem-based learning in medicine and beyond: A brief overview. New Directions for Teaching and Learning, 1996(68): 3–12, doi:10.1002/tl.37219966804.
[4]Batra, D., & Antony, S. R. (1994). Novice errors in conceptual database design. European Journal of Information Systems, 3(1), 57-69.
[5]Batra, D., & Davis, J. (1992). Conceptual data modeling in database design: similarities and differences between expert and novice designers. International Journal of Man-Machine Studies, 37, 83-101.
[6]Ben-Ari, M., Bednarik, R., Levy, R.B., Ebel, G., Moreno, A., Myller, N., & Sutinen, E. (2011). A decade of research and development on program animation: The Jeliot experience. Journal of Visual Languages and Computing, 22, 375-384.
[7]Bergin, J., Brodie, K., Patino-Martinez, M., McNally, M., Naps, T., Rodger, S … Jimenez-Peris, R. (1996). An overview of visualization: Its use and design: Report of the working group in visualization. Proceedings of the 1st Conference on Integrating Technology into Computer Science Education, 192–200.
[8]Cetin, I. (2013). Visualization: a tool for enhancing students’ concept images of basic object-oriented concepts. Computer Science Education, 23(1), 1-23.
[9]Chen, P. P. (1976). The entity-relationship model – toward a unified view of data. ACM Trans. Database Systems, 1(1), 9-36.
[10]Connolly, T., & Begg, M (2006). A constructivist-based approach to teaching database analysis and design, Journal of Information Systems Education, 17(1), 43-53.
[11]Connolly, T. M., MacArthur, E., Stansfield, M.H., & McLellan, E. (2007). A Quasi-experimental study of three online learning courses in computing. Journal of Computers and Education, 49(2), 345-359.
[12]Connolly, T., Stansfield, M., & McLellan, E (2006) Using an online games-based learning approach to teach database design concepts. The Electronic Journal of e-Learning,,4(1), 103-110.
[13]Doman M., Sleigh, M., & Garrison, C., (2015). Effect of GameMaker on student attitudes and perceptions of instructions, International Journal on Modern Education and Computer Science, 7(9), 1-13.
[14]Finkelstein, C. (1998). Information engineering methodology. In P. Bernus, K. Mertins & G. Schmidt (Eds.), Handbook on architectures of information systems (pp. 405-427). Berlin, Germany: Springer-Verlag.
[15]Gance, S. (2002). Are constructivism and computer-based learning environments incompatible? Journal of the Association for History and Computing, 1, May, 2002.
[16]Hall, L., & Gordon, A. (1998). A virtual learning environment for entity relationship modeling. SIGCSE 98, 345-349.
[17]Hoffer, J. (1982). An empirical investigation into individual differences in database model. Proceedings of 3rd Int. Conf. Information Systems, 153-167.
[18]Hoggarth, G.R., & Lockyer, M.A. (1996). Systems development methods guidance and CASE: integration between CASE and CAL. Software Engineering Journal, 11(3), 141-147.
[19]Holmboe, C. (2005). Conceptualization and labelling as cognitive challenges for students of data modelling. Computer Science Education, 15(2), 143-161.
[20]IS-2010, IS 2010 Curriculum Guidelines for Undergraduate Degree Programs in Information Systems, http://www.acm.org/education/curricula/IS%202010%20ACM%20final.pdf , retrieved March 28, 2016.
[21]Kolp, M., &Zimanyi, E. (2000). Enhanced ER to relational mapping and interrelational normalization. Information and Software Technology, 42, 1057–1073.
[22]Kreie, J., & Ernst, B. (2013). From database concepts to application: Use problem-based learning and Oracle development tools to facilitate learning. Proceedings of the Information Systems Education Conference, 2013.
[23]Mohtashami & Scher, 2000, Application of Bloom’s Cognitive Domain Taxonomy to Database Design, Proceedings of Information Systems Education Conference, 2000.
[24]Murray, M., & Guimaraes, M. (2009) Animated Courseware Support for Teaching Database Design, Issues in Informing Science and Information Technology, 6, 201-211.
[25]MySQL Workbench 6.3. Available from https://www.mysql.com/products/workbench/, retrieved March 28, 2016.
[26]Naps, T.L., Rößling, G., Almstrum, V., Dann, W., Fleischer, R., Hundhausen, C., … & Velázquez-Iturbide, J.Á. (2002). Exploring the role of visualization and engagement in computer science education. Proceedings of ITiCSE-WGR '02: Working group reports from ITiCSE on Innovation and technology in Computer Science Education, 131–152.
[27]Piaget, J. (1968), Six Psychological Studies, Vintage Books, New York.
[28]Sajaniemi, J., Byckling, P., & Gerdt, P. (2007). Animation metaphors for object-oriented concepts. Electronic Notes in Theoretical Computer Science, 178, 15–22.