University of London

Small Navigation Menu

Primary Menu

Pre-requisites / co-requisites

This course cannot be taken with withdrawn course CO2205.

Topics covered

  • Introduction to Database Systems (motivation for database systems, storage systems, architecture, facilities, applications)
  • Database modelling (basic concepts, E-R modelling, Schema deviation)
  • The relational model and algebra, SQL (definitions, manipulations, access centre, embedding)
  • Physical design (estimation of workload and access time, logical I/Os, distribution). Modern database systems (extended relational, object-oriented)
  • Advanced database systems (active, deductive, parallel, distributed, federated)
  • DB functionality and services (files, structures and access methods, transactions and concurrency control, reliability, query processing).

Assessment

One three-hour unseen written examination and coursework.

Sample study materials