Mondays, 2:00-2:50pm

Fridays, 10:00-10:50am

[check Timetable]

Thursdays 10:00-10:50am

[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.

- Admin; Introduction

- Review of SQL and
Relational Data Model, Lecture slides
- Relational
Algebra
- Exercise Sheet 3 Model solutions.
- Mock
test on Friday 6 February Test questions
Model
solutions
**Class Test 1 was on Monday 9**^{th}February, lecture time, lecture venue.- Exercise Sheet 4 Model solutions

- Entity-Relationship
Modelling. Lecture
Slides
- Logical Design
- Exercise Sheet 5 Model solutions -
diagrams Model
solutions – create table
- Optional
material: Data
flow modelling Exercise
Sheet 6 (optional) Model solutions +
diagram
**Class Test 2 = Take-home test on ER / Extended ER modelling. Model Solutions.**

- Design
Theory of Relational Databases. Lecture Slides
- Designing for
Performance. Lecture
Slides
- B-tree animation
- Find
out more:
- Overview
of Storage and Indexing, Chapter 8 of the Ramakrishnan
text, 3rd edition.
**Class Test 3 as on**Friday 20 March.**Model Solutions.**

- Transaction Management
– an Overview (this is not on the test but it is needed for
exam!!)
- Exercise Sheet 9
(solution included at the end of the file)

- Topics on
handling Large Scale database systems (not for exam)