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 analyzing large amounts of data.

Learning outcomes

At the conclusion of this module students should be able to
A identify and apply the principles underpinning transaction management within DBMS;
B demonstrate an understanding of advanced SQL topics;
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

The teaching philosophy of the module follows very much the philosophy of Syntegrative Education. This has meant that the teaching delivery pattern, which follows more intensive block teaching, allows more meaningful contribution from industry partners. This philosophy is carried through also in terms of assessment, with reduction on the use of exams and increase in coursework, especially problem-based assessments that are project focused. The delivery pattern provides space in the semester for students to concentrate on completing the assessments. Students will be expected to attend eight formal lectures, seminars as well as labs. In addition, students will be expected to devote time for unsupervised reflection and consideration of lecture material and background reading.