Module Overview

Database Fundamentals

The aim of this module is to provide learners with: - A basic grounding in relational database technology - A knowledge and understanding of good database design - A knowledge and understanding of the basic functions of a DBMS, transaction processing and SQL query processing

Module Code

COMP H1029

ECTS Credits


*Curricular information is subject to change

Relational Data Model

Basics of relational data model, its terminology, ANSI-SPARC three-layer architecture, relational concepts (primary key, functional dependency, foreign key, candidate key, nulls)

Database Design

Entity-relational modelling (entity types, entities, attributes, types of relationships, optionality), construction of relational tables from ER diagrams, normalisation of a database to 3rd normal form

Table Manipulation

Create tables, drop tables, alter tables, set up relationships between tables, define primary and foreign keys using a GUI


Data Manipulation (inserts, updates & deletes) Data Retrieval (Select statements, functions, joins)

Transaction Processing

Security and Data Integrity - Failure types, Integrity, ACID properties, Backup & Recovery, Data Validation, Concurrency Control, Implementation of Concurrency Control, Locking, Deadlock

Module Content & Assessment
Assessment Breakdown %
Formal Examination50
Other Assessment(s)50