J. Correia Lopes

FEUP/DEI & INESC TEC

User Tools

Site Tools


teach:lbaw:labs:06

Table of Contents

P: 18/03/2019

Master in Informatics and Computing Engineering
Database and Web Applications Laboratory
Instance: 2018/2019


Practical work #6 :: Week of 18/03/2019

Goals

By the end of this class, the student should be able to:

  • Develop the Relational schema from the Conceptual schema.
  • Ensure that the Relational schema is in the Boyce-Codd normal form (BCNF).
  • Document the Relational database schema.

Materials

Tasks

  • Present the artefact A4 (Conceptual Data Model).
  • Map the classes and relationships of the conceptual schema into relation schemas.
  • For each relation, identify the functional dependencies (FD) that apply, according to the semantics of the application, and get the minimum coverage.
  • If the relation is not in BCNF and there are no other impediments, look for several possible decompositions (lossless) in relations in BCNF and choose the "best decomposition" (which preserves more dependencies, that makes more sense, etc. ).
  • If there is no satisfactory decomposition to BCNF and if the relation is no longer in 3NF, consider the decomposition lossless for 3NF, preserving the functional dependencies.

Summary

  • Obtain the Relational Schema. Normalisation and Schema Refinement. Relational Schema Documentation. Presentation of artefact A4 (Conceptual Data Model).1)

LBAW, 2018/19

« Previous | Index | Next »

1)
Obtenção do Esquema Relacional. Refinamento e Normalização do Esquema Relacional. Documentação do Esquema Relacional. Apresentação do artefacto A4 (Modelo Conceptual de Dados).
teach/lbaw/labs/06.txt · Last modified: 20/03/2019 11:28 by Correia Lopes