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

Module Aims

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

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 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
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

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
Tutorial12
Revision10
Preparation for scheduled sessions18
Wider reading or practice45
Lecture36
Completion of assessment task11
Follow-up work18
Total study time150

Resources & Reading list

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

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

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

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

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

Assessment

Summative

MethodPercentage contribution
Coursework 15%
Coursework 10%
Exam  (2 hours) 75%

Referral

MethodPercentage contribution
Exam 100%

Repeat Information

Repeat type: Internal & External

Share this module Facebook Google+ Twitter 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.

×