Module Catalogues

Database Development and Design

Module Title Database Development and Design
Module Level Level 2
Module Credits 5.00
Academic Year 2021/22
Semester SEM1

Aims and Fit of Module

To introduce students to the problems arising from concurrency in databases, and how they are solved; To introduce students to the problems arising from the integration of heterogeneous sources of information and the use of semi-structured data; To introduce students to non-relational databases; To introduce students to techniques for analysing large amounts of data.

Learning outcomes

A. Identify and apply the principles underpinning transaction management within DBMS.
B. Perform operations in SQL using advanced aspects of coding in this language.
C. Illustrate the issues related to Web technologies and DBMS and XML as a semi-structured data representation formalism.

D. Identify the principles underlying object relational models.
E. State the main concepts in data warehousing and data mining.

Method of teaching and learning

Students will be expected to attend three hours of formal lectures as well as to participate in one hour of supervised practical classes in a typical week. In addition, students will be expected to devote six hours of unsupervised time for reflection and consideration of lecture material and background reading.