Skip to main content

Trinity College Dublin, The University of Dublin

Menu Search

Module Descriptor School of Computer Science and Statistics

Module CodeCS4D2A
Module NameInformation Management II
Module Short TitleN/a
Semester TaughtMichaelmas Term
Contact HoursLecture hours: 27
Lab hours: 0
Tutorial hours: 6
Total hours:33
Module PersonnelProf. Séamus Lawless, Prof. Vincent Wade
Learning Outcomes

Having completed the course the student will be able to:

  • Define and comprehend the theoretical and practical issues in the management, retrieval, organisation, indexing and storage of large quantities of data
  • Model data and analyse data relationships for exploitation within database management systems
  • Program a database management system for database creation, information retrieval and database management
  • Analyse and assess various database concurrency protocols and algorithms to assess their performance and relative appropriateness in differing operating environments.
  • Evaluate existing concurrency control algorithms and appropriate data structures for data management.
  • Understand data integrity and security and the approaches used to manage and maintain both.
  • Compare and contrast different Database management paradigms such as relational, NoSQL, in-memory and native web/linked data stores.
Learning Aims

This course is focused on the modelling of information and database system technology. More specifically, it focuses on state-of-the-art database technology, from both the user and systems perspectives.

From a system engineering perspective, the course examines the concepts and algorithms for: transaction processing, concurrency control, metadata representation, database security policies, integration of databases on the web and emerging database technologies.

From an information designer’s perspective, the course examines the theoretical model underpinning relational databases, functional dependency theory and normalisation (for information modelling), functional dependency modelling, implementation of databases and database applications.

Thus the course is intended to enable the students to design information models and implement these models in state of the art databases (relational and native web databases), as well as be able to analyse and evaluate approaches to information organisation, storage, transaction support and management.

Module Content

Specific topics addressed in this module include:

  • Overview of database systems and users
  • Database system concepts and architecture
  • Relational database management
  • Relational model
  • Functional dependency theory and normalisation
  • On-line module on SQL (relational database query language)
  • SQL/PL (SQL as a programming language)
  • Transaction processing
  • Query processing
  • Concurrency control
  • Database recovery
  • Security and authorisation
  • Software engineering for database applications and database development
  • Web databases
  • NoSQL and In-Memory Databases
Recommended Reading List

Fundamentals of Database Systems by Elmasri & Navathe (6th Edition) published by Addison Wesley;

Database Systems 5th Edition, Connolly & Begg, published by Addison Wesley.

Database Systems – The Complete Book, by Garcia-Molena, Ullman & Widom, published by Prentice Hall;

Module PrerequisitesNone
Assessment Details

% Exam: 75
% Coursework: 25
Alongside the lectures, a full online course on the application of database language SQL is delivered. This online course must be taken by all students taking this module. Project work which integrates the lectures, tutorials and online course accounts for 25% of the module’s overall mark. This project work mark includes measured usage of the online course as well as project submissions. Attendance at all lectures and tutorials is compulsory.

Module Website
Academic Year of DataN/a