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
Prerequisites

Module code: INF08104, SET08108

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

2018/9, Trimester 2, Face-to-Face, Edinburgh Napier University
Occurrence: 001
Primary mode of delivery: Face-to-Face
Location of delivery: MERCHISTON
Partner: Edinburgh Napier University
Member of staff responsible for delivering module: Simon Powers
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.

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).


Formative Assessment:
The University is currently undertaking work to improve the quality of information provided on methods of assessment and feedback. Please refer to the section on Learning and Teaching Approaches above for further information about this module’s learning, teaching and assessment practices, including formative and summative approaches.

Summative Assessment:
The University is currently undertaking work to improve the quality of information provided on methods of assessment and feedback. Please refer to the section on Learning and Teaching Approaches above for further information about this module’s learning, teaching and assessment practices, including formative and summative approaches.

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


Assessment
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

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

Indicative References and Reading List - URL:

Core - T. CONNOLLY AND C. BEGG (2009) DATABASE SYSTEMS: A PRACTICAL APPROACH TO DESIGN, IMPLEMENTATION, AND MANAGEMENT: ADDISON-WESLEY, 5th ed.
Core - A SILBERSCHATZ, H KORTH AND S SUDERSHAN (2011) DATABASE SYSTEM CONCEPTS: MCGRAW HILL, 6th ed.
Core - S. W. DIETRICH AND S. D. URBAN (2005) AN ADVANCED COURSE IN DATABASE SYSTEMS: BEYOND RELATIONAL DATABASES: PEARSON EDUCATION, INC, 0 - ISBN: 0130428981
Core - M. MINELLI, M. CHAMBERS AND A. DHIRAJ (2013) BIG DATA, BIG ANALYTICS: EMERGING BUSINESS INTELLIGENCE AND ANALYTIC TRENDS FOR TODAY'S BUSINESSES: WILEY, 1st ed. - ISBN: 9781118147603
Click here to view the LibrarySearch.