JCL

FEUP/DEI & INESC TEC

User Tools

Site Tools


teach:lbaw:labs:07

Table of Contents

P: 23/03/2020

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


Practical work #7 :: Week of 23/03/2020

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
  • Identify the database transactions
  • 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
  • Identify and characterise the necessary database transactions
  • 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. Database transactions. PostgreSQL database. Presentation of the artefact A5 (Relational Schema, validation and schema refinement).1)

LBAW, 2019/20

« 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: 20/03/2020 15:59 by Correia Lopes