Diseño de bases de datos relacionales con DBDStudio

  1. Jesús M. Jorge Santiso 1
  2. Pavel Nichita 1
  1. 1 Universidad de La Laguna
    info

    Universidad de La Laguna

    San Cristobal de La Laguna, España

    ROR https://ror.org/01r9z8p25

Revista:
Actas de las Jornadas sobre la Enseñanza Universitaria de la Informática (JENUI)
  1. Marco Galindo, María Jesús (coord.)
  2. Bañeres, David (coord.)
  3. Marco Simó, Josep Maria (coord.)

ISSN: 2531-0607

Año de publicación: 2018

Número: 3

Tipo: Artículo

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

Resumen

In this paper we present DBDStudio, a software tool, developed as a web-app. The goal is to assist in the analysis and design of relational databases based on functional dependencies. Among others, the app allows to compute keys, closure of attribute sets, minimal cover, detect and normalize till 3NF (third normal form) and BCNF (Boyce and Codd normal form). We think this tool is valuable as a teaching resource for who are involved in the training of relational database design. The tool provides great help for the students, making easier learning the theoretical notions thanks to the different implement- ed algorithms.