Master in Informatics and Computing Engineering
Database and Web Applications Laboratory
Practical work #7 :: Week of 25/03/2019
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
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.
Integrity constraints and triggers. PostgreSQL database. Presentation of the artefact A5 (Relational Schema, validation and schema refinement).1)
— LBAW, 2018/19
« Previous | Index | Next »