Core Module Information
Module title: Database Systems

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

Module code: SET08420
Module leader: Andreas Steyven
School School of Computing, Engineering and the Built Environment
Subject area group: Computer Science


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.

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
2023/4, Trimester 1, 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: Andreas Steyven
Module Organiser:

Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)
Face To Face Lecture 24
Face To Face Practical classes and workshops 24
Independent Learning Guided independent study 152
Total Study Hours200
Expected Total Study Hours for Module200

Type of Assessment Weighting % LOs covered Week due Length in Hours/Words
Project - Practical 100 1, 2,3,4, 5 12 HOURS= 24.00, WORDS= 0
Component 1 subtotal: 100
Component 2 subtotal: 0
Module subtotal: 100

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