Applied Databases 2010

Notices (please check often)

• Homeworks have answers in them

• Date for final examination is Friday 17^th December (but see below)

If you want to subscribe to the Scottish Database Group email list, go to the following page: http://lists.inf.ed.ac.uk/mailman/listinfo/scotland-db

Time and place

Wednesdays 9am -- 10:50am, 7 George Square, S1.

Instructor

Peter Buneman, LFCS, 5.15 Informatics Forum. Email: opb at inf dot ed dot ac dot uk
Office Hours: Wednesdays, 11am-noon

Lab Web Page

http://homepages.inf.ed.ac.uk/ntang/ad/

Lab Times

Wednesday 12pm-1pm AT 4.12,

Wednesday 1pm-2pm AT 4.12

Lab Instructor

Nan Tang ntang at inf dot ed dot ac dot uk

Course textbook:
Database Management Systems by Ramakrishnan and Gehrke

Assessment

Please note that the exam for this course is in December, at the end of term

• Coursework for a total of 30%

• Final exam (short essays and questions) 70%

Database support contact details:

pgsql-admin@inf.ed.ac.uk

Lecture notes

• First set(introduction, relational model, SQL, relational algebra) in tree-friendly pdf or full-size pdf

• Second set (database design) in tree-friendly pdf or full-size pdf

• 2a. Functional Dependencies and Normal Forms in tree-friendly pdf or full-size pdf

• 3. Storage and Indexing in tree-friendly pdf or full-size pdf

• 4. Query optimisation in tree-friendly pdf or full-size pdf

• 5. XML in tree-friendly pdf or full-size pdf

Coursework

• Assignment 1, due Friday 22^nd October

  In Question 3 of the project part of this assignment you should answer the questions against the old (given) database – not the one you are designing. My apologies for advising some students otherwise. If you have started to try to populate the database you are designing, your work is not wasted. You will need to do this on a subsequent part of the project!

• Assignment 2, due Friday 12^th November

• Assignment 3, due Thursday 2^nd December

Final examination

Please double-check here. The web site currently has