INST2005: DATABASE SYSTEMS

The purpose of this module is to provide an overview of the theory and practice of database systems: data and database analysis, design, use and management, with particular emphasis on relational systems.

Inter alia the module will cover: data investigation, representation and organisation; metadata; conceptual modelling; entity-relationship modelling; normalization of data; relational databases and relational algebra; query languages; SQL; database implementation; database management systems; database administration; security and performance issues; data on the web and related issues.

Learning outcomes: By the end of the module, students will be able to analyse, specify, design and implement a data management system. They will have a thorough grasp of the theory and practice of relational database systems, and how this relates to the general needs of an organisation..

Assessment: Assessment is by coursework (20%) and an unseen written examination (80%).

Compulsory for: BSc Information Management for Business.

Optional for: This module is not currently open to other students.

Prerequisites: Year 1 of the BSc Information Management or BSc Information Management for Business programmes.

Taught by: Andy Dawson.

Further information for students currently taking this module.