Core Module Information
Module title: Database Systems

SCQF level: 11:
SCQF credit value: 10.00
ECTS credit value: 5

Module code: SET11101
Module leader: Peter Barclay
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 provides a broad introduction to database technology, including architecture and functionality, data analysis and entity-relationship modelling; database design (normalisation), querying and SQL. We will also address database management, including security and optimisation, and review current trends in database technology. The module is practically oriented, and will focus on designing, implementing, and querying a database system.

Learning Outcomes for module:

Upon completion of this module you will be able to

LO1: Analyse and implement a relational database schema.

LO2: Apply current techniques, languages and tools for database development.

LO3: Critically appraise the role of a database and the functions which should be provided by a database management system and the database administrator.

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


Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)NESH Description
Face To Face Lecture 10 Lecture to present main points of each unit and set context for the practical work.
Face To Face Practical classes and workshops 10 Practical classes (labs) to design, implement and query a database system.
Online Guided independent study 80 Independent study of database concepts covered in the lectures and practices in the labs. Signposts for further study are given in Moodle, with feedback during lab sessions as required.
Total Study Hours100
Expected Total Study Hours for Module100


Assessment
Type of Assessment Weighting % LOs covered Week due Length in Hours/Words Description
Practical Skills Assessment 40 1~2 Week 7 HOURS= 5 hrs (approx) Analyse requirements and design a database for a given scenario.
Practical Skills Assessment 60 1~2~3 Week 13 HOURS= 16 hrs (approx) Implement a database system according to your design and run test queries against it.
Component 1 subtotal: 100
Component 2 subtotal: 0
Module subtotal: 100

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