Skip to main content

Database Management

Overview

  • Credit value: 15 credits at Level 6
  • Module convenor and tutor: Jerry Smallwood
  • Prerequisites: a first module in programming and a first module in analysis and design
  • Assessment: problem-solving worksheets (20%) and a two-hour examination (80%)

Module description

This module will familiarise you with the main concepts underlying database management, and in particular with the relational database model which is the dominant database system used in corporate IT departments.

The module has three main strands: fundamental concepts introduced using the entity-relationship model; querying a relational database; and relational database design.

    Indicative module content

    • Entity-Relationship Model
    • Relational Model
    • Querying Relational Databases using SQL
    • Updates, Views and Transactions
    • Integrity Constraints in the Relational Model
    • Relational Database Design
    • Non-Relational Databases
    • SQL Programming and the Web

    Learning objectives

    By the end of this module, you will:

    • understand database¬†concepts and, in particular, relational database technology
    • be able to produce an entity-relationship model from a real-world scenario
    • be able to formulate correct queries in SQL
    • be able to compare relational database designs in terms of desirable properties
    • be aware of the range of non-relational database systems.