Module Information

Module Identifier
Module Title
Modelling, Managing and Securing Data
Academic Year
Semester 1
CSM0120 Must take CSM0120 or have prior experience of programming, preferably in Python
Reading List

Course Delivery



Assessment Type Assessment length / details Proportion
Semester Assessment 6 Hours   Online in-class assessments  will examine database and data modelling knowledge  30%
Semester Exam 2 Hours   Exam  The end of module exam will examine matters concerning Information Security.  70%
Supplementary Assessment 6 Hours   Online assessments  will examine database and data modelling knowledge  30%
Supplementary Exam 2 Hours   Exam  The end of module exam will examine matters concerning Information Security.  70%

Learning Outcomes

On successful completion of this module students should be able to:

Design and structure databases appropriate to given problems, identifying potential issues of data persistence, resilience, security and verification of systems that process the data.

Evaluate the legal, social, ethical and professional issues involved in handling data.

Identify potential security issues with specific types of computer systems and the data they contain, and suggest mitigating strategies.

Brief description

Many of the issues with the storing and handling of data are process-based. The data is not represented or stored appropriately, or ad hoc processes are used to produce results, or insufficient thought is put into how the data is made available or to whom. The module will look at a range of issues related to performance and security in the context of computer systems. It will address not only confidentiality and privacy of data but also the integrity of data and techniques for guaranteeing reproducible results.


This module gives students a technical understanding of the computing issues relevant to data modelling, management and security. It forms a firm foundation for later modules on practical issues in information security and in data mining (MSc Data Science).


1. Introduction to data handling: modelling, processing, and security. Case studies of issues in handling data.

2. Social, legal and professional issues with data and software. People in the system. Business drivers for software systems. Overview of relevant computer law. Ideas of security, resilience, testing, maintenance.

3. Relational modelling and data storage. Persistent storage. Entities and relationships. Primary and foreign keys. Referential integrity. Relational algebra. Data normalisation. Overview of SQL. Validating a design.

4. Application Security issues: Database security, Big Data security, identity management, programming issues. Physical security.

5. Cryptography and system security: Cipher and algorithm types; applications to confidentiality, integrity and authentication; Key management; Digital Signatures. Authentication (secrets, tokens, biometrics); Access Control and Privilege management.

Module Skills

Skills Type Skills details
Application of Number Inherent to subject
Communication Through assignment
Improving own Learning and Performance Inherent to subject
Information Technology Inherent to subject
Personal Development and Career planning Encourages students to see roles in subject for career and personal development
Problem solving Inherent to subject
Research skills Inherent to subject
Subject Specific Skills Technical skills related to internet systems and security


This module is at CQFW Level 7