Module Details for the Academic Year 2018/2019

COMP2004J Databases and Info Systems

The Collection, organisation and storage of data are major tasks in many human activities and in every modern computing system. Computer-based information systems ensure that this data is permanently maintained, quickly updated and made accessible to users. Databases are essential components of computerised information systems. This is a module for all students interested in understanding how to design, develop and query databases. In this module students will learn the fundamentals of database models, database designing methodologies, database querying and database normalisation theory. They will learn details about the relational database model, relational query languages, the entity-relationship model for database design, and database normalisation. From a more practical point of view they will gain experience in building a relational database using a relational database management system (such as MySQL). Students will find these skills very useful in the development of any application requiring the storage and manipulation of data.

Show/hide contentOpenClose All

On completion of this module students should be able to formulate, explain and compare the fundamental database concepts; design a relational database (conceptual and logical design using entity-relationship and relational models); analyse a relational database table to verify that it is in normal form; implement and query a relational database. 
Item Workload




Autonomous Student Learning




Description % of Final Grade Timing
Continuous Assessment: < Description >


Varies over the Semester
Examination: < Description >


2 hour End of Semester Exam


This module is not passable by compensation

Resit Opportunities

End of Semester Exam


If you fail this module you may repeat, resit or substitute where permissible.

Module Requisites and Incompatibles

Equivalent Modules

Prior Learning

Curricular information is subject to change