polito.it
Politecnico di Torino (logo)

DesignQT: a web-based application for interactive and computer-assisted learning of Relational Algebra

Santa Panduri

DesignQT: a web-based application for interactive and computer-assisted learning of Relational Algebra.

Rel. Silvia Anna Chiusano, Alessandro Fiori, Andrea Avignone. Politecnico di Torino, Corso di laurea magistrale in Ingegneria Informatica (Computer Engineering), 2023

Abstract:

The objective of the thesis is the development of DesignQT, an application for the study and the teaching support in Relational Algebra that provides the theoretical basis for relational databases and query languages ​​to interact with them. The available applications mainly support the graphical creation of the models but not the representation of tables and operators to build the query trees in the context of Relational Algebra. At first instance, the tool’s purpose is to provide a design method that complies with the study and formalisms of Relational Algebra. Additionally, it aims to be an assisted guide to the in-depth study of the subject through the construction of formally correct query trees satisfying all the imposed constraints. Since the final consumer is the user, great attention has been paid to the interaction and the user experience with the product. For each operation, the possible permitted actions are shown while the attempt to violate the constraints will not be allowed and consequently, the relative error will be displayed. In addition to the final outcome, the tool has been designed to show all the intermediate results in order to make the learning process more explanatory.

Relators: Silvia Anna Chiusano, Alessandro Fiori, Andrea Avignone
Academic year: 2022/23
Publication type: Electronic
Number of Pages: 99
Additional Information: Tesi secretata. Fulltext non presente
Subjects:
Corso di laurea: Corso di laurea magistrale in Ingegneria Informatica (Computer Engineering)
Classe di laurea: New organization > Master science > LM-32 - COMPUTER SYSTEMS ENGINEERING
Aziende collaboratrici: Politecnico di Torino
URI: http://webthesis.biblio.polito.it/id/eprint/26828
Modify record (reserved for operators) Modify record (reserved for operators)