DESwebuna herramienta para el aprendizaje de SQL

  1. Fernando Sáenz Pérez 1
  1. 1 Universidad Complutense de Madrid
    info

    Universidad Complutense de Madrid

    Madrid, España

    ROR 02p0gd045

Revue:
Actas de las Jornadas sobre la Enseñanza Universitaria de la Informática (JENUI)

ISSN: 2531-0607

Année de publication: 2019

Número: 4

Type: Article

D'autres publications dans: Actas de las Jornadas sobre la Enseñanza Universitaria de la Informática (JENUI)

Résumé

This paper presents the on-line tool DESweb for lear- ning the SQL database language. Though several data- base management systems, either proprietary or open- source, are used in teaching Databases, they provide li- mited feedback for incorrect queries. However, we are not only interested in providing better syntactic error messages, but also semantic error warnings. A seman- tic error is found when a syntactically-correct state- ment includes extra or missing tuples with respect to its intended meaning for the programmer. This work addresses these issues in an on-line, free, open-source, and widely-available system, which is currently being applied to several groups of the Databases course.