Source: SCSA
Week 1
Introduction
- Overview
- Assessment requirements
KNOWLEDGE – SYSTEMS ANALYSIS AND DEVELOPMENT
Types of system development methodologies
- linear – waterfall/cascade
- iterative – rapid application development (RAD)
- advantages and disadvantages of linear and iterative system development methodologies
KNOWLEDGE – SYSTEMS ANALYSIS AND DEVELOPMENT
Week 2
- Preliminary Analysis
- problem definition
- feasibility study
- Analysis
- model of current system
- requirements of new system
- Design
- logical design
- physical design
- Development
- hardware and software acquisition
- construction and testing
- Implementation change-over methods;
- direct cut
- phased
- pilot
- parallel
- Evaluation and Maintenance
- performance evaluation
- fault finding and correction
Data gathering techniques used in the SDLC, including: observation, questionnaire, interview, sample forms, and sampling volume of work processed by system.
KNOWLEDGE – SYSTEMS ANALYSIS AND DEVELOPMENT
Project management Computer Aided Software Engineering (CASE) tools
- Gantt charts
- Program Evaluation Review Technique (PERT) charts
Systems development documentation as a part of the SDLC
- context diagrams using Yourdon/DeMarco notation
- data flow diagrams using Yourdon/DeMarco notation
- system manuals
- user manuals
SKILLS – SYSTEMS ANALYSIS AND DEVELOPMENT
Apply data gathering techniques and CASE tools
Analyse user and system documentation, including: Gantt charts, PERT charts, context and data flow diagrams
Create user and system documentation as a part of the SDLC
Apply context diagrams and data flow diagrams, using Yourdon/DeMarco notation, as a part of the SDLC
- detect errors in diagrams
- define system boundaries
- create accurate diagrams
- create context diagrams
- create Level 0 DFDs
- create Level 1 DFDs
KNOWLEDGE – SYSTEMS ANALYSIS AND DEVELOPMENT
Weeks 5-7
Appropriate hardware components for a computer system designed for a specific purpose
Purpose of a Standard Operating Environment (SOE)
Advantages and disadvantages of a SOE
- scheduling
- managing concurrency
- managing memory
- managing devices
- embedded
- stand alone
- server
Features of file systems, including:
- space management
- filenames
- directories
Role of the following components of the central processing unit (CPU)
- arithmetic logic unit (ALU)
- control unit (CU)
- registers
- program counter
- system clock
- data, address and control bus
Purpose of the fetch-execute cycle
Stages of the fetch-execute cycle
- fetch
- decode
- execute
- store
Purpose of processor architectures for different types of systems
- distributed
- sequential
- parallel
- multi-core
Purpose of using benchmarking to determine system performance:
- software
- hardware
- operating systems
Purpose of disaster recovery plans
Types of disaster recovery tools, including:
- online storage
- incremental backup
- full backup
- RAID (Level 0, 1, 10)
- uninterruptible power supply (UPS)
Types of platform virtualisation
- desktop virtualisation
- personal computer virtualisation
- server virtualisation
- storage virtualisation
Purpose of platform virtualisation with application virtualisation
Advantages and disadvantages of cloud computing
Convergence of technologies, including the continued development of mobile devices
Environmental issues related to the disposal of computer components
Methods for the secure disposal of data, including:
- physical destruction of media
- overwriting
Purpose of intellectual property in the development of ICT systems
Role of law and ethics in the use of ICT systems, including:
KNOWLEDGE - MANAGING DATA
Weeks 8-9
Types of physical storage of databases
- online
- local
- distributed
- centralised
Structure of data warehouses and data marts.
Compare data warehouses and data marts as methods of data storage and distribution.
Ethical implications of the use of data warehouses, data marts and data mining.
KNOWLEDGE - MANAGING DATA
Week 10
Database management system concepts, including:
- data definition
- data duplication
- data integrity, including: referential integrity, domain integrity and entity integrity
- data redundancy
- data anomalies, including: insert, delete and update
- data manipulation
- data security
Normalisation of data to 3rd normal form (NF)
SKILLS - MANAGING DATA
Normalise data to 3rd NF
KNOWLEDGE - MANAGING DATA
Week 11-14
Data modelling using Chen’s notation entity relationship (ER) diagrams
Purpose of database documentation for the user
- readability
- navigation
- logical order
- inclusivity
SKILLS - MANAGING DATA
Analyse existing ER diagrams.
Create accurate ER diagrams.
Create a model of a database solution using Chen’s notation entity relationship (ER) diagrams.
Create data dictionaries.
Create visual interface and navigation systems to assist users of a database.
Create database documentation for the user.
Normalise data to 3rd NF.
Resolve complex many to many (M:N) relationships in a multi-table relational database system (three or more entities).
Create a working relational multi-table database using:
- data types
- relations
- primary, composite and foreign keys
- referential integrity
- relationships, including: set cascade inserts, updates and deletes
- cardinality (1:1, 1:M, M:1, M:N)
- validation rules
- forms
- reports
- simple queries using SQL (up to two tables), including insert, update and select queries
- queries across multiple tables using appropriate database tools, including the following: parameter, calculated field, concatenated field, aggregation, append, update, delete and make table.
Apply simple programmed control structures, including IF statements and calculations within the database.
Found an error or enhancement? Please use the contact form under the Home menu item.