This module is offered in 2020-21.

Aims

The aims of this module are:

  • To study database design.
  • To study data models.
  • To study database management systems.
  • To study database theory.

Learning Outcomes

On successful completion of this module, the student should:

  • Have gained knowledge and understanding of what is involved in the design of a database.
  • Have gained knowledge and understanding of the models used for structuring data in database systems.
  • Be able to implement a database and report on the process.
  • Be able to query a database.

Syllabus

  • Introduction
  • Data Models
    • Relational model
    • Entity-relationship model
  • SQL
    • Data Manipulation Language (DML)
    • Data Definition Language (DDL)
    • Data Control Language (DCL)
  • Database Implementation
  • Security and Integrity
    • Violation, authorisation and views, integrity constraints
  • Database Development Lifecycle
  • Database Design
    • Functional dependencies
    • Normalisation
  • Database System Development
  • Data Warehouses
  • Beyond the relational model
    • Business intelligence 
    • Data mining

Compulsory Elements

This module has no compulsory elements beyond those common to all modules (mark of 4 in each assessment component).

Module Delivery

Back to top

Last Published: 19 Oct 2020.