module specification

CC2006 - Data Modelling and Database Systems (2017/18)

Module specification Module approved to run in 2017/18, but may be subject to modification
Module title Data Modelling and Database Systems
Module level Intermediate (05)
Credit rating for module 15
School School of Computing and Digital Media
Assessment components
Type Weighting Qualifying mark Description
Coursework 50%   Design & Implementation
Unseen Examination 50%   Two hour exam *FC*
Running in 2017/18 No instances running in the year

Module summary

Introduces techniques for analysing, designing and implementing database systems. An
understanding of data modelling and design concepts is provided and database programming language skills are taught.The practical aspect of developing database systems is emphasised and use is made of a popular, commercial database system (e.g. Oracle) for this purpose.

Prior learning requirements

Introduction to Programming (CC1006N / CC1F06N)
Business and Information Systems (CC1001C)

Module aims

The principal graduate attribute focused on in the module is A2.
The module aims to give an introduction to the issues governing the design and implementation
of database systems. The module provides an introduction to both the theoretical aspects of designing sound database systems as well as the practical aspects of implementing such systems. The module, therefore, allows students to understand, and put into practice, the techniques available for analysing, designing and developing database systems [A2].


Databases and Database Management Systems: architectural framework, data independence.

Data analysis and modelling: conceptual data model notation, Entity-Relationship modelling, normalisation theory.

Database models: historical background, hierarchical, network, relational models.

Relational database theory: the model and its terminology, primary/foreign keys, integrity constraints, logical schema transformation.

Relational Database languages: querying, insertion, deletion, update, views and reporting with SQL.

Relational Algebra: algebriac operations, reference to SQL.

Learning and teaching

Formal lectures (1 hour per week) will be delivered where the aim will be to communicate theoretical aspects of data analysis and design. Students will gain knowledge of the techniques available for database design during these lectures. In order to augment the lecture material and give students the opportunity to apply these techniques, there will be weekly tutorial sessions (1 hour) which will be conducted in the form of group discussions or individual exercises – the choice depending on the type of material to be covered.

This module develops practical knowledge of a DBMS and weekly workshop sessions (2 hours) will be designed to ensure that all students receive adequate hands-on experience of an appropriate package. In addition students will spend time on directed, unsupervised learning for which an indication of relevant material (book chapters, journals and other publications) will be given. Students should also explore the software package and gain proficiency at using it.

Learning outcomes

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

LO1 - Produce an Entity-Relationship model from a realistic problem specification [A2]
LO2 - Use formal design techniques (e.g. normalisation) to produce a database schema [A2]
LO3 - Design and implement a database system from a conceptual data model [A2]
LO4 - Manipulate and extract data residing in a database using relational algebra and SQL [A2]
LO5 - Discuss the relative merits of the relational environment [A2]

Assessment strategy

The assessment will consist of two components: an unseen examination (2 hours) and one coursework (10 to 20 learning hours).
The assessment strategy for this module represents the duality of the learning process for this subject. On the one hand, students need to be assessed on their ability to absorb and apply theoretical material such as design notation and modelling. Whilst on the other hand, students also need to be assessed on their ability to demonstrate practical proficiency of a popular DBMS environment. The learning outcomes encompass both theoretical and practical aspects and the assessment strategy needs to reflect both these elements.

The assessment strategy ensures that students can demonstrate practical knowledge (LO3, LO4) which they would have acquired during the workshop sessions, with the use of a practical coursework element. The assessment strategy also allows students to demonstrate their knowledge of theoretical aspects (LO1, LO2, LO5) of the subject area, such as relational algebra, with the use of an unseen examination.


Connolly, T. & Begg, C. Database Systems - A Practical Approach to Design, Implementation, and Management (2nd Ed.) Addison-Wesley 2005

Ritchie, C. Relational Database Principles (2nd Ed.) Continuum, 2002

Kroenke, D. Database Concepts, Prentice Hall 2003

McFadden, F. R., Hoffer, J. A. & Prescott, M. B. Modern Database Management (7th Ed.) Pearson, 2005

Shah, N. Database Systems Using Oracle, Prentice Hall 2002

Kline, K. with Kline, D. SQL in a Nutshell - A Desktop Quick Reference O'Reilly, 2001

Earp, R. & Bagui, S. Learning SQL A Sep-by-Step Guide using Oracle, Addison-Wesley, 2003