Skip to main navigationSkip to main content
The University of Southampton

COMP2202 Database and Database Applications

Module Overview

Aims and Objectives

Module Aims

This module aims to give students an understanding of the role of database systems in information management, the theoretical and practical issues that influence the design, implementation and applications of database management systems and languages.

Learning Outcomes

Knowledge and Understanding

Having successfully completed this module, you will be able to demonstrate knowledge and understanding of:

  • Understand the role of database systems in information management
  • Understand the concept of data modelling
  • Understand the theoretical properties of relational databases
Subject Specific Intellectual and Research Skills

Having successfully completed this module you will be able to:

  • To be able to apply entity-relationship modelling
  • To be able to normalise data
  • To be able to use SQL to create, update and query a database


- Rationale behind Database Systems - Database Modelling using the Entity-Relationship Model - Database System Architecture - Data Models and Data Sublanguages - SQL - Database Management Issues: concurrency, security, integrity - Application of Database - No SQL databases

Learning and Teaching

Supervised time in studio/workshop12
Follow-up work16.5
Preparation for scheduled sessions16.5
Wider reading or practice50
Completion of assessment task12
Total study time150

Resources & Reading list

Elmasri, R. and S. Navathe (2007). Fundamentals of database systems. 

Connolly, T. M. and C. E. Begg. Database systems : a practical approach to design, implementation, and management. 

Rothwell DM (1993). Databases: An Introduction. 

Garcia-Molina, H., J. D. Ullman, et al (2009). Database systems: The Complete Book. 

Date CJ (2004). An Introduction to Database Systems. 


Assessment Strategy

The initial coursework will be online from week 1. However, a hand-in of the database design is required in week 3. Formative feedback and in-class discussion of an appropriate design will be given in week 4. This will then be used to answer the remaining part of the assignment. No engagement in the exercise will limit your understanding of the problem to be addressed.


MethodPercentage contribution
Database design and implement 20%
Examination 80%


MethodPercentage contribution
Examination 100%


MethodPercentage contribution
Examination 100%

Repeat Information

Repeat type: Internal & External

Share this module Share this on Facebook Share this on Twitter Share this on Weibo

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we will assume that you are happy to receive cookies on the University of Southampton website.