Modules

Core Module Information
Module title: Database Systems
SCQF level: 08:
SCQF credit value: 20.00
ECTS credit value: 10
Module code: SET08120
Module leader: Andreas Steyven
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:

The module covers these aspects of databases:Database theory: The relational model is a mathematical construct, and some of the basic concepts can be very useful in understanding the way the technology behaves. This is particularly true for the more technical students who go on to study data warehouses and data mining. Basic set theory and the ANSI-SPARC three level architectural model are covered in this part.Database design: A key skill for software engineers and for business analysts is to be able to create an efficient relational model of an application context. The design methods specific to relational databases including entity-relationship diagrams and normalisation are covered here.Database use: The most fundamental database skill is to be able to retrieve required data using well-designed queries. The main vehicle for this is SQL, and this theme is developed over all teaching weeks. As well as learning SQL in isolation using online teaching materials, you will also have access to a stand-alone database application where you can construct your own schema and design and perform your own SQL queries. As part of this theme, other uses of SQL will be introduced which demonstrate its relationship with programming and Web application design.Database administration: The database administrator (DBA) is a vital role in any information technology department. Some of the main DBA responsibilities will be examined as part of this theme, and you will carry out basic administrative tasks such as backing up and restoring databases. The use of scripts to automate database management processes will also be covered.Non-relational database systems: While the focus of the module is on relational databases you will learn about some alternatives technologies such as NoSQL.Security: You will learn about some of the threats to database security and availability. Access to a fast, secure enterprise-wide database is essential for many organisation. You will learn techniques to protect database resources from accidental or deliberate damage or disclosure; these include password hashing and SQL injection protection.
Learning Outcomes for module:

Upon completion of this module you will be able to

LO1: Describe database architecture with reference to current standards.

LO2: Design and implement a relational database schema using standard techniques.

LO3: Use standard languages to access and manipulate data.

LO4: Perform basic administrative operations on an example database platform.

LO5: Secure database systems against unauthorised access.
Full Details of Teaching and Assessment
2026/7, Trimester 1, Blended,
VIEW FULL DETAILS
Occurrence: 001
Primary mode of delivery: Blended
Location of delivery: MERCHISTON
Partner:
Member of staff responsible for delivering module: Andreas Steyven
Module Organiser:


Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)NESH Description
Face To Face Lecture 20 2 hour lectures covering a range of topics including database architectures, database design, query languages as well as database security.
Face To Face Practical classes and workshops 20 In the practical classes, students will engage in hands-on exercises to develop skills in working with databases, retrieving and manipulating information, designing and managing databases to enhance their understanding of the core concepts. These sessions also provide opportunity to engage with the teaching team on coursework related questions.
Online Guided independent study 160 A learning approach where students take responsibility for their own learning process, with support and direction from academics through tutorials and research assessments. This method combines the independence of self-directed study and practical lab implementation with the guidance of a structured framework provided by academic staff.
Total Study Hours200
Expected Total Study Hours for Module200


Assessment
Type of Assessment Weighting % LOs covered Week due Length in Hours/Words Description
Project - Practical 45 3~4 Week 7 HOURS= set of querys You create a set of queries which each reproduce a given output from a given database.
Project - Practical 35 1~2~3~4 Week 13 HOURS= varies Extending a given database to incorporate additional functionality. You create a set of artifacts that implement your extension as well as appropriate documentation, including proof of normalisation and ER diagrams.
Class Test 20 1~4~5 Week 13 HOURS= 40 mins 10 multiple choice questions via Moodle on campus
Component 1 subtotal: 100
Component 2 subtotal: 0
Module subtotal: 100

Indicative References and Reading List - URL:
SET08120 - Database Systems
 

Related information