Learning Environment for Automatic Rating Notions of SQL. LEARN-SQL

Goal

LEARN-SQL is a tool whose main goal is helping in learning the use and design of relational databases in different subjects of schools of the UPC (see current usage). More, specific goals are to:

  • Provide the possibility to define virtual laboratories or remote questionaires to be solved by the students at class or at home. 
  • Facilitate the participation of the students in its self-learning of database subjects.
  • Provide students with valuable feedback, so that they can learn from their mistakes.
  • Automatically evaluate the correctness of any SQL statement (queries, updates, stored procedures, triggers etc.) and other relational databases related exercices (Relational Algebra) with independence of the student solution.
  • Help teachers define the questions or items in the remote questionaires as well as allow them to review the solutions provided by the students.
  • Adapt the subjects where it is used to the European Higher Education Area (EHEA) and to innovative education methodologies.

 

A comparison with other systems that have similar goals can be found in:

Abelló, A., Burgués, X., Casany, M., Martín, C., Quer, C., Rodríguez, M. Elena, Romero, O., Urpí, T. A software tool for e-assessment of relational database skills. "International journal of engineering education", 1 Gener 2016, vol. 32, núm. 3A, p. 1289-1312.