Skip to main navigationSkip to main content
The University of Southampton

COMP1204 Data Management

Module Overview

This module aims to: - Explain the role of database systems in information management - Introduce students to standard UNIX tools and techniques (e.g., vi editor, ed, sed and awk) - Develop the student's skills in the effective use of Unix tools for document preparation, software development and system administration - Introduce students to command line working and to help develop their appreciation of its strengths/weaknesses relative to GUIs

Aims and Objectives

Learning Outcomes

Knowledge and Understanding

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

  • The role of database systems in information management
  • The concept of data modelling
  • The relational model of data
  • The structure and facilities of the Unix system and its application to system tasks
Subject Specific Intellectual and Research Skills

Having successfully completed this module you will be able to:

  • Support the design and develop software making effective use of Unix based tools and facilities
  • Apply entity-relationship modeling
  • Normalise data
Subject Specific Practical Skills

Having successfully completed this module you will be able to:

  • Make effective use of data manipulation tools
  • Construct new tools using shell scripts, pipes and filters
  • Make effective use of markup languages
  • Use SQL to create, update and query a database


The Unix family of operating systems (Linux, BSD, OS X) - The Unix philosophy and environment; files, processes, pipes, filters and basic utilities - Data manipulation tools; editors, grep and other utilities - Scripting - Shells and shell programming - Program development tools Structured documents and markup languages - LaTeX - XML-based languages (HTML, DocBook) Database systems - Rationale behind Database Systems - Database Modelling using the Entity-Relationship Model - Data Models and Data Sublanguages - Practical SQL The Relational Model - Relations, domains, attributes, keys, dependencies - Normalisation

Learning and Teaching

Follow-up work18
Preparation for scheduled sessions18
Wider reading or practice45
Completion of assessment task11
Total study time150

Resources & Reading list

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

Garcia-Molina, H., J. D. Ullman, et al. (2009). Database systems : the complete book. 

Mike Joy, Stephen Jarvis and Michael Luck (2002). Introducing Unix and Linux. 

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. 



MethodPercentage contribution
Continuous Assessment 25%
Final Assessment  75%


MethodPercentage contribution
Set Task 100%


MethodPercentage contribution
Set Task 100%

Repeat Information

Repeat type: Internal & External

Share this module Share this on Facebook Share this on Twitter Share this on Weibo
Privacy Settings