The Relational Model + Relational Algebra

This module covers the fundamentals of relational databases, namely the relational model and relational algebra.  We begin with a quick review of set theory (upon which the relational model is based) followed by an overview of the relational model introducing all major concepts (schema, relation, valid database state, integrity constraints). Finally, the lecture covers the computational operations of the relational model, namely its relational algebra. This sets a solid ground for further understanding the foundations upon which classic, modern, and future database management systems are based on.

The content is based on either :

• chapters 5 and 8 (up until 8.5) of the main course textbook.
• chapter 2 of the alternative textbook (database system concepts)

Slides are also available in pdf Download pdf.

Live Zoom recording (2021) here. Links to an external site.

Pre-recorded (condensed) video (2020):