Moodle-Based Tool to Improve Teaching and Learning of Relational Databases Design and SQL DML Queries

The challenge to prepare the graduates for working in a constantly changing environment like software engineering requires an effective learning framework. This chapter presents a tool, integrated in the Moodle learning management system, that allows students to train the process of designing relational databases. The tool also allows them to practice with SQL queries that are executed over relational databases previously designed. This chapter also describes the result of a qualitative analysis of its use in an engineering course offered at the University of Valladolid and focused on the teaching of the Web applications development. The results of the refereed study reveal that the tool was found useful by both students and teachers to support the teaching and learning process of relational databases.

[1]  Eldon Y. Li,et al.  Multimedia learning system and its effect on self-efficacy in database modeling and design: an exploratory study , 2003, Comput. Educ..

[2]  Baghdad Atmani,et al.  Applying CBR Over an AI Planner for Dynamic Web Service Composition , 2013, Int. J. Inf. Technol. Web Eng..

[3]  Mohammad Bsoul,et al.  Cluster-Based Online Routing Protocols for Ad Hoc Network , 2014, Int. J. Inf. Technol. Web Eng..

[4]  Victor C. S. Lee,et al.  Learning motivation in e-learning facilitated computer programming courses , 2010, Comput. Educ..

[5]  Francisco Javier Díaz Pernas,et al.  Moodle-Based Software to Support the Learning of Web Programming , 2012, Int. J. Knowl. Soc. Res..

[6]  Khalid T. Al-Sarayreh,et al.  A Novel Approach to Build a Generic Model of Photovoltaic Solar System Using Sound Biometric Techniques , 2014, Int. J. Inf. Technol. Web Eng..

[7]  Zakaria Maamar,et al.  Aspect-Oriented Framework for Web Services (AoF4WS): Introduction and Two Example Case Studies , 2009 .

[8]  M. Mercedes Martínez-González,et al.  Teaching databases in compliance with the European dimension of higher education: Best practices for better competences , 2007, Education and Information Technologies.

[9]  Tomayess Issa,et al.  Artificial Intelligence Technologies and the Evolution of Web 3.0 , 2015 .

[10]  Fulvio Frati,et al.  Open Source in Web-Based Applications: A Case Study on Single Sign-On , 2006, Int. J. Inf. Technol. Web Eng..

[11]  Johannes D. Veldhuis,et al.  NPY neurons as a critical hypothalamic node for the control of GH release relative to food intake , 2014 .

[12]  Arthur Tatnall.  Web Technologies: Concepts, Methodologies, Tools and Applications , 2010 .

[13]  Clare Churcher.  Beginning Database Design: From Novice to Professional , 2007 .

[14]  S. Esakkirajan,et al.  Fundamentals of relational database management systems , 2007 .

[15]  Pete Thomas,et al.  How Students learn to program: Observations of practical work based on tasks completed , 2000 .

[16]  Baltasar Fernández-Manjón,et al.  Learning teamwork skills in university programming courses , 2009, Comput. Educ..

[17]  César Domínguez,et al.  Database design learning: A project-based approach organized through a course management system , 2010, Comput. Educ..