Module Content

This module introduces the student to:

1. Interactions between the stakeholders and analysts in the specification of information systems
2. The techniques of information gathering and representation using appropriate tools and techniques
3. The process of database design using normalisation
4. The role of the Database Management System
5. The design and implementation of robust database systems

Introduction and Concepts of Systems Analysis
Role of the Analyst
Acquisition of knowledge from stakeholders
Gathering of existing knowledge: Sampling, Interviewing, Questionnaire design, Investigation, Observation, etc.
Project Life Cycles
The Systems Development Life Cycle
Agile Life Cycles
Modelling
The use of UML and associated diagramming tools for modelling systems with diagrams such as Use Cases, Class Diagrams, State Transition Diagrams, Sequence Diagrams and Activity Diagrams
Introduction to Databases
Database Concepts and Models
The role of the Database Management System
Database design using normalisation to 3NF
Structured Query Language (SQL)
Data Integrity, Protection and Security
Input and Output Devices
Security and Backup
Testing and review techniques
The module content may vary according to current knowledge, trends and practices.

Teaching Methods

A combination of lectures with tutorial / practical sessions.
The aim of the module is to develop the investigative and analytical skills that will enable students to progress to more advanced levels of systems analysis. The module will provide an interactive and stimulating learning environment, and will explore the nature of systems, and the notion of the systems design process.
Students will develop the knowledge and skills necessary to use, design and implement a reasonably complex system.
Lectures will cover theory and will be used to introduce concepts, techniques, and information. Tutorial/Practical classes will reinforce the learning from the lectures and will enable students to practise and discuss systems analysis and design techniques such as Use Case Diagrams and Class Diagrams, questionnaire design, etc. individually and in small groups. Students will investigate relevant topics using the Internet, make use of appropriate tools for analysis, and the use of software such as MySQL for implementation of designs.
The assessment will comprise a portfolio of worksheets that will document the development of systems analysis and database design skills. Group work may be used to allow students to appreciate the benefit of good communication, share experiences and value the user’s needs.

Assessment Methods

This module is assessed through an examination and a portfolio.