Analytical database models and design module (AC52040)
20
AC52040
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.
Assignments
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.