Module: The relational model of data

Relations, tables, schemas, sets, cardinality.

Prerequisite Modules

Binary relations, n-ary relations, closures, equivalence relations, partial ordering, relational databases.

You understand what is the relational model
You can conceptualize data using the relational model.
You understand what basic relational algebra operators under set semantics.
You can express queries using relational algebra.
You can create tables using SQL DDL
You understand integrity constraints
You can specify primary key and foreign key constraints in CREATE TABLE statements

The relational model of data

50 pages

Relations, schemas, relational operators

Lecture Notes

CREATE TABLE statements, primary keys & foreign keys

Lecture Notes

Write relational algebra expressions

Write schemas in SQL