2 lectures & 1 Exercise class /
week. Check Timetable

** Lecturer**:
Dr Ata Kaban

Room: UG32

Email: A.Kaban 'at' cs.bham.ac.uk

Office hours: See my Timetable

- Weekly formative exercises for feedback and learning. Please hand in for comments and feedback.

- Admin; Introduction

- Review of SQL and
Relational Data Model. Lecture slides
- Relational
Algebra
- Exercise Sheet 3
– Model answers
- Exercise Sheet 4
– Model answers
**Class test 1: was Friday 14 February 10am-10:50 usual lecture venue; open book. Model answers**

- Entity-Relationship
Modelling. Lecture
Slides

- Logical Design
- Exercise Sheet 5 – Model answers 1; Model answers 2
- [Exercise Sheet 6
(optional) Reading material for optional exercise sheet: Chapter
9 of Yourdon's Structured Analysis text]
**Class Test 2 Here. Was due by Fri 7 March 11am. Model answer**

- Design
Theory of Relational Databases. Lecture Slides
- Designing for
Performance. Lecture
Slides
- B-tree animation
- Find
out more: [please read up on B and B+ tree indexing!]
- Overview
of Storage and Indexing, Chapter 8 of the Ramakrishnan
text, 3rd edition.
**Class Test 3 took place on Friday 21 March 10am-10:50 usual lecture venue; open book. Model answers**

- Transactions