DBIS Relational Algebra Exercise Generator

This library generates relational algebra exercises based on the dbis-relational-algebra library.

Installation

Install via pip:

pip install dbis-relational-algebra-exercise-generator

Most notably, following required packages are also installed:

• dbis-relational-algebra
• dbis-exc-manager

Usage

from ra_exercise_generator import generate_exercise

from relational_algebra import *
solution_algebra_expression = Projection("R", ("R.a", "R.c"))

from excmanager.Task import Exercise, Task, SubTask
exercise1 = Exercise(1)
task1 = Task(exercise1, "1.1")
subtask1 = SubTask(task1, "a", points=2)
# task description
description = "Select the attributes a and c from the relation R."

generated_cells = generate_exercise(
	subtask1,
	description,
	solution_algebra_expression,
	correct_attributes_score_perc=0.1
)

# generated_cells is a dictionary of cells, which can be used to generate a Jupyter Notebook
# format:
# filename (str) -> cell content (str)

⚠️ Guidelines

In order to directly use the generated cells in an exercise Jupyter notebook, one should follow the following guidelines:

• tasks should be named task1, task2, ...
• The SQLite Connection has to be made beforehand. This connection should be stored in the variable sql_con.

View the templates and this test for more information on what cells are generated and how one can incorporate them into an exercise Jupyter notebook.