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
Subject area group: Software Engineering

Module code: INF08104, SET08108

Examples of equivalent learning : A database systems course using SQL or A software development course covering object-oriented techniques

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 issues

Big 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
2020/1, Trimester 2, BLENDED, Edinburgh Napier University
Occurrence: 001
Primary mode of delivery: BLENDED
Location of delivery: MERCHISTON
Partner: Edinburgh Napier University
Member of staff responsible for delivering module: Taoxin Peng
Module Organiser:

Learning, Teaching and Assessment (LTA) Approach:
Learning & Teaching methods including their alignment to LOs
Students will be expected to do self-oriented research and provide a critical analysis and evaluation of much of the theories behind these subjects (LOs 1, 3, 4, 5). Teaching will concentrate on the critical analysis of that information and on practical implementation (LOs 1-5). Students are expected to spend large portion of their time to do comprehensive reading and practising. Tutorial and practical materials are well organised and selected for enhancing students’ understanding of the theories/principles covered.

Formative Assessment:
To Support formative feedback, the Software Engineering subject group utilise a lab based teaching approach across their provision. During these lab sessions, staff will discuss and evaluate student progress and provide feedback on how well they are progressing with their work. All modules in the subject group also require students to demonstrate their coursework on submission to provide further formative feedback on how the work could be improved.

Summative Assessment:
Assessment (formative or summative)
Assessment will include a formal examination and one set of practical coursework (LOs 1, 2, 5). Basically, fundamentals and theories will be tested in the exam (LOs 1, 3, 4, 5), while the practical skills will be assessed by the coursework (LOs 1, 2, 5).

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

Type of Assessment Weighting % LOs covered Week due Length in Hours/Words
Practical Skills Assessment 60 1,2,5 12 HOURS= 40, WORDS= 0
Centrally Time Tabled Examination 40 1,3,4,5 14/15 HOURS= 2, WORDS= 0
Component 1 subtotal: 60
Component 2 subtotal: 40
Module subtotal: 100

Indicative References and Reading List - URL:
Contact your module leader