Skip to content Search
Search our website:

Database Management

Short name: DM
SITS code: COIY028H6
Credits: 15 credits
Level: 6
Module leader: Peter Wood
Lecturer(s): Peter Wood

Aims

To familiarise students with the main concepts underlying database management, and in particular with the relational database model which is the dominant database system used in corporate IT departments. The course has three main strands: (1) Fundamental concepts introduced using the entity-relationship model, (2) Querying a relational database, and (3) Relational database design.

Syllabus

  • Entity-Relationship Model
  • Relational Model
  • Querying Relational Databases using SQL
  • Updates, Views and Transactions
  • Integrity Constraints in the Relational Model
  • Relational Database Design
  • Normal Forms
  • Normalisation Algorithms
  • Non-Relational Databases
  • SQL Programming and the Web

Prerequisites

A first module in programming and a first module in analysis and design.

Timetable

All dates and timetables are listed in the programme handbooks of individual programmes.

Assessment

By 2-hour written examination and practical coursework, weighted 80% and 20% respectively.

Recommended reading

  • J.D. Ullman and J. Widom, A First Course in Database Systems. Third edition, Prentice Hall, 2008.
  • A.B. Silberschatz, H.F. Korth and S. Sudarshan, Database System Concepts. Sixth edition, McGraw-Hill, 2011.
  • T. Connolly and C. Begg, Database Systems: a practical approach to design, implementation and management. Fifth edition, Addison Wesley, 2010.