Lecture Notes

Lecture notes will be published here during the course.

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

• Lecture 1, Introduction
• Lecture 2, Design 1 E-R diagrams
• Lecture 3, Design 2 Functional Dependencies
• Lecture 4, Design 3 Normalisation
• Lecture 5, Database Construction 1 SQL DDL and DML. Relational Algebra
• Lecture 6, Database Usage 1 SQL Queries and Relational Algebra
• Lecture 7, Database Usage 2 More SQL Queries and Relational Algebra
• Lecture 8, Database Construction 2 More on Modifications and Table Creation. Assertions, Triggers
• Lecture 9, Database Applications SQL/PSM, Embedded SQL, JDBC (some extra slides on Embedded SQL and ODBC)
• Lecture 10, Database Usage 3 Transactions and Authorization
• Lecture 11, XML
• Lecture 12, Indexes
• Lecture 13, Summary