Module title: Database Systems

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

Module code: SET11801
Module leader: Peter Barclay
School School of Computing
Subject area group: Software Engineering
Prerequisites

N/A


Description of module content:

This module covers core database techniques including relational including relational and NoSQL databases. The module will build on the School of Computing’s expertise in online database delivery (such as the SQA recommended SQL Zoo) to ensure the students understand how to store and retrieve data using several different tools. Database architectures, functionality, and entity-relationship modelling will be covered. The role of a Database Administration in the context of data science will be analysed. Finally, current trends in database technology will be explored. Topics include:
• Database theory.
• Database design.
• Database architecture and functionality.
• Date analysis and entity-relationship modelling.
• Normalisation for database design.
• SQL and relational algebra.
• NoSQL databases.
• Role of the database administrator.
• Current trends in database technology.
• Database security.

Learning Outcomes for module:

LO1: Critically analyse and evaluate database modelling and development approaches

LO2: Design, implement, and query a data model using a contemporary database management system

LO3: Critically compare and assess methods/technologies for managing large data sets

LO4: Critically review emerging database languages and technologies

Indicative References and Reading List - URL:

Please contact your Module Leader for details
Click here to view the LibrarySearch.