Skip to main content

Trinity College Dublin, The University of Dublin

Menu Search

Module Descriptor School of Computer Science and Statistics

Module CodeCS2104
Module Short Title
Semester TaughtHilaryTerm
Contact HoursOne semester, One 3 hr lecture/lab per week
Module PersonnelJoe McBride
Learning Outcomes

After successfully completing this module, students will be able to:

  • Describe the database systems used in different types of organisations and explain how they contribute to the effective operation of business processes.
  • Carry out all stages of the database life cycle, demonstrating best practice in the methods used at each stage.
  • Model data requirements and translate them into workable relational database structures using normalisation and other appropriate design techniques.
  • Design and implement relational databases and data warehouse systems, loading data from a variety of sources and producing useful outputs to meet stated business needs.
  • Explain key concepts of database management including data integrity, concurrency control, security and recovery.
  • Compare the traditional relational database with wider database concepts such as distributed databases, data warehousing and object oriented databases.
Learning Aims

This module equips students with the skills to analyse information structures and design data architectures. Students explore a variety of storage models and techniques but focus mainly on the relational database. Students are taken through the full database life cycle and full embrace the areas of Entity-Relational modelling, normalisation and SQL. Students also learn about fundamental database management issues such as integrity, security and recovery. The module also covers the wider database arena such as distributed databases, data warehousing and object oriented databases.

Module Content
Recommended Reading List

Coronel , R. (2007) Database Systems (Design, Implementation & Management) (7th Ed.), Thomson, ISBN 9781418836504.

Module PrerequisitesNone
Assessment Details

All of above assessment details are yet to be confirmed.

Module Website
Academic Year of Data2014/15