Module Overview

Database Systems 1

This course will cover the objectives of database management systems, the fundamentals of data modelling using entity relationship diagrams, normalization rules, and database design. The aim of the module is to enable students to identify user requirements, produce data models and design database systems that are realistic, flexible and efficient using a number of standard methodologies.

Module Code

ITEC 1006

ECTS Credits


*Curricular information is subject to change

Database management systems;  data modelling; Entity Relationship Diagrams; SQL; implementation of complex relationships between entities; database nornalisation; building database systems;

Database management systems

Introduction to DB management system, its functionalities, advantages and disadvantages of using a DBMS.

Data modelling

Data modelling in the database design process. Different data models used in a DBMS. Introduction to Relational model which is used in RDBMS.

Entity Relationship Diagrams

Concepts in ER: entities, relationship. Using ERD to represent the data aspect of a software system/database application.

Structured Query Language

DML (Select, Insert, Update, Delete data) - complex query, nested query. DDL

Data Normalisation

The necessity of data normalisation. Normalisation process, 1NF, 2NF, 3NF.

Design and implementation of database application

Using the current DBMS, create DB, create form, report, query.

The module will be taught using lectures, laboratory sessions and sample case studies

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