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 (one per page, six per page)
• Lecture 2, Design 1 E-R diagrams (one per page, six per page)
• Lecture 3, Design 2 Functional Dependencies (one per page, six per page)
• Lecture 4, Design 3 Normalisation (one per page, six per page)
• Lecture 5, Database Construction 1: SQL DDL and DML. Relational Algebra (one per page, six per page)
• Lecture 6, Database Usage 1: SQL Queries and Relational Algebra (one per page, six per page)
• Lecture 7, Database Usage 2: More SQL Queries and Relational Algebra (one per page, six per page)
• Lecture 8, Database Construction 2: More on Modifications and Table Creation. Assertions, Triggers (one per page, six per page)
• Lecture 9, Database Applications SQL/PSM, Embedded SQL, JDBC (one per page, six per page)
  (some extra slides on Embedded SQL and ODBC)
• Lecture 10, Database Usage 3: Transactions and Authorization (one per page, six per page)
• Lecture 11, Indexes; XML (one per page, six per page)
• Lecture 12, Querying XML (one per page, six per page)
• Lecture 13, Revision

• Solutions and notes on questions in the lecture slides