IS1S451 - Information Systems Analysis and Design 1 01 Jul 2022 - 31 Aug 2028 | Version 3

Associated Module Information

Module Code: IS1S451
Module Title: Information Systems Analysis and Design 1
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: 4
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 40 30

Document Version Information

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

Module Aims

The module will provide students with an introduction to current practices in analysis and design tasks and techniques. It will provide the practical and intellectual skills needed to analyse and model data and processing for problems of a defined scope, and to design suitable information systems.

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.

The module will also introduce relevant issues such as computer security and privacy legislation, database security.

Content Summary

Information Systems Concepts:

  • The concept of information as a resource;
  • The properties of data and information;
  • Representation and presentation of information;
  • The implications of legislation for the protection of personal data, and for the use and misuse of information;
  • Basic database security.

Systems analysis:

  • Interpreting and analysing business scenarios;
  • User requirement elicitation and modelling;
  • Producing modelling diagrams that satisfy given business requirements;
  • Entity, relationship and attribute modelling;
  • The role of primary and foreign keys;
  • Introduction to process modelling.

Database design and implementation:

  • Mapping modelling diagrams to simple relational databases;
  • Designing simple databases;
  • Implementing simple prototype databases;
  • SQL data definition: setting up tables in a database management system;
  • SQL data manipulation: inserting and retrieving data from a simple database;
  • Conduct queries of various types, including spatial.

Information Systems Case Studies:

  • Good and bad practice;

GIS examples.

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 demonstrate relevant systems analysis, design and implementation skills required to produce an information system.
LO2 To analyse the requirements for an information system, and then design and implement a prototype system that satisfies these requirements.

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) Develop an information system for a real-world problem that demonstrates the use of simple and advanced queries. 0 N/A 60 No 40
Asynchronous Assessment Portfolio 1 Analysis of a requirement and design of a solution comprising appropriate iterations 0 N/A 40 No 40

Assessment Matrix

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

Reading List

Connolly, T., and Begg, C. (2015) Database Systems: A Practical Approach to Design, Implementation, and Management. Pearson Education: ISBN?978-0132943260

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