Lecture 3: The Relational Model

Title slideToday’s lecture expanded on last week’s material on Entity-Relationship modelling, and then set out the basic elements of the Relational Model for structured data. While ER diagrams provide a conceptual language for describing things as they are, and have applications outside databases for general organisation and management, the relational model is explicitly intended as a mathematically precise scheme for the computer-assisted creation and querying of large datasets.
Continue reading Lecture 3: The Relational Model

Lecture Slides Online

The slides for each Inf1-DA lecture are available in advance from the Lectures web page. On the day of the lecture you’ll see them marked “(Handout)” as that’s the version in the 3-up printed sheets. After the lecture itself I put up a blog post with a copy of the slides as displayed — sometimes that has a few more bits and pieces included.

Sometimes this means the page changes faster than web and browser caches expect: if you can’t get the slides for the day, try refreshing.

Link: List of lectures so far