INF6050   Database Design   (15 credits)

Description

Effective data management is key to any organisation, particularly with the increasing availability of large and heterogeneous datasets (e.g. transactional, multimedia and geo-spatial data). A database is an organised collection of data, typically describing the activities of one or more organisations and a core component of modern information systems. A Database Management System (DBMS) is software designed to assist in maintaining and utilising large collections of data and becoming a necessity for all organisations. This module provides an introduction to the area of databases and database management, relational database design and a flavour of some advanced topics in current database research that deal with different kinds of data often found within an organisational context. Lectures are structured into three main areas: An introduction to databases, The process of designing relational databases, Advanced topics (e.g. data warehouses and non-relational databases) The course includes a series of online tasks with supporting 'drop in' laboratories aimed at providing you with the skills required to implement a database in Oracle and extract information using the Structured Query Language (SQL).

Reading List