COMP3013 - Database and Information Management Systems

This database contains the 2017-18 versions of syllabuses. Syllabuses from the 2016-17 session are available here.

Note: Whilst every effort is made to keep the syllabus and assessment records correct, the precise details must be checked with the lecturer(s).

Code COMP3013 (Also taught as: COMPGC06 - Database Systems)
Year 3
Prerequisites Successful completion of years 1 and 2 of the computer science programme.
Term 2
Taught By John Dowell (50%)
Graham Roberts (50%)
Aims This module builds on the introduction to relational databases course in COMP202P. It covers advanced data modelling and database development methodology, the techniques exploited by relational database technologies relating in particular to query processing and transaction management, and post relational database technologies including object oriented databases and web databases. The coursework is an interesting group project lasting the duration of the term and building a web facing database system using very contemporary technologies.
Learning Outcomes Understanding of the theory, methods and technologies of relational databases and their development. Competence with SQL and in building web facing database systems. Understanding of application issues and current trends in database technologies.

Content

  1. The database management system
  2. Transaction Management
  3. Query processing
  4. Distributed databases
  5. SQL as data definition language
  6. Database implementation
  7. Data warehousing
  8. OLAP and Data mining
  9. Semi structured data
  10. New data models

Method of Instruction

The ‘theory lectures’ are provided by online videos watched weekly in advance and followed up by tutorial-style lectures. Weekly ‘project tutorials’ are provided by conventional lecture presentation. Students also attend a weekly lab session in which they carry out the group project coursework. 

Assessment

The course has the following assessment components:

  • Written Examination (2.5 hours, 70%);
  • Coursework Section (1 piece, 30%).

The examination rubric is:
Answer any 3 Questions out of 5. All questions carry equal marks.

To pass this course, students must:

  • Obtain an overall pass mark of 40% (50% for MEng students) for all components combined;
  • Obtain a minimum mark of 30% in each component.

Resources

Reading list available via the UCL Library catalogue.