COMP3311 24T2 - Exercises

Exercises

Database Systems

Data Modelling, ER Model, Relational Model

Relational Model, SQL DDL, ER→SQL Mapping

SQL: Constraints, Updates, Queries, Views

Stored Functions in SQL and PLpgSQL

Constraints, Triggers, Aggregates, Catalogs

Programming with Databases (Python)

Relational Design Theory, Normalization

Relational Algebra, Query Execution

More to come ...