Recommended texts:

  1. •R. Elmasri, and S.B. Navathe: Fundamentals of Database Systems (5th Edition and above). Addison Wesley.

  2. •M. Kifer, A. Bernstein, and P.M. Lewis: Database Systems: An Application-Oriented Approach. Addison Wesley.

  3. •H. Garcia-Molina, J.D. Ullman, and J. Widom: Database Systems - The Complete Book . Prentice Hall.


Other useful texts:

  1. •Ullman &Widom: Database Systems - The Complete Book . Prentice Hall.

  2. •Connolly & Begg. Database systems. Addison Wesley.


Aims:

This module aims at introducing students to:

  1. •the problems arising from concurrency in databases, and how they are solved;

  2. •the problems involved in the integration of heterogeneous sources of information and semi-structured data;

  3. •non-relational databases;

  4. •techniques for analysing large amounts of data.


Learning outcomes:

At the end of the modules students should be able to:

  1. •identify and apply the principles underpinning transaction management within DBMS;

  2. •demonstrate an understanding of advanced SQL topics;

  3. •illustrate the issues related to Web technologies and DBMS and XML as a semi-structured data representation formalism;

  4. •identify the principles underlying object relational models;

  5. •state the main concepts in data warehousing and data mining.


Teaching and learning strategies:

Formal Lectures: In a typical week, students will be expected to attend three hours of formal lectures, to introduce students to the concepts and methods covered by the module.

Practicals and Tutorials: In a typical week, students will be expected to attend one hour of tutorials or computer lab practicals.

Private study: In a typical week students will be expected to devote about 6 hours of unsupervised time to private study. Private study will provide time for reflection and consideration of lecture material, background reading and completion of the assessment tasks.

Assessment: Continuous assessment will be used to test to what extent practical skills have been learnt. A final examination at the end of the module will assess the academic achievement of students.


Course notes:

Printed course notes are available from the Helpdesk. Updated versions of the slides will appear be published online before the lectures.



Valentina Tamma

Last modified: Mon Sept 26th, 2011

Lecturer:

Dr Valentina Tamma


Learning resources:

  1. • Slides

  2. • Class exercises with solutions

  3. • Lab exercises

  4. • Comp 102 slides for revision (academic year 2010 - 2011)

Lectures: Tue: 14.00 to 15.00 (LIFS-LT3) Thu: 10.00 to 11.00 (SHER-LT1) Fri: 15.00 to 16.00 (SHER-LT1) Labs: One session per week in Lab 4, G. Holt Building, starting from week 3 (Week starting on October 10th).
Check your slot on Spider! Lab timetable: Mon: 12.00 - 13.00; 13.00 - 14.00 Tue: 10.00 - 11.00 Thu: 13.00 - 14.00; 15.00 - 16.00; 16.00 -17.00 Fri: 12.00 - 13.00; 13.00 - 14.00 Surgeries: Tue: 15.00 to 16.00 Thu: 11.00 to 12.00 Assignments: Assignment 1 (Deadline 11/11/2011); Assignment 2 (Deadline XX/XX/XX); Assessment weightings: 80% multiple choice exam; 10% Practical Assignment 1; 10% Practical Assignment 2.COMP207-Assignment1.htmlshapeimage_1_link_0

Demonstrators

Martyn Lloyd-Kelly, Luke Riley (room G.22)

Thomas Nickson (room 3.08)

Puteri Nor Ellyza Nohuddin (room 2.11)

Course admin

Assignments:

There are two assignments that attract 20% of the final mark.


Assignments submission

Assignments are handed in electronically, using the Departmental Electronic Submission system. More details will be posted later.

The naming convention for the assignment is to name the file as: YourSurname-AssingmentX.zip.

Announcements

  1. • Next lecture will take place on Oct 4th

  2. • Lab sessions will start in week 3 (October 10th)