Core Module Information
Module title: Advanced Database Systems

SCQF level: 09:
SCQF credit value: 20.00
ECTS credit value: 10

Module code: SET09107
Module leader: Taoxin Peng
School School of Computing, Engineering and the Built Environment
Subject area group: Computer Science
Prerequisites

Requisites: AND Pre-requisite: A database systems course using SQL and A software development course covering object-oriented techniques AND AND Pre-requisite: [Module SET07110] Foundations of Software Design and Development AND Pre-requisite: [Module SET08120] Database Systems

Description of module content:

Object-Relational Databases – data modelling techniques, querying, database implementation: practical utilisation of an advanced database management system to implement a non-relational data model. Data Warehouses – Why are data warehouses needed? Difference between data warehouses and traditional databases, data modelling techniques, implementation issuesBig Data Analytics – What is big data? Differences between big data and other databases, an introduction to big data analytics. Emerging database techniques.

Learning Outcomes for module:

Upon completion of this module you will be able to

LO1: Critically analyse and evaluate modelling and development methods/techniques in Object-Relational Databases.

LO2: Design and implement a non-relational data model.

LO3: Critically compare, analyse and evaluate methods/technologies in developing data warehouses.

LO4: Critically compare, analyse and evaluate different technologies in big data analytics.

LO5: Critically review a selection of emerging database technologies.

Full Details of Teaching and Assessment
2024/5, Trimester 1, Blended,
VIEW FULL DETAILS
Occurrence: 001
Primary mode of delivery: Blended
Location of delivery: MERCHISTON
Partner:
Member of staff responsible for delivering module: Taoxin Peng
Module Organiser:


Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)NESH Description
Face To Face Centrally Time Tabled Examination 2 Centrally Time Tabled Examination
Online Guided independent study 158 Guided independent study
Face To Face Lecture 20 Lecture
Face To Face Practical classes and workshops 20 Practical
Total Study Hours200
Expected Total Study Hours for Module200


Assessment
Type of Assessment Weighting % LOs covered Week due Length in Hours/Words Description
Practical Skills Assessment 60 1~2~5 Week 10 HOURS= 40 hours Component 1 is a practical coursework (LOs 1, 2, 5), which assesses fundamentals and practical skills of object-relational databases.
Centrally Time Tabled Examination 40 3~4~5 Exam Period HOURS= 2 hours Component 2 is a central timetabled exam (LOs 3, 4, 5), which assesses fundamentals and theories of emerging database technologies, such as data warehouses, big data, and NoSQL.
Component 1 subtotal: 60
Component 2 subtotal: 40
Module subtotal: 100

Indicative References and Reading List - URL:
SET09107 Advanced Database Systems