Analytical database models and design module (AC52040)

On this page


Module code


Semester: Summer

About the Module

This module aims to give students an awareness of dimensional modelling and design, as well as giving an introduction to other models and designs. Students will be introduced to how analytical requirements can be turned into a data model through the introduction of user, logical and physical models of analytical systems. You will learn about:

  • Physical Models
  • Star Schema
  • Hierarchical change
  • Speed of response
  • Implementation
  • BI architecture

Credit Rating

There are 20 SCQF points available on this module.

Assessment and Coursework

Coursework counts for 40% of the final module mark.
The final degree exam counts for 60% of the final module mark.


Marking criteria are provided on My Dundee for all assignments, so that you know what we are looking for when we are marking your coursework. Please ensure that you refer to these when completing assignments.

Title Value (%)
Bitmap assignment 40

Resource List

All course material will be available on My Dundee. This includes copies of lecture materials, practical exercises, and assignments. The reading list for this module can be accessed from My Dundee, and provides recommended materials for completing the module.