IS2S551 - Information Systems Analysis and Design 2 01 Jul 2022 - 31 Aug 2028 | Version 3

Associated Module Information

Module Code: IS2S551
Module Title: Information Systems Analysis and Design 2
Faculty: Faculty of Computing, Engineering and Science
Faculty Group: Computing and Mathematics
Faculty Sub Group: Informatics
Module Leader: Alex Lohfink, Gaylor Boobyer
Module Team: Iain Shewring
First Intended Intake: Final Year of Intake:
Date Closed:
Credit Value: 20 Credit Level: 5
Language: English
Percentage of Module Taught in Welsh: 0
Equivalent Module:
HECOS codes: 100753 - systems analysis and design 100754 - databases 100755 - data management
HECOS Code Weighting: 30 30 40

Document Version Information

Version 3
Valid From 01 Jul 2022
Valid To 31 Aug 2028

Module Aims

To further develop the practical and intellectual skills needed to analyse and model data and processes for problems of a defined scope, to design and develop suitable information systems. This module develops in a professional manner analysis, design, production and evaluation of solutions to either small-scale unbounded or well-defined, more complex design and implementation problems in database development.

To be able to evaluate, review or test the quality of computing artefacts. The principles and role of quality management will be applied throughout the computer applications development life cycle. Relevant issues such as privacy legislation, database security will also be applied.

To demonstrate engineering skills in terms of: data representation and storage, methodologies and tools.

Content Summary

  • Overview of various system life cycles (waterfall, spiral, agile, etc.).
  • Techniques for requirements analysis, design and development of an information system.
  • Systems analysis: various techniques for investigating and defining user requirements. This will include techniques such as sampling hard data, interviewing, questionnaires and observation. The modelling techniques used in the analysis phase will build on those methods delivered by the year 1 modules.
  • Systems design: techniques for designing a relational database solution. Students will be taught to verify their database design by means of the normalisation process.
  • Systems development: techniques for developing a prototype from the design using a relational database system and development environment.

Learning and Teaching Methods

Activity Type Hours
Lecture 24
Tutorial 12
Practical classes and workshops 12
Independent Study 80
Directed Study 72
Total Hours Selected 200

Learning Outcomes

# Learning Outcome
LO1 To investigate the requirements for a system and to use modelling techniques in a variety of increasingly complex case studies to derive appropriate solutions.
LO2 To interpret a variety of system models in order to design a relational database and create a set of relational tables appropriate for the requirements of a system.

Module Requisites

N/A

Assessment Criteria

Assessment Category Assessment Type Description Duration Word Count Weight (%) Best of? Pass Mark
Asynchronous Assessment Practical Coursework 1 (Asynch) Development of a prototype information system 0 N/A 25 No 40
Asynchronous Assessment Portfolio 1 Analysis of a requirement and design of a solution comprising appropriate iterations 0 N/A 75 No 40

Assessment Matrix

Assessment Type Learning Outcomes
LO1 LO2
Practical Coursework 1 (Asynch)
Portfolio 1

Reading List

Connolly, T., and?Begg, C. (latest edition) Database Systems: A Practical Approach to Design, Implementation, and Management. Pearson Education:

Michael Alexander, M. and?Kusleika, R. (2019) Access 2016 Bible: The Comprehensive Tutorial Resource, John Wiley & Sons.?ISBN-?978-1119514756

Mendelsohn, E., Monk, E., and?Bradey. (2020) Problem Solving Cases in Microsoft Access and Excel. Cengage Learning?ISBN:?978-0-357-13863-2