The University of Birmingham - School of Computer Science

Databases 2

Spring Term 2013

Classes

2 lectures & 1 Exercise class / week. Check Timetable

Staff Details

Lecturer: Dr Ata Kaban
Room: UG32
Email: A.Kaban 'at' cs.bham.ac.uk
Office hours: See my Timetable

Demonstrator: Momodou Sanyang

Structure

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

- 3 assessed class tests = total 20% of final mark. Each will be announced by email a week in advance.

- Written exam = 80% of final mark

Lecture Notes and Exercises

General Information about the Module

• Admin; Introduction
  
  
• Review of SQL and Relational Data Model. Lecture slides
• Exercise Sheet 1 Model Answers
• Exercise Sheet 2 Model Answers
  
  
• Relational Algebra
• Exercise Sheet 3 Model Answers
  
  
• Class test 1 Model answers Marks
  
  
• Exercise Sheet 4 Model Answers
  
  
• Entity-Relationship Modelling. Lecture Slides
  
  
• Logical Design
• Exercise Sheet 5 Model solutions Part 1 Part2
• [Exercise Sheet 6 (optional) Reading material for optional exercise sheet: Chapter 9 of Yourdon's Structured Analysis text]
  
  
• Class Test 2
  
  
• Design Theory of Relational Databases. Lecture Slides
• Exercise Sheet 7. Model Answers
• Exercise Sheet 8. Model Answers
  
  
• 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 – due in by Friday 22^nd March, lecture time.
  
  
• Transactions
• Exercise Sheet 9
  
  

Resources

• Local PostgreSQL installation
• PostgreSQL Complete Documentation
• SQL Tutorial
• SQL Syntax etc.
• SQL Commands
• psql Reference Manual
• Homepage of the course textbook by Ramakrishnan and Gehrke
• Just Enough Structured Analysis, by Edward Yourdon
• Structured Analysis Wiki (based on Ed Yourdon's book above)

Module Description and Syllabus

Induction slides