J. Correia Lopes

FEUP/DEI & INESC TEC

User Tools

Site Tools


teach:lbaw:labs:07

Table of Contents

P: 25/03/2019

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


Practical work #7 :: Week of 25/03/2019

Goals

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

  • Identify and create constraints needed to verify the business rules
  • Estimate the expected database workload
  • Develop the database Physical Schema
  • Create and populate a PostgreSQL database

Materials

Tasks

  • Present the artefact A5 (Relational Schema, validation and schema refinement).
  • Identify and create constraints needed to verify the business rules, including triggers.
  • Estimate the expected database workload.
  • Identify and justify the creation of indexes.
  • Create the database using PostgreSQL.
  • Populate the database with plausible data and with sufficient number of tuples for testing purposes.

Summary

  • Integrity constraints and triggers. PostgreSQL database. Presentation of the artefact A5 (Relational Schema, validation and schema refinement).1)

LBAW, 2018/19

« Previous | Index | Next »

1)
Verificação de regras de integridade. Criação da base de dados em PostgreSQL. Apresentação do artefacto A5 (Esquema Relacional. Validação e afinação do esquema).
teach/lbaw/labs/07.txt · Last modified: 24/03/2019 10:52 by Correia Lopes