Lecture Notes and Exercises

• Handout 1, Introduction to Databases, 27 September 2011.
  • Exercise Sheet 1, 29 September 2011. Solutions
  • Exercise Sheet 2, 6 October 2011. Solutions
  • Exercise Sheet 3, 13 October 2011. Solutions
  • Class Test 1, 27 October 2011. Solutions
• Handout 2, on Entity-Relationship Modelling, 18 October, 2011.
• Handout 2a, on Logical Design, 5 November, 2011.
  • Exercise Sheet 4 , 20 October 2011. Solutions: ER diagrams
  • Exercise Sheet 5 , 5 November 2011. Solutions: Questions 10 and 12, Question 11
  • Exercise Sheet 5A , 10 November 2011.
  • Class Test 2, 17 November 2011. Solutions (partial)
• Handout 3, on Relational Model, 15 November 2011.
• Handout 3a, on Design theory of relational databases, 22 November 2011.
  • Exercise Sheet 6, 24 November 2011. Solutions
  • Exercise Sheet 7, 1 December 2011. Solutions
  • Class Test 3, 8 December. Solutions
• Handout 4, on Designing for Performance, 7 December, 2011.

Class Schedule

• Week 1: 9:00-10:00, LT 2, Law Building.
• Weeks 2-3: 9:00-10:00, LT 2, Law Building and 10:00-11:00, B23 Mech Eng.
• Week 4: 10:00-11:00, UG 04 Learning Centre.
• Weeks 5-8: 10-11:00, LT 2, Law.
• Week 9-11: 10:00-11:00, WG 5, Aston Webb.

Resources

• PostgreSQL downloads for home use.
• Virtual Private Network (VPN) set-up for home use.
• School page on PostgreSQL
• Creating an account on the School's DBMS 'dbteach'
• PostgreSQL Complete Documentation
  • SQL Tutorial
  • SQL Syntax etc.
  • SQL Commands
  • psql Reference Manual
• Homepage of the textbook by Ramakrishnan and Gehrke

Staff Details

Tutor/demonstrator: Funmilade "Funmi" Faniyi
Room 121
Tel: (+44) 121 414 8201
Email: fof861 'at' cs.bham.ac.uk

Tutor/demonstrator: Guanzhou Lu
Room 218
Tel: (+44) 121 414 3736
Email: G.Lu 'at' cs.bham.ac.uk

demonstrator: Himanshu Chaudhary
Email: hxc117 'at' cs.bham.ac.uk

demonstrator: Irfan Subakti
Email: mis157 'at' cs.bham.ac.uk

Module Description and Syllabus

General Information about the Module