Information Studies


INST0012 Database Systems Analysis and Design

This module aims to provide a sound understanding, both theoretical and practical, of basic systems theory, approaches to analysis, common methodologies, and the tasks of analysis and design in the context of developing computer-based information systems; the skills to apply such theory and methodologies, and to undertake such tasks; a clear knowledge of the various requirements for a successful methodology in the field; and confidence and skills to complete extended tasks using them.

Learning outcomes: By the end of the module, students will have an understanding of: basic systems theory; common SAD methodologies; feasibility studies and collecting data; recording and modelling processes; recording and modelling data; interpretation of data and requirements specifications. They will be able to analyse information systems in accordance with classic systems analysis techniques and to design, implement and maintain information systems/databases.

This module runs on Tuesday afternoons in Term 2. and a broad outline of content is given below.

Week 1 Introduction to Systems Analysis

Weeks 2-3 Process Analysis and modelling, dataflow diagramming

Week 4 Data analysis and modelling, Entity-Relationship modelling

Week 5 - Normalisation

Week 6 Reading Week

Week 7 - data modelling exercises and review

Weeks 8-11 Project tutorials

Assessment: Assessment by coursework only
Compulsory for: MSc Information Science
Optional for: MA LIS, MA ECP, MA/MSc DH, MA ARM. This module is also available for short course students

Preliminary reading:
Yeates, D., Shields, M. & Helmy, D. (eds.), Systems analysis and design. Pitman, 1994 (now sadly OOP)
Skidmore, S. & Eva M. Introducing systems development. Palgrave Macmillan, 2004
Connolly, T & Begg, C. Database systems : a practical approach to design, implementation, and management 5th ed. Addison-Wesley, 2010
Bowman, K. Systems Analysis: a beginner's guide. Palgrave Macmillan 2004
Harrington, Jan, Relational database design clearly explained 3rd ed. Morgan-Kaufman, 2009

Prerequisites: There are no formal prerequisites for this module
Taught by: Andy Dawson
Further information for students currently taking this module