Skip to main navigationSkip to main content
The University of Southampton
Courses

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

Syllabus

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

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

Resources & Reading list

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

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

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

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

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

Assessment

Summative

MethodPercentage contribution
Continuous Assessment 25%
Final Assessment  75%

Repeat

MethodPercentage contribution
Set Task 100%

Referral

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