[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

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.

fig/schema

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.


This document was generated by Ales Cepek on January 18, 2018 using texi2html 1.82.