INSTG007 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. NB classes do not start until week 3, after the completion of MA LIS placements.
(Weeks 1 & 2 no classes)
Week 3 - Introduction to systems analysis
Weeks 4-5 Process analysis and modelling, Dataflow digramming
Week 6 - Reading week
Weeks 7-9 Data analysis and modelling, Entity-relationship modelling, Normalisation
Weeks 10-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
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
Page last modified on 05 jul 13 15:44