

3. Internals

Sqltutor schema is design to enable multiligual translations of tutorial questions with common problem atributes and SQL solutions (anwers). For a given problem one or more questions can be defined with one or more possible solutions. A dataset is a set of problems with given point evaluation and a common set of tables. Tutorials are defined as selections of datasets.


Figure 3.1: Sqltutor database schema

Tutorials, datasets and problems are defined in SQL language with a set of stored procedures. An example of how to define a dataset is given a file compute_store.sql with description of all steps in the comments.
