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
**Class Test 1 on Friday 12 February, at the time & venue of our usual class. Open book. Model solutions & Feedback**- Exercise Sheet 4
– Model
solutions

- Entity-Relationship
Modelling. Lecture
Slides
- Logical Design
- Extended
ER modelling & translating to tables: Exercise Sheet 5 -- Model solutions part
1; Model
solutions part 2
**Test 2: Take home test is here**- [[
Optional material: Data
flow modelling Exercise
Sheet 6 (optional) ]]

- Design
Theory of Relational Databases. Lecture Slides
- Designing for
Performance. Lecture
Slides

More on Indexing - B-tree animation

**Mock test + Model solutions****Class test on Friday 18 March. Model solutions & Feedback**

- Transaction Management
– an Overview