Modules

Core Module Information
Module title: Database Systems
SCQF level: 11:
SCQF credit value: 20.00
ECTS credit value: 10
Module code: SET11801
Module leader: Oluwaseun Bamgboye
School School of Computing, Engineering and the Built Environment
Subject area group: Computer Science
Prerequisites

There are no pre-requisites for this module to be added
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:

Upon completion of this module you will be able to

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.
Full Details of Teaching and Assessment
2024/5, Trimester 3, Online (fully o,
VIEW FULL DETAILS
Occurrence: 001
Primary mode of delivery: Online (fully o
Location of delivery: WORLDWIDE
Partner:
Member of staff responsible for delivering module: Oluwaseun Bamgboye
Module Organiser:


Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)NESH Description
Independent Learning Tutorial 10 The session serves as online support session to assist student in understanding the taught concepts from the Module.
Independent Learning Practical classes and workshops 20 Student will be required to spend time engaging with the various module resources and tools by working on all the practical assignments and reflective exercises in each unit
Online Guided independent study 170 Student will engage in self-directed study while reading to understand the contents of each unit of the Module on weekly basis and also use the opportunity to work on the coursework
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 40 1~2 Week 6 HOURS= max. 2000 words Students will test their understanding of the relational algebra using some set of relational schema. They will apply the structured query language to perform some selection operations on a specific relational table
Centrally Time Tabled Examination 60 1~2~3~4 Week 13 HOURS= max 3500 words Student will Normalize the given schema and develop this into a working database using the Structure Query Language. Critical evaluation of the developed database will be completed and compared to non-relational databases.
Component 1 subtotal: 40
Component 2 subtotal: 60
Module subtotal: 100

Indicative References and Reading List - URL:
SET11801 Database Systems
 

Related information