JCL

FEUP/DEI & INESC TEC

User Tools

Site Tools


teach:lbaw:labs:07

Table of Contents

P: 22/03/2021

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


Practical work #7 :: Week of 22/03/2021

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
  • Configure access to the group's account at dbm.fe.up.pt (password given in class)

Summary

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

LBAW, 2020/21

« Previous | Index | Next »

teach/lbaw/labs/07.txt · Last modified: 26/03/2021 14:42 by Correia Lopes