Analytical database models and design module (AC52040)
The Module Co-Ordinator is
If you want to talk about an aspect of the module or your work on it, please make an appointment to see the lecturer.
If you use email, please include "AC52040" in the heading.
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
- BI architecture
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.
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.