Lecture Notes and Exercises

General Information about the Module

• Handout 1, on Review of SQL, 1 October 2009.
  • Exercise Sheet 1, 1 October 2009.
  • Exercise Sheet 2, 8 October 2009.
• Handout 1A, on Relational Model, 15 October 2009.
  • Exercise Sheet 3, 15 October 2009.
  • Class Test 1, 22 October 2009.
  • Exercise Sheet 4, 29 October 2009.
• Handout 2, on Entity-Relationship Modelling, 29 October, 2009.
• Handout 2a, on Logical Design, 5 November, 2009.
  • Exercise Sheet 5 , 5 November 2009.
  • Exercise Sheet 6 , 12 November 2009. Solutions: text
  • For Functional Analysis using the dataflow diagram technique, see the Chapter 9 of Yourdon's Structured Analysis text.
  • Class Test 2 (Take-home), 20 November 2009.
• Handout 3, on Design Theory of Relational Databases, 19 November, 2009.
  • Exercise Sheet 7, 26 November 2009.
  • Exercise Sheet 8, 3 December 2009.
  • Class Test 3.
• Handout 3, on Designing for Performance, 3 December, 2009.
  • B-tree animation (brought to you by "slady")
  • Additional material to study:
    • Overview of Storage and Indexing, Chapter 8 of the Ramakrishnan text, 3rd edition.

  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)

  Staff Details

  Professor Uday Reddy
  Room 210
  Tel: (+44) 121 414 2740
  Email: U.S.Reddy 'at' cs.bham.ac.uk
  Office hours: Tue 4:30-5:30, Thu 2:00-3:00, and by appointment at other times (see online timetable)

  Tutor/demonstrator: Ali Al Rodan
  Room 118
  Tel: (+44) 121 414 8003
  Email: A.A.Rodan 'at' cs.bham.ac.uk
  Office hours: Wed 10:30-11:30

  Lectures

  Thursdays, 10:00-10:50am, G34, Mech Eng
  Fridays, 10:00-10:50am, G34, Mech Eng

  Exercise Class

  Thursdays, 1:00-1:50pm, G17, Nuffield Building

  (For the first two weeks, the exercises will be done on the computer, in the ground floor lab in Computer Science.)

  Module Description and Syllabus

  General Information about the Module