David Hume Tower Lecture Theatre A
Tuesday 1110–1200
Friday 1410–1500

Inf1-DA lectures are twice weekly throughout Semester 2 in the lecture halls behind David Hume Tower (DHT). To participate in the course you should attend all lectures and carry out the homework set between them.

Links: David Hume Tower (Map); Lecture Theatre A

Lecture Log

Lecture handout PDF will appear here before the lecture itself; after the lecture I’ll post a blog entry with slides and references, then link to that instead.


  1. Course Overview

Part I: Structured Data

  1. Entities and Relationships
  2. The Relational Model
  3. From ER Diagrams to Relational Models
  4. Relational Algebra
  5. Tuple Relational Calculus
  6. SQL
  7. SQL Queries

Part II: Semistructured Data

  1. Trees and XML
  2. Structuring XML

Part III: Unstructured Data


      Q. What did you find most valuable about the course?

      A. Great lectures, informative and interesting.

      — Anonymous student giving feedback in a previous year.