The University of Southampton
Courses

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

Syllabus

- 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

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

Resources & Reading list

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

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

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

Rothwell DM (1993). Databases: An Introduction. 

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

Assessment

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.

Summative

MethodPercentage contribution
Database design and implement 20%
Exam 80%

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.

×