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.