Database Design and Technology

Aims

To examine critically selected techniques for modelling the data requirements of database applications at the conceptual level.

To develop and understand contemporary advanced issues of database design, with specific interest in the context of business intelligence.

For example how core concepts in databases may be applied and developed to solve research problems such as handling Big Data and Temporal Data.

To develop an informed appreciation of significant, current issues and trends in database systems.

Learning Outcomes

After completing the module the student should be able to:

1 Apply a range of conceptual data modelling techniques for the specification of data requirements and be able to select from among them those which are most appropriate to given application problems.

2 Apply advanced principles of the relational database model, data integrity and functional dependency to logical data design problems.

3 Explain and evaluate in detail how advanced large-scale database systems support business intelligence.

4 Critically evaluate the principles, problems and contributions of distributed database systems, object-oriented databases and further research topics in database systems.