Lecture Notes

Lecture notes will be published here during the course.

Important: the slides below do not cover everything that are said and given during the lectures. To get the full coverage, attend the lectures and read the Course Book.

• Lecture 1, Introduction [1pp,4pp,6pp]
• Lecture 2, E-R diagrams [1pp,4pp,6pp]
• Lecture 3, Functional Dependencies [1pp,4pp,6pp]
• Lecture 4, Normalisation [1pp,4pp,6pp]
• Lecture 5, Independencies, Design wrapup [1pp,4pp,6pp]
• Lecture 6, SQL DDL and DML. Queries and Relational Algebra [1pp,4pp,6pp]
• Lecture 7, SQL Queries cont., Views [1pp,4pp,6pp]
• Lecture 8, SQL Queries cont. [1pp,4pp,6pp]
• Lecture 9, SQL DML and DDL, Assertions and Triggers [1pp,4pp,6pp]
• Lecture 10, SQL/PSM, Embedded SQL, JDBC [1pp,4pp,6pp]
• Lecture 11, Transactions, Authorization [1pp,4pp,6pp]
• Lecture 12, Optimization, Indexes, Non-natural keys [1pp,4pp,6pp]
• Lecture 13, Semi-structured data, XML [1pp,4pp,6pp]
• Lecture 14, Database Systems, RDBMSs, NoSQL [1pp,4pp,6pp]
• Lecture 15, Course overview [1pp,4pp,6pp]